[SOLVED] counting table rows but just displaying number, not all rows

[kendallkamikaze]

Title kind of explains it. This code below is functional, the issue is that I need it to just display the number of rows, and not all the rows.

 

<?php

$horseid=$_GET['id']; 

$query = mysql_query("SELECT * FROM class_event_entered WHERE horseid='$horseid'"); 
$number=mysql_num_rows($query); 

while($r=mysql_fetch_array($query))
{	
  
$horseid=$r["horseid"];

   print "<font size='3pt' face='comic sans ms'>Show Entries - #$horseid is entered in $number shows.</font> <br>
";
}
?>

[Yesideez]

I see no problems with that script but unsure of what you're asking.

 

If you don't want to show all the rows you'll need a different query...

[kendallkamikaze]

I just want it to say a numeral like 'this horse is entered in X number of shows.' the way it is now, it lists the same thing over and over.

[Yesideez]

Sorry, I'm at work answering between jobs here...

 

Is this what you're after?

 

<?php

$horseid=$_GET['id']; 

$query = mysql_query("SELECT COUNT(*) AS numentered FROM class_event_entered WHERE horseid='$horseid'"); 
$r=mysql_fetch_assoc($query); 

print "<font size='3pt' face='comic sans ms'>Show Entries - #$horseid is entered in ".$r['numentered']." shows.</font> <br>
";
?>

[sasa]

or

<?php
$horseid=$_GET['id']; 
$query = mysql_query("SELECT * FROM class_event_entered WHERE horseid='$horseid'"); 
$number=mysql_num_rows($query); 
print "<font size='3pt' face='comic sans ms'>Show Entries - #$horseid is entered in $number shows.</font> <br>
";
?>

[kendallkamikaze]

or

<?php
$horseid=$_GET['id']; 
$query = mysql_query("SELECT * FROM class_event_entered WHERE horseid='$horseid'"); 
$number=mysql_num_rows($query); 
print "<font size='3pt' face='comic sans ms'>Show Entries - #$horseid is entered in $number shows.</font> <br>
";
?>

 

This is what I was looking for. Thank you.