mysql to get all records in last week by timestamp in format 1267641902

[Vivid Lust]

I have the code to get all the records in the past 7 days for a mysql timestamp:

 

WHERE LastOnline < DATE_ADD(NOW(), INTERVAL -7 DAY)

 

 

However when the timestamp, or php time, is in the format 1267641902 its not working, how could i get this to work sucessfully?

 

thanks all!

[jcanker]

PHP and MySql use different date formats for timestamp.  What type of column is the MySQL using?  Personally, I always just create the column as a bigint and store the raw value of the unix timestamp generated by php in that column.  That way you can perform any math function, including > or < easily. 

[Vivid Lust]

I haven't got the option to change it, any help? thanks.

[Vivid Lust]

Anyone please? Anyway to put the results into an array and then compare?