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 Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to