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

 

may be this can help you my friend