Code: Select all
if ($_POST) {
$query = "UPDATE reminders SET ";
if (!empty($_POST["type"])) {
$query .= "type = '$_POST[type]',";
}
if (!empty($_POST["view"])) {
$query .= "view = '$_POST[view]',";
}
if (!empty($_POST["message"])) {
$query .= "message = '$_POST[message]',";
}
if (!empty($_POST["preRemMess"])) {
$query .= "preRemMessage = '$_POST[preRemMess]',";
}
$query .= "WHERE id = '$_POST[id]'";
echo $query;
mysql_query($query) or die(mysql_error());
}This is what my typical failing query looks like:
Code: Select all
UPDATE reminders SET type = 'yo',WHERE id = '105'
Regards, Stephen