UPDATE/REPLACE Problem

[cyronuts]

Good morning,

Can't seem to get my code to update a record in a table of the database. Basically, I have a form that is pre-populated, and I allow the user to change data in the fields that should then overwrite whatever is currently in that field. I am using the following query:

mysql_select_db("online_db");
$query = "UPDATE global_settings SET ('".$POST['owner_name']."', '".$POST['owner_address']."', '".$POST['owner_city']."', '".$POST['owner_state']."', '".$POST['owner_postal']."', '".$POST['owner_country']."', '".$POST['owner_phone']."', '".$POST['owner_fax']."', '".$POST['owner_email']."', '".$POST['owner_email_flag']."', '".$POST['fulfill_email']."', '".$POST['fulfill_email_flag']."', '".$POST['title_text']."', '".$POST['com_site_name']."', '".$POST['cookie_dom']."', '".$POST['cookie_path']."', '".$POST['design_firm']."', '".$POST['design_firm_url']."')";

$result = mysql_query($query);
if ($result)

admin_header();
echo "<FONT FACE='ARIAL' SIZE='1' COLOR='0000FF'> <BR><BR>Thank you. Your new Global Settings have been saved to your database.<BR></FONT>";
global_settings_form();
do_html_footer();

Can't figure out what I am missing, thanks a million.

Craig

[jwalk76]

are you inserting or updating? if you are updating each field needs to be specified as column = 'value'.

"UPDATE global_settings SET column1 = '".$_POST['owner_name']."', column2 = '".$_POST['owner_address']. etc. etc. etc."

also, this will update every field for each specified column in your entire database unless you end the query with something like:

WHERE column1 = 'value'

[cyronuts]

Thanks for the reply, now I am getting a weird parse error:

mysql_select_db("book_sc");
$query = "UPDATE global_settings SET owner_name = '".$_POST['owner_name']."';

Do you see anything wrong here?

Thanks, Craig

[cyronuts]

NEVERMIND,

ALL IS WELL IN PHPVILLE.

Thanks for your help (I was missing a ")

Craig