[Rss_Feeds]

heyi am making a settins thingfor the charity site im doing... and i oly noticedafter a twea because i realised it wasnt touching the db why... im using PHP:---------$what_to_update = ''; switch ($sub) { case 'general': $what_to_update = "title='$title', donations='$donations', sitesearch='$sitesearch', siteurl='$siteurl', showlogo='$showlogo', webmaster_email='$webmaster_email', general_email='$general_email'"; break; case 'meta': $what_to_update = "meta_author='$meta_author', meta_keywords='$meta_keywords', meta_robots='$meta_robots'"; break; case 'footer': $what_to_update = "footer1='$footer1', footer2='$footer2', footer3='$footer3'"; break; case 'style': $what_to_update = "style='$sitestyle'"; break; case 'error': $what_to_update = "error_status='$error_status', error_404_level='$error_404_level'"; break; case 'sitelock': $what_to_update = "sitelock='$sitelock', sitelock_msg='$sitelock_msg'"; break; case 'news': $what_to_update = "latest_news='$latest_news'"; break; } $result = mysql_query("UPDATE settings SET $what_to_update WHERE id='1'", $link_db) or die ('Error updateing. Conatct admin. SQL ERROR: '.mysql_error());--------- that to decie whats being updated, but im getting the following error.Code:---------Error updateing. Conatct admin. SQL 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='1'' at line 1--------- plz help its probally something simple. but i have no clueDan


To view links or images in this forum your post count must be 1 or greater. You currently have 0 posts.