Did you actually echo the $sql?
I know it works right now, but try to take away the quotes around the
value 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 the
result. Also let us know the data type of the ID column.
On Wed, Sep 3, 2008 at 11:21 AM, David DURIEUX <[EMAIL PROTECTED]> 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 : [EMAIL PROTECTED]
> 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" <[EMAIL PROTECTED]> 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
>
>
