Thanks Tom,
That has worked an absolute treat.
thank you very much
Leon.
-Original Message-
From: Haapanen, Tom [mailto:[EMAIL PROTECTED]]
Sent: 23 October 2001 10:54
To: 'Leon Noble'
Cc: [EMAIL PROTECTED]
Subject: RE: Very untidy
select hour(ts), count(ts) from dundeefw
D]
Subject: Very untidy
Hi all,
can someone look at my very untidy code and maybe give me some pointers.
Searching for values by the hour.
etc
for ($i = 0; $i <= 23; $i++)
{
$query = "select count(num) as mycount from dundeefw where date=$date
and action=1 and time=hour($i)"
Hi all,
can someone look at my very untidy code and maybe give me some pointers.
Searching for values by the hour.
etc
for ($i = 0; $i <= 23; $i++)
{
$query = "select count(num) as mycount from dundeefw where date=$date
and action=1 and time=hour($i)";
// Execute quer