Re: Count function. (Newbie Question)

Well, in this code, you are going to receive one line from your table that displays the total number of records. And that is it. Here is a sample from one of my tables, using the MySQL CLI: mysql> select count(*) from locker; +----------+ | count(*) | +----------+ | 47 | +----------+ 1 row in set (1.65 sec) If you can be a little more specific about what you want, maybe type up what you expect out, we can fix your query statement. Also, in this line: >> <b><?php echo $record_count ?> </b></font> You should put a ';' after the variable, just to save yourself the hassle of a parse error, when you get working code. On 4/9/01 9:32 AM, "Michael O'Neal" <mike@thinkmango.com> wrote: > 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 > >