mySQL keyword in query, how to handle?
Posted: Sun Oct 29, 2006 10:38 am
Hey all.. I have a query that goes something like this:
$itemResult[0] might possibilty contain a SQL keyword, like from.. How can I handle this?
Thanks
David
Code: Select all
"UPDATE ItemInformation SET ItemUsed = 1, LastItem = 1 WHERE GameNumber = `$row[0]` AND
TeamNumber = $innerRow[2] and Item = $itemResult[0]";Thanks
David