Did you actually echo the $sql?
I know it works right now, but try to take away the quotes around thevalue in the query and see if something happens:
$sql = "SELECT * FROM table WHERE id={$var}";
If that doesn't work then var_dump($sql, $var) and write us theresult. Also let us know the data type of the ID column.
On Wed, Sep 3, 2008 at 11:21 AM, David DURIEUX <d.durieux@xxxxxxxxxxxxx> wrote:> At the begining $var is $_GET['id'] and after I try directly $var = 10> but no changes.>> On the server directly, I can only try with the values :> $sql = 'SELECT * FROM table WHERE id="10" '; and for this no problem.>> The problem is when I use a variable in query>>> Best regards,>> David DURIEUX> Tel : 04.74.04.81.34> Port : 06.34.99.45.18> Mail : d.durieux@xxxxxxxxxxxxx> Site Web : http://www.siprossii.com/>> SIPROSSII> 847 route de Frans (Créacité)> 69400 Villefranche sur Saône>>>> Le Wed, 3 Sep 2008 11:13:11 +0200> "Evert Lammerts" <evert.lammerts@xxxxxxxxx> a écrit:>>>> $sql = 'SELECT * FROM table WHERE id="'.$var.'" ';>>> $req = mysql_query($sql) or die('Erreur SQL>>> !<br>'.$sql.'<br>'.mysql_error());>>> while($data = mysql_fetch_assoc($req)) {>>> echo $data['id'];>>> }>>> $sql2 = 'DELETE FROM table WHERE id="'.$var.'" ';>>> $req2 = mysql_query($sql2) or die('Erreur SQL>>> !<br>'.$sql2.'<br>'.mysql_error());>>>>I'll ask the obvious: where and how is $var set, and did you echo your>>$sql variable to try the query on your mysql server directly?>>>>> --> PHP Database Mailing List (http://www.php.net/)> To unsubscribe, visit: http://www.php.net/unsub.php>>
