epicpete

Thanks, great idea - I can't believe I didn't think of making a separate table for comments. Thanks Again Pete

Hey, I'm currently working on a site whereby users can comment on images and videos in a youtube style way. At some point I'm going to implement a way for users to post videos and images but I haven't done this yet. Videos are navigated to by video?id="videoid" Images are navigated to by image?id="imageid" I plan to make a comment section on each page, what i'm wondering is how sites of this type store comments. I could give each video/image a new table but this could be hard to control considering at some point users will be able to submit there own resulting in new tables. Is it possible to store comments in another way - like a comma separated list in the style: user,comment,user,comment, If so how would I do this using a 'for each'? $a = split(',', $row['comments']); foreach ($a as $value) { echo("$value"); } the code above only grabs the comment. Is there a way I can make it give say $a the value of a user, then $b a value of comment? If I could get this to work it would mean I could just have one table for the video/image with fields 'name','desc','videoid','comments' which would be ideal I hope you see where i'm coming from Thanks in Advance Pete