Hi,
Can anyone tell me why this is not updating my databse?
<?
require('../config.inc');
// connect to database
$cid = mysql_connect($host,$usr,$passwd);
$select_db = mysql_select_db($db);
// processed when form is submitted back onto itself
if ($REQUEST_METHOD=="POST") {
// make sure all fields have something in them
while(list($key, $value) = each($HTTP_POST_VARS)) {
if ($value == "") {
$value = "*";
}
$$key = $value;
}
// setup SQL statement
$SQL = " UPDATE title SET";
$SQL = $SQL . " page_name = '$page_name', ";
$SQL = $SQL . " background_url = '$background_url', ";
$SQL = $SQL . " WHERE id = '1' ";
// execute SQL statement
$result = mysql_db_query($db,"$SQL",$cid);
// check for errors
if (!$result) {
echo("ERROR: " . mysql_error() . "\n$SQL\n");
} else {
$uconfirm = "Information Updated!";
}
} else {
$sql = "select * from title";
$result = mysql_query($sql);
while ($directory = mysql_fetch_array($result)) {
$page_name=$directory['page_name'];
$background_url=$directory['background_url'];
}
}
?>
This is my error message:
ERROR: You have an error in your SQL syntax near 'WHERE id = '1' ' at line 1 UPDATE title SET page_name = 'Dillenger X: Version 3.0', background_url = 'www.simplebit.com/dillenger/images/back1.jpg', WHERE id = '1'
What am i doing wrong?
