$resulturl=mysql_query("SELECT title, friendly_url_path, id
FROM pmd_v2_locations
WHERE level =4
AND friendly_url_path LIKE 'United-States/arkansas%'
ORDER BY title");

$mylist = array(
   'countires' = array(),
   'states' = array(),
   'cities' = array(),
);
while (  $rowl = mysql_fetch_array($resulturl) )
{
   list ($country, $state, $country, $city) = explode("/",  $rowl['friendly_url_path']);
   $mylist['countries'][] = $country;
   $mylist['states'][] = $state;
   $mylist['cities'][] = $city;
}