Page 1 of 1

Not deleting record

Posted: Fri Aug 14, 2009 12:22 pm
by aarondornhecker
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. :banghead:

Any ideas?

Aaron

Re: Not deleting record

Posted: Sat Aug 15, 2009 2:20 am
by VladSun
Any error messages displayed?

Re: Not deleting record

Posted: Sat Aug 15, 2009 1:24 pm
by aarondornhecker
No error messages at all. I don't go to another page or anything like that. I keep to the same page so that I can delete other messages if needed.

Aaron