[RESOLVED] query cant figure out

[slimjim]

This below would show array of links

<?
	    $query="select id, user, url, status from links where status='1'";
	    $result = mysql_query($query) or die( "ERROR: " . mysql_error() . "n");	    

	    while ($myrow = mysql_fetch_array($result)) {	    

		  $id=$myrow["id"];
		  $url=$myrow["url"];
?>
<a href="linkhits.php?id=<? echo $id;?>&url=<? echo $url;?>&userid=<? echo $userid;?>">link title here</a><br.
//array of links would show here
<?
}
?>	

Now when a member clicks on a link, that same info plus userid, gets inserted in a table called linkhits
linkhits table has
id, linkid and url
linkid=$id from table links above
same with url
My problem is
How can I show the links that the member did not click and grey out the ones he did click.

I have tried everything and cant get 2 querys to work correctly no matter what.

[notaloser]

<? 
        $query="select id, user, url, status from links where status='1'"; 
        $result = mysql_query($query) or die( "ERROR: " . mysql_error() . "n");         

        while ($myrow = mysql_fetch_array($result)) {         

          $id=$myrow["id"]; 
          $url=$myrow["url"]; 

$query2 = "select fields from linkhits where linkid = '$id'";
$result2= mysql_query($query2) or die( "ERROR: " . mysql_error() . "n");
$num = mysql_num_rows($result2);

if(empty($num)) { // there are no rows for this id, it hasnt been clicked
$color = "black"; // make it black
}else{
$color = "blue"; // make it blue if it HAS BEEN clicked
}


echo "<font  color='".$color."'>";
?> 
<a href="linkhits.php?id=<? echo $id;?>&url=<? echo $url;?>&userid=<? echo $userid;?>">link title here</a><br>
<?
echo "</font>";
} 
?>