primary field name

[regan]

Hello,

This is really bugging me and I know it will be a really easy fix. What I am trying to do is run the following mysql_query:

$temp = mysql_query("SELECT * FROM client_contacts WHERE primary='1'", $db);
while ($con = mysql_fetch_array($temp)) {
echo $con[name];
}

In the database primary is an "INT" and there is one entry in it that has a value of 1. I don't see what the problem is here... I have verified the name of the field and everything, please help me!

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/regan/web/protekcs/admin/new/windows/cu/edit.php on line 57

What is wrong with my query? Is there some reason why I cannot use primary as a field name?

Thanks for your help!

-Regan

[mrhappiness]

$temp = mysql_query("SELECT * FROM client_contacts WHERE primary='1'", $db) or die(mysql_error()); 

try this

what happens now?

[regan]

I changed the field name to primary_flag and it started working. There must be some sort of problem with the 'primary' field name. I tried the mysql_error() and it did not output anything. I think it is a problem with php and not SQL. Oh well, I am running now, thanks for your help!

-Regan

[mrhappiness]

just looked it up at http://www.mysql.com/doc/en/Reserved_words.html: primary is a reserved word so you should not use it

seems to be mysql and not php that caused the problem