Jump to content

Archived

This topic is now archived and is closed to further replies.

brown2005

Multiple Ranking Tables in one query

Recommended Posts

Hi i have a table called members and the following fields

firstname
middlename
lastname
age

what i want is a table with the ages and then the number of people in members in that age with the same names as me....

i.e.


age - firstname - middlename - lastname
18 - 6 - 4 - 1
21 - 12 - 6 - 15

and so on....

any ideas please...?

Share this post


Link to post
Share on other sites
$firstname="Mark";
$middlename="David";
$lastname="Duce";
$times=100;
$x=1;

echo "<table><tr><th>Age</th><th>First Name</th><th>Surname</th></tr>";
while ($x<$times) {

$countfirst=mysql_num_rows(mysql_query("SELECT * FROM members WHERE firstname='$firstname'"));
$countmiddle=mysql_num_rows(mysql_query("SELECT * FROM members WHERE middlename='$middlename'"));
$countsecond=mysql_num_rows(mysql_query("SELECT * FROM members WHERE lastname='$lastname'"));

echo "<tr><td>".$x."</td><td>";
echo "".$countfirst."</td><td>".$countmiddle."</td><td>".$countsecond."</td></tr>";


$x++;

}
echo "</table>";

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.