wutang Posted May 28, 2006 Share Posted May 28, 2006 Hiya all I am developing an online music application in php mysql. I wanted to know when my members login they can add music tracks to their personal library so when they log back on there library page will have each track they updated their library with Link to comment https://forums.phpfreaks.com/topic/10651-online-application/ Share on other sites More sharing options...
Barand Posted May 28, 2006 Share Posted May 28, 2006 You need at least 2 db tables, member and trackWhen they upload a track, store the path/filename in the track table with their member_id and other detailsTables[code]member track--------- ----------member_id <---+ track_idusername | titlepassword | filepathetc +---- member_id[/code]Sample data[code]track-------id | title | path | member_id 1 | Moon River | xxx/000001.mp3 | 1 2 | Nessun Dorma | xxx/000002.mp3 | 1 3 | Birdie Song | yyy/000003.mp3 | 2 4 | My Old Mans a Dustman | yyy/000004.mp3 | 3[/code]Select tracks with their id from track table when the go to their library page. Link to comment https://forums.phpfreaks.com/topic/10651-online-application/#findComment-39782 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.