joecooper Posted March 31, 2013 Share Posted March 31, 2013 (edited) 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 Edited March 31, 2013 by joecooper Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.