Re: Probleme with MySQL queries
| From: | Evert Lammerts | Date: | Wed, 03 Sep 2008 09:13:11 +0000 |
| Subject: | Re: Probleme with MySQL queries | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-45306@lists.php.net to get a copy of this message | ||
> $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?