show a numbers of matches or no matches after searching. Thanks

[ngu_tri]

Hello everyone. I need help to show a number of matches after searching. And then each match should have a link to view more details. Hope you understand what i mean and thanks for help

search.php
<?php
include("dbconnect.php");
$search=$_POST["search"];
if(!$search)
{
echo("Tast in something to search");
}
else
{
$result=mysql_query("SELECT *FROM guestbook WHERE name LIKE '%$search%'");
if($search <> $result)
{
echo "No Match!!";
}
else if($search == $result)
{
echo "sum['"$result"], Matchates"; // Problem here
//numbers of searches
}
while($r=mysql_fetch_array($result))
{
$name=$r["name"];
echo "<a href='$name'>name</a>";
//2 matches after searching, click on name that should show more details
}
}
?>

[LarsLai]

hi!
in order to get the number of results, take a look at mysql_num_row()
and if you want to show details, i think its best to make one new site and send the link to this site with a parameter

while($r=mysql_fetch_array($result))
{ 
$name=$r["name"]; 
echo "<a href='newsite.php?name=$name'>$name</a>"; 
//2 matches after searching, click on name that should show more details 
}