Re: Timestamp woes

2004-02-29 Thread Scott Plumlee
Ryan A wrote: /** Somewhat new myself but I believe you can do something like SELECT (whatever you need) FROM tbl_users WHERE (UNIX_TIMESTAMP(now()) - ($days_last*24*60*60)) UNIX_TIMESTAMP(dat_and_tim). I will add the the PHP Cookbook and the MySQL Cookbook are godsends and that's where

Re: Timestamp woes

2004-02-29 Thread Michael Stassen
Scott Plumlee wrote: [EMAIL PROTECTED] wrote: Hi, (Please note: NEWBIE WARNING, below questions might sound stupid, but feel free to flame.) ;-) I have a table tbl_users with a field dat_an_time which is a timestamp(14). In that I have values such as: 2004022215 20040227042018

Timestamp woes

2004-02-28 Thread ryan
Hi, (Please note: NEWBIE WARNING, below questions might sound stupid, but feel free to flame.) ;-) I have a table tbl_users with a field dat_an_time which is a timestamp(14). In that I have values such as: 2004022215 20040227042018 20040223015329 etc I have searched google/the manual for

Re: Timestamp woes

2004-02-28 Thread Scott Plumlee
[EMAIL PROTECTED] wrote: Hi, (Please note: NEWBIE WARNING, below questions might sound stupid, but feel free to flame.) ;-) I have a table tbl_users with a field dat_an_time which is a timestamp(14). In that I have values such as: 2004022215 20040227042018 20040223015329 etc I have searched