RE: [PHP-DB] It counts everything not a specific day..

> OK, > > Looks like there are two options > > I can either convert the unix timestamp colomn to a mysql > time one *OR* > someone can tell me how to use unix timestamps in this query... > Try something like this: SELECT CONCAT(extract(year FROM FROM_UNIXTIME(time)), extract(month

Re: [PHP-DB] It counts everything not a specific day..

OK, Looks like there are two options I can either convert the unix timestamp colomn to a mysql time one *OR* someone can tell me how to use unix timestamps in this query... -- JJ Harrison [EMAIL PROTECTED] "John W. Holmes" <[EMAIL PROTECTED]> wrote in message news:001101c2777a$dcb96c10$7c0

RE: [PHP-DB] It counts everything not a specific day..

Well, for one thing, EXTRACT() is for MySQL timestamps, not unix timestamps. ---John Holmes... > -Original Message- > From: Noodle Snacks [mailto:webmaster@;tececo.com] > Sent: Saturday, October 19, 2002 7:36 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] It counts everything not a speci