You have an error in your SQL syntax. Error when updateing or inserting a new row.
Hi,
With the You have an error in your SQL syntax error, it says to check mysql manual for my version. Mysql version is 4.0.22 & php 4.3.10 on Apache 1.3.3.1 server. When I try to update a row or add a new row to the table, I get this message.
Here is the php code:
if ($Update) {
mysql_connect ($host, $user, $password)
or die ('I cannot connect to the database because: ' .mysql_error());
mysql_select_db ($db);
//If any Update button is clicked; changes will be
//updated for the record in that row
mysql_query("UPDATE 'properties'
SET 'Active'='$Active',
'Rent'='$Rent',
'Deposit'='$Deposit',
'StreetNumber'='$StreetNumber',
'StreetDirection'='$StreetDirection'.
'StreetNmae'='$StreetName',
'StreetType'='$StreetType',
'City'='$City',
'State'='State',
'Zip'='$Zip'
'ApartmentNumber'='$ApartmentNumber',
'ApartmentType'='$ApartmentType',
'CrossStreet1'='$CrossStreet1',
'CrossStreet2'='$CrossStreet2',
'Notes'='$Notes',
'EntryDate'='$EntryDate',
'AvailableDate'='$AvailableDate' WHERE 'ID'='$ID'")
or die ('I cannot update to the database because: ' .mysql_error());
echo "Record Updated!<p>";
echo "<br><a href='admin.php'>Return to Admin Edit List</a>";
echo"<br><a href='properties.php'>View Properties List</a>";
}
elseif ($AddNew) {
mysql_connect ($host, $user, $password)
or die ('I cannot connect to the database because: ' .mysql_error());
mysql_select_db ($db);
//INSERT NEW RECORD
mysql_query("INSERT 'properties'
SET 'Active'='$Active',
'Rent'='$Rent',
'Deposit'='$Deposit',
'StreetNumber'='$StreetNumber',
'StreetDirection'='$StreetDirection'.
'StreetNmae'='$StreetName',
'StreetType'='$StreetType',
'City'='$City',
'State'='State',
'Zip'='$Zip'
'ApartmentNumber'='$ApartmentNumber',
'ApartmentType'='$ApartmentType',
'CrossStreet1'='$CrossStreet1',
'CrossStreet2'='$CrossStreet2',
'Notes'='$Notes',
'EntryDate'='$EntryDate',
'AvailableDate'='$AvailableDate'
WHERE 'ID'='$ID'")
or die ('I cannot add new to the database because: ' .mysql_error());
echo "Inserted New Row!<p>";
echo "<br><a href='admin.php'>Return to Admin Edit List</a>";
echo"<br><a href='properties.php'>View Properties List</a>";
}
Please help, I am new to Mysql.
Ashok.