MySQL Help Needed

AZKyleP

Hello All,

$con=mysql_connect("localhost","user","password");
mysql_select_db("database", $con);
$select="SELECT * FROM table WHERE status=1";
$result=mysql_query($select);
while($row=mysql_fetch_array($result))
{
$r=$row['id']."<BR>";
echo $r;
}
mysql_close($con);

The above code works and displays the results fine.

But if I change status=1 to usr=person I get an error message:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

I tried usr='person', usr="person", and usr=personbut nothing works.

And I need usr=person for my script to work...

dagon

usr ='person' is valid

change the table name calling a table 'table' is terrible
is there a field called 'usr' in the table?

AZKyleP

dagon;10936837 wrote:
usr ='person' is valid

change the table name calling a table 'table' is terrible

is there a field called 'usr' in the table?

I just used the table named table for examples purposes.

Yes, the field usr is in the table.

AZKyleP

Also I'm using PHP 5.2.10 and MySQL 5.0.88.

Here is the table design:
CREATE TABLE IF NOT EXISTS messages (
id varchar(20) NOT NULL,
date datetime NOT NULL default '0000-00-00 00:00:00',
from varchar(25) NOT NULL,
to varchar(25) NOT NULL,
subject varchar(50) NOT NULL,
message varchar(250) NOT NULL,
status varchar(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

AZKyleP

Problem fixed! MySQL didn't like the row being called "to". So I changed it to something else and it worked. 🙂

dagon

it's a reserved word, as is table

http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

AZKyleP

Thanks for your help dagon! I will bookmark that list. 🙂

bradgrafelman

Don't forget to mark this thread resolved, if it is.

As dagon points out, you have to be careful about what names you use for identifiers (databases, tables, columns, views, etc.) as there are some common choices in that reserved words lists.

The common advice is to just avoid using those reserved words altogether, although you can use them if you surround the identifier in backticks (`) in MySQL (or double quotes if ANSI_QUOTES is enabled).