"; print "Search By: "; @mysql_select_db("squadlinks") or die( "Unable to select database"); $number_top = mysql("squadlinks", "select long_name,short_name from games_list order by long_name"); $rowcount_top = mysql_numrows($number_top); $newvart_top = mysql("squadlinks", "select long_name,short_name from games_list order by long_name"); print " Any"; while ($rowcount_top > 0): $info = mysql_fetch_row($newvart_top); print " $info[0]"; $rowcount_top=$rowcount_top-1; endwhile; print "  "; @mysql_select_db("$dbname") or die( "Unable to select database"); $number_r = mysql("$dbname", "select r_name from $dbtable where r_type=$locate_number and r_display=1 and r_games like '%$game_select%'"); $rowcount_r = mysql_numrows($number_r); $newvart_r = mysql("$dbname", "select r_name,r_unique_id,r_date_added from $dbtable where r_type=$locate_number and r_display=1 and r_games like '%$game_select%' order by r_date_added desc limit $new_offset,20"); $result_position=$rowcount_r-$offset; $max_count=20; while ($rowcount_r > -1 and $max_count > -1): $infoa = mysql_fetch_row($newvart_r); /* decode squadname for displaying */ $infoa[0] = rawurldecode($infoa[0]); $infoa[0] = stripslashes($infoa[0]); $infoa[2]=substr("$infoa[2]",5,5); print ""; $rowcount_r=$rowcount_r-1; $max_count=$max_count-1; endwhile; print "

Sitename	Added
$infoa[0]	$infoa[2]