All pastes #189504 Raw Edit

Something

public php v1 · immutable
·published 2006-10-03 03:42 UTC
rendered paste body
$remove = array_diff($old_cat, $new_cat);print_r($remove);$sql = "DELETE FROM apparel_categories WHERE apparel_id=\"{$_POST['id']}\" AND category_id=\"$remove[]\""; $deleted = mysql_query($sql); if(!$deleted){	throw new Exception("While saving category (-), you got a mysql error: ".mysql_error($db)."<br>\$sql was:".$sql.'');}$add = array_diff($new_cat, $old_cat);print_r($add);$sql = "INSERT INTO apparel_categories (apparel_id, category_id) VALUES (\"{$_POST['id']}\", \"$add[]\")"; $added = mysql_query($sql);if(!$added){	throw new Exception("While saving category (+), you got a mysql error: ".mysql_error($db)."<br>\$sql was:".$sql.'');}