Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // $sql = "SELECT C.ISO, C.ISONumeric, C.CountryName, C.Capital, C.CityCode, C.Area, C.Population, ";
- // $sql .= "C.Continent, C.TopLevelDomain, C.CurrencyCode, C.CurrencyName, C.PhoneCountryCode, C.Languages, ";
- // $sql .= "C.Neighbours, C.CountryDescription FROM countries C";
- // $sql .= "JOIN imagedetails I WHERE C.ISO LIKE I.CountryCodeISO GROUP BY C.ISO";
- $sql = "SELECT C.ISO, C.ISONumeric, C.CountryName, C.Capital, C.CityCode, C.Area, C.Population,
- C.Continent, C.TopLevelDomain, C.CurrencyCode, C.CurrencyName, C.PhoneCountryCode, C.Languages,
- C.Neighbours, C.CountryDescription FROM countries C
- JOIN imagedetails I WHERE C.ISO LIKE I.CountryCodeISO GROUP BY C.ISO;";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement