Re: Probleme with MySQL queries

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@siprossii.com 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@gmail.com> 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? >