If I am not mistaken, try printing $line["user"] instead of just $line
as in:
<?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"]->user<br>\n");
print ("</td></tr>");
}
?>
Cami
----- Original Message -----
From: "Chris Grigor" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 23, 2002 2:46 PM
Subject: [PHP-DB] 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 Database 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
