for($i = 0; $i < sizeof($check); $i++) { # start repating query # turn pictures in order delete capability off mysql_query("UPDATE kodak_user_pictures SET order=1 WHERE ID='$check[$i]'") # turn off pictures or die ('Unable to turn bit off '.mysql_error()); } # end repeat
You have an error in your SQL syntax near 'order=1 WHERE ID='2'' at line 2 - Victor > www.argilent.com ______________________________________________________________________ Post your ad for free now! http://personals.yahoo.ca -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php