output problem

From: Date: Thu, 23 May 2002 13:48:21 +0000
Subject: output problem
Groups: php.db php.general 
Request: Send a blank email to php-general+get-98910@lists.php.net to get a copy of this message
Howdi Alll some of you might laugh at this but I cant get this to work.... Im doing a count on a field and want to diplay the result here is an example... <?php #error_reporting(E_ALL); echo date("Y-m-d"); print $date; mysql_connect("servername", "user", "password") or die("Connect failed"); $query = "select count(user) from log_request where date='$date' and status = 'open'"; $result = mysql_db_query("call_manage", "$query") or die("query failed"); while($line = mysql_fetch_object($result)) { print ("<table width=100% border=0><td><tr bgcolor=#f0f0f0>"); print ("<br><b> </b>$line->user<br>\n"); print ("</td></tr>"); } ?> what am I missing as it returns no value at all from $line->user, should I be doing this differently?? Thankyou Chris

« previous php.general (#98910) next »