ah hah someone got it right !! many thanks stephen ...
-Original Message-
From: Stephen Rhodes [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 8:49 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: output problem
When you write the SQL statement write it as:
select count
When you write the SQL statement write it as:
select count(user) AS count from log_request where date='$date' and
status = 'open'
(note i have added 'AS count' in there so it stores the value in
'count')
Now when you output the result write it as $line->count
Cheers
Steve
"Chris