Syntax error here why?..

codefreek · 08-09-2008, 12:20 PM

PHP Code:


			
function approve($items) {

$cat = mysql_real_escape_string($_POST['category']);

   $ids = implode(",",$items);

    $sql = "UPDATE news

        SET valid = 1 AND cat_id = $cat

        WHERE id IN (".$ids.")";

mysql_query($sql) or die(mysql_error());



}

Syntax error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id IN (6)' at line 3

codefreek · 08-09-2008, 06:06 PM

No comments?

Aaron · 08-09-2008, 06:22 PM

How did you get that query to work with spaces around the '='? :P It gives me an error.

Speaking of which, have you tried to get rid of the space after IN?

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 . ')';

codefreek · 08-09-2008, 07:37 PM

I fixed it..
Thank you anyways..
The fix was in the form a small error and
also '' around the vars.

Codefreek.

localhost · 08-12-2008, 06:39 PM

You could also do it like:

PHP Code:


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