Don't do that, it's inefficient. You've got the right query, you just have
to assign the column an alias to use it the way you are.
SELECT COUNT(user) AS count_user FROM _request WHERE > date='$date' AND
status = 'open'
Then, after fetching the object from the result set, use
$line->count_user
The way you are doing it now works, too, but he column comes back named
'count(user)' and I'm sure you would get an error with $line->count(user),
so that's why you assign it an alias with AS.
Also note that you should be using mysql_select_db() and mysql_query()
instead of mysql_db_query()...
---John Holmes...
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, May 23, 2002 9:57 AM
Subject: RE: [PHP] output problem
> 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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
