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";Moderator: General Moderators
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";Change it to...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:
anyone know what's wrong with my syntax? Thanks for any help.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";
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";