mySQL syntax error?
I'm running the script below on a php 4.3.4 server, and it's updating the db, but it's also dying and giving the mySQL syntax error= "Query Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '= ''' at line 1"
I can't seem to figure it out - works, but throws the die error..... the code is below
V
<?
function Location($URL, $addToken = 1) {
$questionORamp = (strstr($URL, "?"))?"&":"?";
$location = ($addToken)?$URL.$questionORamp.$SID:$URL; //append the sessionID ($SID) by default
ob_end_clean(); //clear buffer, end collection of content
if(headers_sent()) {
print('<META http-equiv="Refresh" content="0;URL="'.$location.'">');
} else {
header("Location: ".$location); //forward to another page
exit; //end the PHP processing
}
}
//redirect when save complete, with status msg.
include("db_connect.php");
$qContent="UPDATE content SET ".$_POST["field"]." = '".$_POST[$_POST["field"]]."'";
$qContent = mysql_query($qContent)// or die ('Query Error: ' . mysql_error());
print('worked');
Location("index.php?message=Your changes were saved successfully.");
?>
Subject
Written By
Posted
mySQL syntax error?
August 02, 2005 09:29PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.