02-04-2010, 05:46 AM
You forgot to add a comma.... try this query and take a look at the end of the third line.
Code:
$edit_id = (int) $_POST['id'];
$sql = "UPDATE `coin_info` SET `date` = '{$_POST['date']}',";
$sql .= "`price` = '{$_POST['price']}',`condition` = '{$_POST['condition']}',`year` = '{$_POST['year']}',";
$sql .= "`silver` = '{$_POST['silver']}',`gold` = '{$_POST['gold']}',`weight` = '{$_POST['weight']}', ";
$sql .="`description` = '{$_POST['description']}' ";
$sql .= "WHERE `id` = '{$edit_id}' LIMIT 1 ;";