problem w/ php mysql syntax

[croakingtoad]

here's what I have-
[code]
$query = mysql_query("SELECT * FROM $table WHERE mls = $MLS") or die(mysql_error());
[/code]

I'm getting the error-
[code]
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 'WHERE mls = 701555' at line 1
[/code]

What am I doing wrong?

[bbaker]

$query = mysql_query("SELECT * FROM $table WHERE mls = [b][!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--]'[!--colorc--][/span][!--/colorc--][/b] $MLS [b][!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--]'[!--colorc--][/span][!--/colorc--][/b] ") or die(mysql_error());

[croakingtoad]

I changed mine to match your suggestion but I still get the error--
[code]
$query = mysql_query("SELECT * FROM $table WHERE mls = '$MLS'") or die(mysql_error());
[/code]

[code]
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 'WHERE mls = '701555'' at line 1
[/code]

[.josh]

you sure mls is an integer type data type?

[croakingtoad]

that's what it was, i had it as varchar

[croakingtoad]

Okay, maybe not... I changed it in the DB from varchar to int and empties the DB then ran the script to put data back into it and I am still getting that error. Any other ideas?

[AndyB]

[code]$query = mysql_query("SELECT * FROM $table WHERE mls = '$MLS'") or die("Error: ". mysql_error(). " with query ". $query);[/code]
That way you can see the actual query being used that results in the error.

[croakingtoad]

That didn't give much more info--

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 'WHERE mls = '701555'' at line 1 with query

What's strange is when I type the query into SQLyog--

SELECT * FROM flex_residential WHERE mls = 701555

it returns the correct result...

I'm such an idiot, nevermind. I wasn't passing a required variable to the url to satisfy a switch I had right above this code that gives the value of $table.

Sorry for my Friday dumbness!

[nogray]

Try to add the `` quotes around the table name and the mls like this
[code]
$query = mysql_query("SELECT * FROM `$table` WHERE `mls` = '$MLS'") or die("Error: ". mysql_error(). " with query ". $query);
[/code]

Sometimes this does the trick for me