query help

[digital44]

I'm having trouble running a simple record lookup on a loaded database. any help would be appreciated. my test search word is O'Malley's which is definitely in the database. I've also tried running queries on other existing records with no luck (ex. Bar Celona)

This is the error message I keep getting:

Please input your search criteria: SELECT * FROM barGuide WHERE name = O\'Malley\'s ORDER BY barGuide.name You have an error in your SQL syntax near '\'Malley\'s ORDER BY barGuide.name' at line 1

here is a snippet query code:

mysql_select_db("mydb",$db);

if($name) {
$query = "SELECT * FROM barGuide WHERE name = $name ORDER BY barGuide.name";
}//end name if

[bastien]

queries for text need single quotes around the variable

$query = "SELECT * FROM barGuide WHERE name = '$name' ORDER BY barGuide.name"; 

[digital44]

Ok. I'm not getting anymore errors, but no results are displaying either.

mysql_select_db("mydb",$db);

if($barType) {
$query = "SELECT * FROM barGuide WHERE barType = '$barType' ORDER BY barGuide.barName";
}//end barType if

elseif($neighborhood) {
$query = "SELECT * FROM barGuide WHERE neighborhood = '$neighborhood' ORDER BY barGuide.barName";
}//end neighborhood if

elseif($barName) {
$query = "SELECT * FROM barGuide WHERE barName = '$barName'";
}//end name if

elseif($zipCode) {
$query = "SELECT * FROM barGuide WHERE zipCode = $zipCode ORDER BY barGuide.barName";
}//end zipCode if

$result = mysql_query($query) or die ("Please input your search criteria: $query ".mysql_error());

if (!$myrow = mysql_fetch_array($result)) {
printf("Sorry. No search results where found.");
}//end if

else {
while ($myrow = mysql_fetch_array($result)) {

printf("<table width=600 border=0 cellpadding=0 cellspacing=5><tr align=left valign=top><td width=600 align=left valign=top class=regulars><b>%s</b> (%s) %s, %s</td></tr>", $myrow["barName"], $myrow["barOffering"], $myrow["address"], $myrow["phone"]);

printf("<tr align=left valign=top><td width=600 align=left valign=top class=regulars>%s</td></tr></table><hr align=center width=590 size=1 noshade>", $myrow["blurb"]);

}//end while
} //end else

[bastien]

try having a look at the query to make sure it is wellformed and all the parts are correct, commas, quotes etc

//before you execute the query add this line

echo $query;

$result = mysql_query($query) or die ("Please input your search criteria: $query ".mysql_error()); 

[digital44]

SELECT * FROM barGuide WHERE barName = 'O\'Malley\'s'

the record is actually listed as O'Malley's
maybe the additional slashes are causing the problem?

[bastien]

yes it is...

try

$query=stripslashes($query);

//then run the query
echo $query;

$result = mysql_query($query) or die ("Please input your search criteria: $query ".mysql_error());