Hi there, im trying to update 2 tables. I have joined a table to pull the necessary data but im getting an 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 'SET PlanetName='Mon Calamari' WHERE FleetName = 'Doom'' at line 1
That line points to my first Update query:
$updateSQL = sprintf("UPDATE ships , SET PlanetName=%s WHERE FleetName = %s", GetSQLValueString($_POST['select'], "text" ),
GetSQLValueString($colname_Fleet, "text"));
Any ideas whats wrong with that line??
Heres the main code incase:
$colname_Fleet = "-1";
if (isset($_GET['recordID'])) {
$colname_Fleet = (get_magic_quotes_gpc()) ? $_GET['recordID'] : addslashes($_GET['recordID']);
}
mysql_select_db($database_swb, $swb);
$query_Fleet = sprintf("SELECT * FROM fleet WHERE FleetName = %s", GetSQLValueString($colname_Fleet, "text"));
$Fleet = mysql_query($query_Fleet, $swb) or die(mysql_error());
$row_Fleet = mysql_fetch_assoc($Fleet);
$totalRows_Fleet = mysql_num_rows($Fleet);
$colname_ShipsInfleet = "-1";
if (isset($_GET['recordID'])) {
$colname_ShipsInfleet = (get_magic_quotes_gpc()) ? $_GET['recordID'] : addslashes($_GET['recordID']);
}
mysql_select_db($database_swb, $swb);
$query_ShipsInfleet = sprintf("SELECT s.ShipID, s.FleetName, s.PlanetName, f.FleetName, f.PlanetName, f.Detected, f.Faction FROM fleet f
LEFT JOIN Ships s ON (f.FleetName = s.FleetName)
WHERE f.FleetName = '$colname_Fleet'");
$ShipsInfleet = mysql_query($query_ShipsInfleet, $swb) or die(mysql_error());
$row_ShipsInfleet = mysql_fetch_assoc($ShipsInfleet);
$totalRows_ShipsInfleet = mysql_num_rows($ShipsInfleet);
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
$updateSQL = sprintf("UPDATE ships , SET PlanetName=%s WHERE FleetName = %s", GetSQLValueString($_POST['select'], "text" ),
GetSQLValueString($colname_Fleet, "text"));
mysql_select_db($database_swb, $swb);
$Result1 = mysql_query($updateSQL, $swb) or die(mysql_error());
$updateSQL = sprintf("UPDATE fleet SET PlanetName=%s, Detected=%s, Faction=%s WHERE FleetName=%s",
GetSQLValueString($_POST['select'], "text"),
GetSQLValueString(isset($_POST['checkbox']) ? "true" : "", "defined","1","0"),
GetSQLValueString($_POST['hiddenField2'], "int"),
GetSQLValueString($_POST['hiddenField'], "text"));
mysql_select_db($database_swb, $swb);
$Result1 = mysql_query($updateSQL, $swb) or die(mysql_error());
$updateGoTo = "fleet.php";
if (isset($_SERVER['QUERY_STRING'])) {
$updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
$updateGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $updateGoTo));
}
?>
If you can help that would be ace as ive been stuck for ages.
Thanks
