Counting results

jscs99

I want to count the number of records a query finds and display the number of records found along with the records themselves.

I can get the results and display the found records with no problem, but I don't have a clue how to count them and display the number.

I am, new at this.

Thanks in advance.

theslinky

If you are using a simple while loop to print out the results, initialize and increment a counter.

do:

$count = 0;

while (each row exists blah blah) {
...print row...
$count++;
}

print "$count rows were returned";

-sridhar

jscs99

Thanks!

Now I just have to figure out how to display it at the top of the page instead of the bottom after it prints all the records.

theslinky

Do this:

instead of print directly in the while loop, append it to a giant string:

$output = "";

while(...) {
$output .= "whatever you print out";
$count++;
}

print "# of rows: $count ";

print $output;

-sridhar

Anon

Why not just use mysql_num_rows() (or whatever database you're using)?

jscs99

Ok, now I can't figure out how to put this output from the while loop into a variable that will print it.

while ($myrow = mysql_fetch_array($result)) {
printf("<a href=\"editRGList.php?personID=%s\"> %s %s</a> <-- Click on name to edit record.
 ----------------------------------------------------------------------------------------------- 
eMail........: %s 
Address1.....: %s 
Address2.....: %s 
City.........: %s 
State........: %s 
PostalCode...: %s 
 Country......: %s
 ----------------------------------------------------------------------------------------------- 
Phone.......: %s 
Fax.........: %s 
 CellPhone...: %s
 ----------------------------------------------------------------------------------------------- 
rgNewsType........: %s 
rg_DonorType......: %s 
rgVolunteerType...: %s ----------------------------------------------------------------------------------------------- 
ccNum...........: %s 
ccExp...........: %s 
ccCVV...........: %s ----------------------------------------------------------------------------------------------- 
Notes..: %s \n",
$myrow["personID"],
$myrow["FirstName"],
$myrow["LastName"],
$myrow["eMail"],
$myrow["Address1"],
$myrow["Address2"],
$myrow["City"],
$myrow["State"],
$myrow["PostalCode"],
$myrow["Country"],
$myrow["Phone"],
$myrow["Fax"],
$myrow["CellPhone"],
$myrow["rgNewsType"],
$myrow["rg_DonorType"],
$myrow["rgVolunteerType"],
$myrow["ccNum"],
$myrow["ccExp"],
$myrow["ccCVV"],
$myrow["Notes"]);

$recordCount++;
}

Everything I've tried results in parse errors of one sort or another.

Thank you.