Unnamed

	$mirrorqry = "SELECT * FROM `v3_videos_mirrors` WHERE vidID=$id AND qual=3";  $mirres = mysql_query($mirrorqry);  $mirnum = 0;  $mirnum = mysql_num_rows($mirres);  echo "$mirnum";  $k = 0;  $lastqual=0;  $count = 1;  if ($mirnum!=0){    while ($k<$mirnum){      $qual = mysql_result($mirres,$k,"qual");      $userid = mysql_result($mirres,$k,"userID");      $format = mysql_result($mirres,$k,"format");      $filesize = mysql_result($mirres,$k,"filesize");      $hostname = mysql_result($mirres,$k,"hostname");      $dimensions = mysql_result($mirres,$k,"dimensions");      $linkid = mysql_result($mirres,$k,"id");      $qualqry = "SELECT * FROM `v3_videos_formats` WHERE `id`='$format' LIMIT 1";      $qualres = mysql_query($qualqry);      $qualname = mysql_result($qualres,0,"name");      $prognosis = "equallink";      $dlcount = mysql_result($mirres,$k,"dlcount");      $usersql = "SELECT `username` FROM `phpbb_users` WHERE `user_id`=$userid LIMIT 1";      $userrun = mysql_query($usersql);      $user = mysql_result($userrun,0,0);	include("./inc/mirror_rep.php");	        echo "<a href=\"index.php?p=vidmirror&id=$linkid\" title=\"$qualname, $dimensions, $filesize, submitted by $user, mirror provided by $hostname | Download Count: $dlcount\"><img src=\"./inc/mirror_image.php?color=$color&count=$count\"></a>";$count++;$k++;}}