Have you created any php code yet to try and do this? if so what errors are you getting?

Mysql select will be your friend...

You will need to create an interface for the user to issue his/her query. What you could do is have a number of check boxes and a text field. The user would then select the aspect they where interested in and type their query.

For example...

Area 0 Age 0 Weight 0 [ ] [go]

the "0" is a checkbook the [] is a text field and [go] is the submit button.

Here is some html I put together to help with the form...

<form action="script.php" method="get">
Area<input name="what" type="checkbox" value="area" />
Age<input name="what" type="checkbox" value="age" />
Weight <input name="what" type="checkbox" value="weight"/>
<input name="query" type="text" />
<input type="submit" value="Submit" />
</form>

With this form you are sending a request to a php script. What information we are looking for (area, age or weight) we call this part “what” and the actual query where the user types in. I have simply called this “query”
So if a user wants to view data for all 40 year olds he/she simply checks the age checkbox and types 40 into the text box. The form will send the user to script.php with the following parameters attached to the URL in the address bar.

script.php?what=age&query=40

What we now need to do is build our php script to handle the actual search (script.php)

<?php
#First lets get query and what from the URL
$what = $_GET['what'];
$query = $_GET['query'];

#Then connect to database
mysql_connect("host", "username", "password") or die(mysql_error());
mysql_select_db("dbname") or die(mysql_error());

#you will need to change host username password and dbname with your own settings

#Now lets ask mysql to show us all data that matches our criteria.

$result = "select * FROM tablename where $what=$query;

#as an example if the user was searching by age for 30 year olds the query means
#show all data from tablename where age is 30.

#We new need to display the data in a table format.

echo "<table border='1'>";
echo "<tr><b><td>Age</td> <td>Area</td> <td>Weight</td></b></tr>";

while($row = mysql_fetch_array( $result ))
{
echo "<tr><td>";
echo $row['age'];
echo "</td><td>";
echo $row['area'];
echo "</td><td>";
echo $row['weight'];
echo "</td></tr>";
}
echo "</table>";
?>

What the above script does is get the requested data from mysql and show it as one table. If you find your database growing very large you might want to look at displaying the data over a number of pages.

Hope this gives you some ideas.

Mack.