2. PHPRunner General questions
  3. Enabling individual users to make comments on a fixed list of audio recordings
This topic is locked

Enabling individual users to make comments on a fixed list of audio recordings

 		9/17/2014 7:03:38 AM
PHPRunner General questions
M
 mlapl1 author

Hello
I am not sure if I am entitled to ask this question but here goes anyway. I have not used phprunner for some time so am a bit rusty. Sorry.
I have a number of audio recordings listed in a mysql table.
I would like each user to my website to be able to write comments and give grades or marks to each recording in the table. I also want to access any or all comments relating to any recording. I am not quite sure how to do this. I presume that I need to create some kind of joins or..??? but do not have much of a clue how to do this right now.
Any help at any level would be greatly appreciated and I hope it is not too time consuming for whoever is kind enough to respond.
Thank you so much
Andrew
E
 		expedict 9/26/2014



Hello
I am not sure if I am entitled to ask this question but here goes anyway. I have not used phprunner for some time so am a bit rusty. Sorry.
I have a number of audio recordings listed in a mysql table.
I would like each user to my website to be able to write comments and give grades or marks to each recording in the table. I also want to access any or all comments relating to any recording. I am not quite sure how to do this. I presume that I need to create some kind of joins or..??? but do not have much of a clue how to do this right now.
Any help at any level would be greatly appreciated and I hope it is not too time consuming for whoever is kind enough to respond.
Thank you so much
Andrew


I'm also new to PHPRunner, but your question is actually more general. Your instinct is right: If you're populating a MySQL database table with details of these recordings, the best way to associate comments and marks to each recording is to record those in a separate table. There would be a one-to-many relationship between the two tables (each recording's primary key can have zero to multiple related records in the linked table). Let me know if what I say here is still too general. If so, I can try to help with the creation of the second table and linking the two.
Michael
Sergey Kornilov admin 9/26/2014

I can confirm that use of Master-Details is the best choice here. You can have multiple comments associated with each recording this way.