Count function. (Newbie Question)
| From: | Michael O'Neal | Date: | Mon, 09 Apr 2001 16:32:29 +0000 |
| Subject: | Count function. (Newbie Question) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-47825@lists.php.net to get a copy of this message | ||
Hi,
I'm trying to display a record count of some sort on a page I'm working
on. For example, "Record 1 of 15". I can display the 1st number ok, but
I'm a bit confused on what the count function should look like for the
2nd number (15, in this case). Here is my current (not working) code.
> <?php
>
> $query = "SELECT count(*) FROM mango_pr";
> $result = mysql_query($query);
> $record_count = mysql_fetch_row($result);
>
>
>?>
And then I'm calling the code with an "echo" later on:
><b><?php echo $record_count ?> </b></font>
This obviously isn't right...can anyone offer any suggestions?
Thanks,
mto
Michael O'Neal
Web Producer/ Autocrosser
ST 28 '89 Civic Si
---------------------
M A N G O
B O U L D E R
---------------------
http://www.thinkmango.com
e-mike@thinkmango.com
p-303.442.1821
f-303.938.8507