$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");


while (  $rowl = mysql_fetch_array($resulturl) )
{
   list ($mylist['country'], $mylist['state'], $mylist['country'], $mylist['country'] = explode("/",  $rowl['friendly_url_path']);
}