Help to href function

Anon

in this sample code i ca'nt get the $id var when i click on ref.
Could you help me ?
Thanks

<body>
<?php
$db = mysql_connect("localhost", "root");
mysql_select_db("testdb",$db);
$result = mysql_query("SELECT * FROM employees",$db);
if ($myrow = mysql_fetch_array($result)) {
do {
printf("<a href=\"%s?id=%s\">%s %s</a><br>\n", $PHP_SELF, $myrow["id"], $myrow["first"], $myrow["last"]);
} while ($myrow = mysql_fetch_array($result));
} else {
echo "Sorry, no records were found!";
}

// When i use href function to set id to a value and i click on ref,
// the id value was not update.
// Could you help me ?

printf("ID 2 %s\n<br>", $id);
?>
</body>

Anon

Try this: (I'm not real keen on using printf)

<body>
<?

$db = mysql_connect("localhost", "root");
mysql_select_db("testdb",$db);

if ($res=mysql_query("SELECT * FROM employees",$db))
while ($myrow=@mysql_fetch_array($res))
{
echo "<a href=\"?id=".$myrow["id"]."\">";
echo $myrow[first]." ".$myrow[last].
"</A>";

}
else echo "Sorry, no records were found!";
</BODY>