joecooper Posted March 31, 2013 Share Posted March 31, 2013 I have a database full of around 30,000 urls. Each url is like this, but some have less folders, some more. "http://www.site. net/Music/artist/Album/Song.mp3" I need to split each of the file names into a seperate feild in the database. My code so far: $query = sprintf("select * from urls"); $result = mysql_query($query, $link); if ($result) { while($row = mysql_fetch_array($result)) { $fullurl = $row['url']; } }else{ echo mysql_error(); } How can I split the string so that anything after the last "/" gets added into the new feild. I know the MySQL side, just not how to split to the last "/". Thanks Joe Link to comment https://forums.phpfreaks.com/topic/276351-split-a-string-and-find-the-last-split/ Share on other sites More sharing options...
Jessica Posted March 31, 2013 Share Posted March 31, 2013 Explode and array_pop Link to comment https://forums.phpfreaks.com/topic/276351-split-a-string-and-find-the-last-split/#findComment-1422117 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.