$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();
while (  $rowl = mysql_fetch_array($resulturl) )
{
   list ($country, $state, $region, $city) = explode("/",  $rowl['friendly_url_path']);
   $mylist[]['country'] = $country;
   $mylist[]['region'] = $region;
   $mylist[]['state'] = $state;
   $mylist[]['city'] = $city;
}