[SOLVED] determine number of records

[jeff5656]

This is a really basic question but how do I add to this code the total number of records that match this query.  I know I need to use msql_num_rows () but don't know what I'm supposed to put in the ():

$query = "SELECT COUNT(*) as num FROM gpu WHERE signoff_status = '$so' AND `service` = '". $service ."' ";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[num];

[JonnoTheDev]

As you are using a COUNT statement in your query your result will only contain 1 row so you are not to use mysql_num_rows() in this case. You are selecting the number of records, not the actual rows so you can display the result as follows:

<?php
$result = mysql_query("SELECT COUNT(*) as num FROM gpu WHERE signoff_status = '".$so."' AND `service` = '".$service."'");
$row = mysql_fetch_assoc($result);
print "There are ".$row['num']." results";
?>

[kickstart]

Hi

 

That will bring back a single record anyway.

 

However, in theory:-

 

$query = "SELECT COUNT(*) as num FROM gpu WHERE signoff_status = '$so' AND `service` = '". $service ."' ";
$total_pages = mysql_fetch_array(mysql_query($query));
$CountOfRows = mysql_num_rows($total_pages);

 

All the best

 

Keith

[JonnoTheDev]

kickstart, $CountOfRows will always be 1!

SELECT COUNT()

A count is a count, not a recordset.

[kickstart]

Hi Neil

 

I know, hence my comment above.

 

Not sure he meant to use COUNT(*) rather than just *.

 

All the best

 

Keith