MySQL gurus in here now please. - GoFuckYourself.com

Nookster · 02-25-2007, 01:15 PM

So I've been trying to get a damn search option to work with one of my mainstream projects for the past day or so but it's just not working. Here's the query I'm using:

Quote:

$trysrch = @mysql_query("select * from table_name where item_name like '$srch' || item_name2 like '$srch' || item_name3 like '$srch' && area = '$place' order by item_name asc");

Looks fine right? According to documentation this should work. Well, all of the selects for the OR (||) work, but once it gets to the AND part it seems to just overlook it and doesn't do anything. It does finish successfully (as in no errors) but it doesn't use the AND part (doesn't further narrow the results by executing the actual logic).
My questions: Why doesn't this work? What am I doing wrong if it's wrong?
This has been frustrating the shit out of me.

Thanks to all who will be kind enough to reply.

tical · 02-25-2007, 01:17 PM

put the OR parts in parenthesis, i think that should fix it

$trysrch = @mysql_query("select * from table_name where (item_name like '$srch' || item_name2 like '$srch' || item_name3 like '$srch') && area = '$place' order by item_name asc");

WarChild · 02-25-2007, 01:18 PM

You don't understand how "OR" works. Read more grasshopper, read more.

WarChild · 02-25-2007, 01:21 PM

I believe your statement is being evaluated like this:

item_name like '$srch'
OR
item_name2 like '$srch'
OR
item_name3 like '$srch' AND area = '$place' order by item_name asc

Nookster · 02-25-2007, 01:27 PM

Quote:

Originally Posted by tical

put the OR parts in parenthesis, i think that should fix it

$trysrch = @mysql_query("select * from table_name where (item_name like '$srch' || item_name2 like '$srch' || item_name3 like '$srch') && area = '$place' order by item_name asc");

Thank you very much. It works great now.

Guess I should read more.

BT · 02-25-2007, 01:28 PM

go fuck your self

02-25-2007, 01:17 PM	#2
tical Confirmed User Join Date: Feb 2002 Location: Las Vegas Posts: 6,504	put the OR parts in parenthesis, i think that should fix it $trysrch = @mysql_query("select * from table_name where (item_name like '$srch' \|\| item_name2 like '$srch' \|\| item_name3 like '$srch') && area = '$place' order by item_name asc"); __________________ 112.020.756

02-25-2007, 01:18 PM	#3
WarChild Let slip the dogs of war. Industry Role: Join Date: Jan 2003 Location: Bermuda Posts: 17,263	You don't understand how "OR" works. Read more grasshopper, read more. __________________ .

02-25-2007, 01:21 PM	#4
WarChild Let slip the dogs of war. Industry Role: Join Date: Jan 2003 Location: Bermuda Posts: 17,263	I believe your statement is being evaluated like this: item_name like '$srch' OR item_name2 like '$srch' OR item_name3 like '$srch' AND area = '$place' order by item_name asc __________________ .

02-25-2007, 01:28 PM	#6
BT Confirmed User Join Date: Apr 2002 Location: Ft liquordale FL Posts: 6,481	go fuck your self __________________ IS Prime Hosting Bald Head Shine "BT" The American Dream, baby! " THE HOST WITH THE MOST!" My ICQ 122994792