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

2002-10-24 Thread joakim . andersson
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 FROM

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

2002-10-19 Thread Noodle Snacks
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