Several UPDATE's and more than one condition in one query?
Posted: Tue Jan 17, 2006 4:29 pm
Hi, anyone knows how could I put this in only one query?
Thanks.
Code: Select all
dbsys_query("UPDATE et_system_settings SET setting_value='$website_title' WHERE setting_name='site_name' ");
dbsys_query("UPDATE et_system_settings SET setting_value='$admin_email' WHERE setting_name='emailsender' ");
dbsys_query("UPDATE et_system_settings SET setting_value='$path_to_create/assets/images/' WHERE setting_name='im_plugin_base_dir' ");
dbsys_query("UPDATE et_system_settings SET setting_value='$website_url/assets/images/' WHERE setting_name='im_plugin_base_url' ");
dbsys_query("UPDATE et_system_settings SET setting_value='$path_to_create' WHERE setting_name='filemanager_path' ");