use href to diplsy database results

Hi,

I have a problem with my code, please not that I have quoted the important sections below

mypage.php;

<ul>

<li><a href=’mypage.php’>Tins</a></li>

<li><a href=’mypage.php’>Bottle</a></li>

<li><a href=’mypage.php’>Boxes</a></li>

</ul>

$sql=”select List from table where category=Tin1″;

$result=mysql_query($sql);

echo $result;

can anyone advice please,

My aim is to do the following,

When I click on href, I should be able to display the results from the database as shown.

Can anyone advice,please?

thanks

tldmic