Shoot me now, please.
Thanks - I don't know how I missed that! Thanks - re-ran the query and
things seem to be a-ok!
On Wed, 23 Feb 2005 18:42:17 +0100, Roger Baklund <[EMAIL PROTECTED]> wrote:
> Clarence wrote:
> > I have a log table that records certain transactions on one of my sites.
> > I'm
Clarence wrote:
I have a log table that records certain transactions on one of my sites.
I'm using a timestamp field to mark the date/time of each transaction.
I'm trying to run a query that will display the transactions by date
using the following SQL:
SELECT COUNT(log_id) AS total,
WEEK(FROM_UN
I have a log table that records certain transactions on one of my sites.
I'm using a timestamp field to mark the date/time of each transaction.
I'm trying to run a query that will display the transactions by date
using the following SQL:
SELECT COUNT(log_id) AS total,
WEEK(FROM_UNIXTIME(UNIX_TIM