Count function. (Newbie Question)

From: 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

« previous php.general (#47825) next »