ID City Name Attraction Population(in mill) Landmarks Economy
1 London 20 8.2 Trafalgar Square £30,000+
2 Cardiff 15 0.3 Millennium Stadium £30.000-
3 Liverpool 14 0.4 Royal Liver Building £15.000+
and i retrieve the info with simple:
Code: Select all
$invinfo="SELECT * from Cities where attraction <= '$playerinfo3[Overall]'";
$invinfo2=mysql_query($invinfo) or die("could not get opponent stats!");
$invinfo3=mysql_fetch_array($invinfo2
City Name Attraction Population(in mill) Landmarks Economy
London 20 8.2 Trafalgar Square £30,000+
Cardiff 15 0.3 Millennium Stadium £30.000-
Liverpool 14 0.4 Royal Liver Building £15.000+
sorry if i have not described this well and i hope that this is possible