can someone check my sql syntax please?!
by "Sue Bailey" <sue(at)bartandsue.co.uk>
|
| Date: |
Wed, 31 May 2000 10:59:23 +0100 |
| To: |
<hwg-languages(at)hwg.org> |
| |
todo: View
Thread,
Original
|
|
Hi. Can someone have a look at this and see if they can see what the syntax
error is, because my eyes are crossing from looking at it!
Cheers,
Sue
$searchStmt = "SELECT * from $tableName WHERE ";
---snip some other bits that work fine! ---
if(isset($search_word)){
for($i = 0; $i < count($search_word); $i++) {
$searchStmt .= "long_desc LIKE '$search_word[$i]' ";
if ($i < count($search_word) -1)
{$searchStmt .= " AND ";
}
}
}
HWG: hwg-languages mailing list archives,
maintained by Webmasters @ IWA