Actually, your problem lies in your SQL code. Instead of "DELETE * FROM Table" the correct syntax is "DELETE FROM Table"
Regards, Jeremy Reed "Brian Grayless" <[EMAIL PROTECTED]> wrote in message C3C8C2499A63D211BB7D00A0C9E1C7060128707F@PRI-NT1">news:C3C8C2499A63D211BB7D00A0C9E1C7060128707F@PRI-NT1... > I'm trying to delete rows from a database where the date is older then my > $expDate variable, but for some reason, no matter what I try and what > examples I use for help, I can't get this to work??? I first took the > $expDate string and set the var type to "integer". The datatype for the > "msgCreated" field is "int". > > I first tried: > $sql = "DELETE * FROM Table WHERE msgCreated < '$expDate'"; > > and it didn't work so I then tried it without the single quotes: > > $sql = "DELETE * FROM Table WHERE msgCreated < $expDate"; > > still, it didn't work. Am I missing something fundamental here? Is this one > of those RTFM questions? > > Thanks, > > Brian -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
