doing a mysql query with AND connector

[yahoo182]

Hi there, I have a single line of sql statement and it works just fine

$fetchid = @mysql_query("select * from tomapping where TOID='$toid'");

However, when I try to use the AND clause to narrow down my search result, I get an error saying that there is something wrong near " but I do not see what is worng with the statement.

$fetchid = @mysql_query("select * from tomapping where TOID='$toid' AND HotelName='$hotelname' ");

 

[LTeeple]

Just for fun, try this:

$fetchid = @mysql_query("select * from tomapping where TOID='$toid' AND HotelName='".$hotelname."' ");

Cheers!
Laura

 

[yahoo182]

Hi there,
That worked just fine! Its so strange though. Why did my previous one not work?
Is there something to do with the single, double quotes in PHP?

But thanks LTeeple.

 

[DRJ478]

Your statement looks perfectly ok as is.

It could have been that the hotelname contained a single quote: O'Leary, Smackers' Choice?

To prevent that you should escape the content of the parameters with mysql_real_escape_string().

Further: Stay away from the @ operator and add some useful error checking to the statement.

$result = mysql_query($SQL) OR die("Query error: ".$SQL." ::".mysql_error());