"" or $gametype<>""){ $number = mysql("$dbname", "select r_unique_id from $dbtable WHERE r_name like '%$searchterm%' and r_games like '%$gametype%' "); $rowcount = mysql_numrows($number); $newvart = mysql("$dbname", "select r_unique_id,r_name,r_type from $dbtable WHERE r_name like '%$searchterm%' and r_games like '%$gametype%'");}; if ($action=="search"){ print "

"; print "

Site Name

Type of site

"; $max_results =10; while ($rowcount > 0 AND $max_results > 0): $infoa = mysql_fetch_row($newvart); $rowcount=$rowcount-1; $max_results=$max_results-1; if ($infoa[2]==1){$nice_name= "News & information";}; if ($infoa[2]==2){$nice_name= "Mods";}; if ($infoa[2]==3){$nice_name= "Maps";}; if ($infoa[2]==4){$nice_name= "League/Tournament";}; if ($infoa[2]==5){$nice_name= "Strategy/Tactics";}; if ($infoa[2]==6){$nice_name= "Publisher";}; if ($infoa[2]==7){$nice_name= "Developer";}; print "

$infoa[1]

$nice_name

"; endwhile;}; print "

"; @mysql_select_db("squadlinks") or die( "Unable to select database"); $number = mysql("squadlinks", "select long_name,short_name from games_list order by long_name"); $rowcount = mysql_numrows($number); $newvart = mysql("squadlinks", "select long_name,short_name from games_list order by long_name"); print " Search by Key Word:

Games played:

"; ?>