Mysql syntax problem - using "where"

Texteri

Hi
Here is the mysql code i'm using to update a database:

$con = mysql_connect("localhost","username","password");
mysql_select_db("db", $con);
$result = mysql_query("SELECT * FROM Add WHERE adder=\"$username\"");
$numResults = mysql_num_rows($result);
if ($numResults > 0) {
while($row = mysql_fetch_array($result)){
echo "<a href=\"/".$row[username]."><".$row[username]."</a>";
}
}
if ($numResults = 0) {
echo "$username hasn\'t added anyone";
}

This is the error I'm getting:

Fatal error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Add WHERE username="82"' at line 1 in /home/public_html/folder/index.php on line 246

Lines 245 - 247:

if ($numResults > 0) {
while($row = mysql_fetch_assoc($result)){
echo "<a href=\"/".$row[username]."><".$row[username]."</a>";

Any ideas why this is happening??
Thanks in advance

NogDog

Something or someone is confused here. The error message refers to WHERE username= in the query, but that does not appear in the query in your first PHP excerpt. The second excerpt does not have any query being executed at all, so either those are not the actual lines being referenced by the error message, or the wrong file (or maybe you're looking at local version that does not match the version actually running on the server?).

bradgrafelman

Also note that 'ADD' is a MySQL Reserved Word, thus it is not advisable to use it as an identifier. However, if you must, then you will also need to delimit it (e.g. using backticks by default in MySQL).

Texteri

@ that was it, thanks 🙂

bradgrafelman

Glad I could help; don't forget to mark this thread resolved (if it is) using the link on the Thread Tools menu above.