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 Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/10651-online-application/#findComment-39782 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.