[Resolved] death by SELECT

[kenhess]

I created a db from a sql load...project, id, and server
id is primary key, auto increment

I added about 400 records to it via php pages...all is cool.

when I run a:

$sql = "select * from PROJECTS where Server = '$SYSTEM' ";

it always comes back with an error..couldn't execute query (my die message).

but if I use either Project or ID in the where part...it works fine.

in mysql> I can do the queries fine...with wildcards and everything.

I can also send sql commands from dbtools, etc. just doesn't work with Server in PHP.

HELP!!!!

[hermand]

Use die(mysql_error()) instead, and tell us what the error is!

[cgraz]

Change your code to this:

$sql = "select * from PROJECTS where Server = '$SYSTEM'"; 
print $sql . "<br>";

$result = mysql_query($sql) or die(mysql_error());

by printing the string, you'll know if your variable is being passed properly. by using mysql_error() (rather than your own error message which is useless for error checking because it doesn't tell you the problem) will tell you what the problem is.

Cgraz

[kenhess]

Here is my mysql command and response:

mysql> select * from PROJECTS where Server = 'BART';
+----------+-----+--------+
| Project | ID | Server |
+----------+-----+--------+
| FOOD_BEV | 184 | BART |
+----------+-----+--------+
1 row in set (0.01 sec)

Here is the printed error:

SELECT * FROM PROJECTS where Server = 'BART'
Unknown column 'Server' in 'where clause'

This is very odd.

[hermand]

Case sensitive..?

[kenhess]

It is working ok now...I just recreated the db. I had created that one from an sql statement...all is well...thanks for the help everyone.