MySQL update
Posted: Mon Sep 27, 2004 2:58 pm
YAY! Another question from me 
I'm trying to update all mysql fields which have been submitted in an post-form.
The problem is that I don't know if the following is possible, or how it's done;
The query i try to run which (obviously) doesn't work:
Here's the code which generates the query:
Any ideas?
I'm trying to update all mysql fields which have been submitted in an post-form.
The problem is that I don't know if the following is possible, or how it's done;
The query i try to run which (obviously) doesn't work:
Code: Select all
UPDATE `settings` SET `value`='404' WHERE `key`='404', `value`='start' WHERE `key`='homepage', `value`='0' WHERE `key`='last_update', `value`='tpl/v2.tpl' WHERE `key`='main_template', `value`='1' WHERE `key`='open', `value`='ї vigge.net - {%title%} ]' WHERE `key`='title'Code: Select all
<?php
############### updating ###############
if (!empty ($_POST['edit_settings'])) { // edit form has been submitted
###### format form and set variables
foreach ($_POST as $key => $value) $_POST[$key] = addslashes ($_POST[$key]); #### add slashes to data
########## update data ##########
foreach ($_POST as $key => $value) if ($key != 'edit_settings') $query['usettings'] .= ", `value`='$value' WHERE `key`='$key'";
$query_set = ltrim ($query['usettings'], ",");
if (mysql_query ("UPDATE `settings` SET $query_set")) {
$msg .= "Succesfully updated settings<br />";
} else {
$msg .= "<span style='color: red;'>Could not update settings</span><br />";
}
######### /update data ##########
} // edit form has been submitted
############## /updating ###############
?>