Page 1 of 1

Having Trouble With MYSQL String

Posted: Mon Nov 20, 2006 11:33 am
by snowrhythm
This is probably a simple problem, but I need a quick solution and I can't find it anywhere so far. The string below doesn't work:

Code: Select all

$sqlString =  "SELECT DATA1, DATA2, DATA3 FROM TABLE WHERE DATA1 LIKE "%x%" AND WHERE DATA2 LIKE "%y%" AND WHERE DATA3 LIKE "%z%" ORDER BY DATA1 ASC";
anyone know what's wrong with my syntax? Thanks for any help.

Re: Having Trouble With MYSQL String

Posted: Mon Nov 20, 2006 11:36 am
by AKA Panama Jack
snowrhythm wrote:This is probably a simple problem, but I need a quick solution and I can't find it anywhere so far. The string below doesn't work:

Code: Select all

$sqlString =  "SELECT DATA1, DATA2, DATA3 FROM TABLE WHERE DATA1 LIKE "%x%" AND WHERE DATA2 LIKE "%y%" AND WHERE DATA3 LIKE "%z%" ORDER BY DATA1 ASC";
anyone know what's wrong with my syntax? Thanks for any help.
Change it to...

Code: Select all

$sqlString =  "SELECT DATA1, DATA2, DATA3 FROM TABLE WHERE DATA1 LIKE "%x%" AND DATA2 LIKE "%y%" AND DATA3 LIKE "%z%" ORDER BY DATA1 ASC";
You only need one WHERE argument.

Posted: Mon Nov 20, 2006 12:29 pm
by snowrhythm
aha, thanks much mr. jack.