[PHP] simple date/now() question

Hi, I have a field in the db called join_date_time(timestamp 14) which has data like: 20040928170708 20040916163619 etc This keeps track of the customer join date, I need to know if the client has joined in the last 24hrs or more than 24hrs back... Anybody have a function for this? or can

RE: [PHP] simple date/now() question

[snip] data like: 20040928170708 20040916163619 etc Anybody have a function for this? or can help? am a bit confused because reading on google I see that there are 2 possible problems as MySql has its own time and PHP its own time (most of the time!) [/snip] http://www.php.net/date

Re: [PHP] simple date/now() question

Just select out records that are NOW() - (24 * 60 * 60)or if you use datetime field instead of timestamp, which is prolly better off ofr many reasons, use DATE_SUB(NOW(), INTERVAL 1 DAY) or something similar. you can get timestamps from datetime fields, if that is an issue for you... Jason

Re: [PHP] simple date/now() question

Hi, Thanks for replying. Just select out records that are NOW() - (24 * 60 * 60) I just need this for 1 record, when the user logs in I want to know if he has joined more than 1 day back or not... I am looking into php.net/date and php.net/time, but if have an example for me...:-)