Actually, your problem lies in your SQL code.  Instead of "DELETE * FROM
Table"  the correct syntax is "DELETE FROM Table"


Jeremy Reed
"Brian Grayless" <[EMAIL PROTECTED]> wrote in message
> 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
> of those RTFM questions?
> Thanks,
> Brian

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to