Results Page help

sonny100

Hi guys,

Now, I apologise in advance because I know that the answer to my question is probably going to be pretty simple!

Basically, I need to write the code to display search results from my query...fairly simple I think but I can't find a decent example anywhere to work from.

I've had a search around the forum, but can't quite find the right answer.

The query code is as follows:

<?php

if (isset($_REQUEST['submit']))
	{

	$location = $_REQUEST['location'];
	$inst = $_REQUEST['inst'];
	$age = $_REQUEST['age'];

	$connection = mysql_connect('localhost', 'user', 'password');
	mysql_select_db('database');

	$query = ("SELECT * from musican_details WHERE instrument = '$instrument' AND age = '$age' AND location = '$location'");
	$result = mysql_query($query);
	$num_rows=mysql_num_rows($result);

I just want to be able to display the results in a table. I'll figure out the '10 per page etc' bit after i've got the results to display.

Any help, or a point in the right direction would be greatly appreciated!

sonny100

Apologies, i've managed to figure it out in the meantime!

For anyone who is interested, I did this....

echo "<TABLE BORDER=1>";
for ($i=0; $i<$num_rows; $i++)
{
$array=mysql_fetch_array($result);
printf("<TR><TD>%s</TD><TD>%s</TD><TD>%s</TD><TD>%s</TD></TR>", $array['firstname'], $array['email'], $array['location'], $array['age']);
}
echo "</TABLE>";