Hi, I am trying to make the following 3 scripts of code produce output that is in alphabetical order. I understand it needs to contain the statement ORDER BY, however not sure where to place it. Can someone please assist? Much appreciated! ************************************************** $result = mysql_query("[b]SELECT[/b] city_id, City [b]FROM[/b] city [b]WHERE[/b] country_id =".$country_id); ************************************************** $result = mysql_query("[b]SELECT DISTINCT[/b] category.category_id, Category [b]FROM[/b] category [b]INNER JOIN[/b] cat_city_bus [b]ON[/b] category.category_id = cat_city_bus.category_id [b]WHERE[/b] City_id = ".$city_id,$connection); ************************************************** $query = "[b]SELECT[/b]directory.business_id as dID, category.Category, Business, Address1, Address2, Address3, city.City, city.State, Postcode, country.Country, Telephone, Website, Email, Details, Picture [b]FROM[/b] cat_city_bus [b]INNER JOIN[/b] category [b]ON[/b] cat_city_bus.category_id = category.category_id [b]INNER JOIN[/b] city [b]ON[/b] cat_city_bus.city_id = city.city_id [b]INNER JOIN[/b] directory [b]ON[/b] cat_city_bus.business_id = directory.business_id [b]INNER JOIN[/b] country [b]ON[/b] city.country_id = country.country_id [b]WHERE[/b] cat_city_bus.city_id = ".$city_id." [b]AND[/b] cat_city_bus.category_id = ".$category_id; $result = mysql_query($query, $connection); **************************************************