View Single Post
Old 12-23-2003, 04:03 PM   #4
Charter
Head Mole
 
Charter's Avatar
 
Join Date: May 2003
Posts: 2,539
Hi. It looks like the following query is returning zero results. When that happens $result is not an array so foreach() throws a warning. As soon as the query returns greater than zero results, the warning should go away. Thanks for pointing it out. It's something to tweak in a future release.
PHP Code:
$query 'SELECT DATE_FORMAT(l_ts,\\'%H:00') as hour,
round(avg(l_time),2) as avg_time,
count(l_id) as num_queries
FROM '
.PHPDIG_DB_PREFIX.'logs
WHERE l_time > 0
GROUP BY hour'
;
$result phpdigMySelect($id_connect,$query); 
__________________
Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension.
Charter is offline   Reply With Quote