Advertisement
Guest User

Untitled

a guest
Dec 9th, 2019
142
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. // $sql = "SELECT C.ISO, C.ISONumeric, C.CountryName, C.Capital, C.CityCode, C.Area, C.Population, ";
  2. // $sql .= "C.Continent, C.TopLevelDomain, C.CurrencyCode, C.CurrencyName, C.PhoneCountryCode, C.Languages, ";
  3. // $sql .= "C.Neighbours, C.CountryDescription FROM countries C";
  4. // $sql .= "JOIN imagedetails I WHERE C.ISO LIKE I.CountryCodeISO GROUP BY C.ISO";
  5.  
  6. $sql = "SELECT C.ISO, C.ISONumeric, C.CountryName, C.Capital, C.CityCode, C.Area, C.Population,
  7. C.Continent, C.TopLevelDomain, C.CurrencyCode, C.CurrencyName, C.PhoneCountryCode, C.Languages,
  8. C.Neighbours, C.CountryDescription FROM countries C
  9. JOIN imagedetails I WHERE C.ISO LIKE I.CountryCodeISO GROUP BY C.ISO;";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement