What format is $expDate in?  You'll need to make sure it's in the format
your database expects for a date type column.

Joshua Hoover

> 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]

Reply via email to