Not deleting record
Posted: Fri Aug 14, 2009 12:22 pm
I'm using Dreamweaver CS4 and have create a mysql table that's using a datetimestamp as the primary key. I used the function in Dreamweaver to create the server behavior to do a delete record. I've done this same operation on another page for a different table. The page that attempts to delete the record with the datetimestamp does not work but the page that deletes a record that has a text field as a key does work.
if ((isset($_GET['datetimestamp'])) && ($_GET['datetimestamp'] != "")) {
$deleteSQL = sprintf("DELETE FROM messages WHERE datetimestamp=%s",
GetSQLValueString($_GET['datetimestamp'], "text"));
mysql_select_db($database_BRW, $BRW);
$Result1 = mysql_query($deleteSQL, $BRW) or die(mysql_error());
}
This is a clone of a page that works on 3 other tables but will not work on a datetimestamp.
Any ideas?
Aaron
if ((isset($_GET['datetimestamp'])) && ($_GET['datetimestamp'] != "")) {
$deleteSQL = sprintf("DELETE FROM messages WHERE datetimestamp=%s",
GetSQLValueString($_GET['datetimestamp'], "text"));
mysql_select_db($database_BRW, $BRW);
$Result1 = mysql_query($deleteSQL, $BRW) or die(mysql_error());
}
This is a clone of a page that works on 3 other tables but will not work on a datetimestamp.
Any ideas?
Aaron