Not deleting record

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
aarondornhecker
Forum Newbie
Posts: 2
Joined: Fri Aug 14, 2009 11:12 am

Not deleting record

Post 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
User avatar
VladSun
DevNet Master
Posts: 4313
Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria

Re: Not deleting record

Post by VladSun »

Any error messages displayed?
There are 10 types of people in this world, those who understand binary and those who don't
aarondornhecker
Forum Newbie
Posts: 2
Joined: Fri Aug 14, 2009 11:12 am

Re: Not deleting record

Post 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
Post Reply