$result = mysql_query ("UPDATE gallery set thumb_url = '$thumb_url', url = '$url', detail = '$detail', by = '$by', location = '$location', taken = '$taken' where id = $id") or die("INSERT error: ".mysql_error());
I get this error
INSERT error: You have an error in your SQL syntax near 'by = '', location = 'Auckland', taken = '' where id = 8' at line 1
what could be wrong, i more fields in the database but i'm not updating them on this page (they have nothing to do with my script and any point) so i have not included them in the code
