GoFuckYourself.com - Adult Webmaster Forum - View Single Post

raymor · 09-23-2004, 11:58 PM

Try printing out the query, as it's seen by MySQL:
$query = "SELECT * FROM Table WHERE description like '%$search%' OR description like '%$search2%' order by ID limit 0,144"
print "query: $query\n";

Also what does "it doesn't work" mean?
Do you get an error message? If so, what does it say?
DO you just not get the results you expected?

I suspect that if you read the query that gets printed
aloud and translate it into English you'll see where your problem is.
I could just tell you, but I'd rather teach you how to find it.

09-23-2004, 11:58 PM
raymor Confirmed User Join Date: Oct 2002 Posts: 3,745	Try printing out the query, as it's seen by MySQL: $query = "SELECT * FROM Table WHERE description like '%$search%' OR description like '%$search2%' order by ID limit 0,144" print "query: $query\n"; Also what does "it doesn't work" mean? Do you get an error message? If so, what does it say? DO you just not get the results you expected? I suspect that if you read the query that gets printed aloud and translate it into English you'll see where your problem is. I could just tell you, but I'd rather teach you how to find it. __________________ For historical display only. This information is not current: support@bettercgi.com ICQ 7208627 Strongbox - The next generation in site security Throttlebox - The next generation in bandwidth control Clonebox - Backup and disaster recovery on steroids Last edited by raymor; 09-24-2004 at 12:01 AM..