Re: How can I get the number of entries retrieved by a"SELECT - FROM"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 12 Jun,2003 at 18:21 Becoming Digital wrote:
<snip>
> > The PHP "SELECT FROM" below (before snip) listed the expected data.
> > Is there a way to get the digit "3" into a PHP variable
> 
> $data = mysql_result($result,1,"name"));
> 
> 
> > How do I trap or collect or save the digit "3" generated the
> > mysql "SELECT COUNT(*)" statement below?
> 
</snip>

Or do 

SELECT COUNT(*) AS mycount ...

which will give you a result set with, eg: an array key called 'mycount' that you can grab.

Ronan

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux