Just want to count rowsand display how many

[deansaddigh]

I have this sql

 

$result = mysql_query($coursequery, $conn)
               or die ("Unable to perform query: " . mysql_error());  

		//bring back courses
		echo '<h2>'. $row['school_name'].' also offers:</h2><br />';
		while($row = mysql_fetch_array($result,MYSQL_ASSOC))
			{

				echo '<p>'. $row['type']. ' :'.$row['course_name'].'</p><hr />';

			}

 

How can i count the rows and then change the line which says "also offers (THE AMOUNT) of courses

 

Thanks in advance

[deansaddigh]

Its ok i have done this now using

 

  $result = mysql_query($coursequery, $conn)
               or die ("Unable to perform query: " . mysql_error());  
			$num_rows = mysql_num_rows($result);
		//bring back courses
		if ($num_rows == 1)
		{
		echo '<h2>'. $row['school_name'].' '.'offers ('.$num_rows.') course</h2><br />';
		}
		else 
		{
		echo '<h2>'. $row['school_name'].' '.'offers ('.$num_rows.') courses</h2><br />';
		}
		while($row = mysql_fetch_array($result,MYSQL_ASSOC))
			{

				echo '<p>'. $row['type']. ' :'.$row['course_name'].'</p><hr />';

			}