TalkPHP - View Single Post

Kalle · 08-09-2008, 06:40 PM

Im sure its because you didn't quote the row/table names so they will act as keywords to the query, try this:

PHP Code:


			
$sql = 'UPDATE `news` SET `valid` = 1 AND `cat_id` = ' . $cat . ' WHERE `id` IN (' . $ids . ')';

08-09-2008, 06:40 PM	#4 (permalink)
Kalle The Frequenter Join Date: Sep 2007 Location: Denmark Posts: 352 Thanks: 8	Im sure its because you didn't quote the row/table names so they will act as keywords to the query, try this: PHP Code: $sql = 'UPDATE `news` SET `valid` = 1 AND `cat_id` = ' . $cat . ' WHERE `id` IN (' . $ids . ')'; __________________