Array_aches

[Anon]

Hi to all of you :-)
On my site I have site of the day link. I store the url in a database. But the number of the sites is already huge and when insert a new one I want to check if it is already in. So I made a search php. But it does not work. Would you help me to find the mistake? Here is the code:
<?php $link=mysql_connect ( "mysite","username","password") or die("");
mysql_select_db('database',$link) or die("");
$result = mysql_query("select url from flash_sites") or die("");
$go= mysql_fetch_array($result) or die("");
$current = reset($go);
while($current==next($go)){
if($url == $current){
$status="Match Found";
break;
}else{
$status="No matches found";
}
}
print("$status");
?>

[jjoske]

Try this code, haven't tested but should work.

<?php $link=mysql_connect ( "mysite","username","password") or die("");
$dbLink=mysql_select_db('database',$link) or die("");
$dbresult = mysql_query("select url from flash_sites",$dbLink) or die("*");
$status="No Match Found";
while($url=mysql_fetch_array($dbresult)){
if($url[url] == $current) $status="Match Found";
}
print("$status");
?>

[Anon]

Thank you John :-)
I will try this.