value in variable in grid view type

[jaiffed]

I have this code for grid view

$query="select member_name from member where mem_id=$q && av=1";

$result= mysql_query($query,$link) or die("");

$fel=mysql_num_fields($result);
$nro=mysql_num_rows($result);

echo '<table border="2">';
echo "<td> Member Detail</td>";
while ($row = mysql_fetch_array($result)){
//loop through the rows
echo '<tr>';
//loop through elements (ie td's)
echo "<td>" . $row['member_name'] . "</td>";
}
echo '</tr>';

echo '</table>';

mysql_close($link);

?>

the output of this code is look like in HTML table:-

..................................................
| Member detail |
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
| Andy |
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
| Anne |
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
| Ronni |
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

but now the problem is that i want that if user click on Andy or any other name then the name of Andy come in the variable $mem_name for the next php page
which will i use to show full detail of selected player
what can i do to do this
please help me

[dagon]

PHP Code:

echo '<td><a href="page.php?id='.$row[id].'">' . $row['member_name'] . "</a></td>";


assuming you have an id field.
then on page.php you retrieve the id

PHP Code:

$mem_name=$_GET['id'];


and use that to display what you want.