You could try something like this....(did not test) <? echo date("Y-m-d"); print $date; mysql_connect("servername","user","password") or die("Connect failed");
$query = "select user from log_request where date='$date' and status = 'open'"; $result = mysql_db_query("call_manage", "$query") or die("query_failed"); $count=mysql_num_rows($result); $r=mysql_fetch_array($result); $user=$r["user"]; print ("<table width=100% border=0><td><tr bgcolor=#f0f0f0>"); print ("<br><b> </b>$count $user<br>\n"); print ("</td></tr>"); -----Original Message----- From: Chris Grigor [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 9:48 AM To: [EMAIL PROTECTED]; Php-General-List (E-mail) Subject: [PHP] output problem 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php