mysql comments

[Alidad]

I'm trying to create the comments forms for people to comments about any subject. I created database but i'm not sure how is that works if i have more then one subject and each subject have they own comments.

in my sql i created:

message_id

name // name of person
email // email of person
comments // comments
submitted // timestamp

my next step is that how can i create comments if is more then one subject! for sample let say that first page showing picture of "United State" and have they own comments forms then show list of comment people who have posted.

Then second page showing other images of "france" then have they own comments forms along with list of comments that people have posted comments.

If i have menu to select or link that selected "france", then redirect to that page and show comments and images about france, how do i can do in database to show seperate comments subject, i think to use relationship but not sure what to put in databse!

AM

[Arenlor]

I'm not quite sure what you're asking but my best shot in the dark is this:

_________________________________________________
|message_id|page_id|name|email|comment|submitted|
|__________|_______|____|_____|_______|_________|

So your American page would be page 1 and the France page would be page 2, that's how you'd sort them per page. message_id is auto_increment and primary key. Both IDs would be INT. Name would be text, email would be text (make sure to regexp the email) the comment would be text, and submitted would be time.

<?php $page=$_GET['page']; //That's if you hade http://example.com/?p=1
$name=$_POST['name'];
$email=$_POST['email'];
$comment=$_['comment'];
if(($name != '' && $email != '') && ($comment != '' && ereg("^([0-9a-zA-Z]+[.|-]?)+@([0-9a-zA-Z]+[.|-]?)+\.(aero|biz|cat|com|coop|edu|gov|info|int|jobs|mil|mobi|museum|name|net|org|travel|ac|ad|ae|af|ag|ai|al|am|an|ao|aq|ar|as|at|au|aw|az|ba|bb|bd|be|bf|bg|bh|bi|bj|bm|bn|bo|br|bs|bt|bv|bw|by|bz|ca|cc|cd|cf|cg|ch|ci|ck|cl|cm|cn|co|cr|cs|cu|cv|cx|cy|cz|de|dj|dk|dm|do|dz|ec|ee|eg|eh|er|es|et|eu|fi|fj|fk|fm|fo|fr|ga|gb|gd|ge|gf|gg|gh|gi|gl|gm|gn|gp|gq|gr|gs|gt|gu|gw|gy|hk|hm|hn|hr|ht|hu|id|ie|il|im|in|io|iq|ir|is|it|je|jm|jo|jp|ke|kg|kh|ki|km|kn|kp|kr|kw|ky|kz|la|lb|lc|li|lk|lr|ls|lt|lu|lv|ly|ma|mc|md|me|mg|mh|mk|ml|mm|mn|mo|mp|mq|mr|ms|mt|mu|mv|mw|mx|my|mz|na|nc|ne|nf|ng|ni|nl|no|np|nr|nu|nz|om|pa|pe|pf|pg|ph|pk|pl|pm|pn|pr|ps|pt|pw|py|qa|re|ro|rs|ru|rw|sa|sb|sc|sd|se|sg|sh|si|sj|sk|sl|sm|sn|so|sr|st|su|sv|sy|sz|tc|td|tf|tg|th|tj|tk|tl|tm|tn|to|tp|tr|tt|tv|tw|tz|ua|ug|uk|um|us|uy|uz|va|vc|ve|vg|vi|vn|vu|wf|ws|ye|yt|yu|za|zm|zr|zw)$", $email))){
//That is every extention, even su
$connect = mysql_connect('localhost','user','password'); //Change this
$db = mysql_select_db('database'); //The database you use
$query = "INSERT INTO `table` VALUES(NULL,1,'$name','$email','$comment',NOW())";
$result = mysql_query($query);
//Not sure about whether or not NOW() needs quotes
}// Just so you know, this is just the code snippet that you'd use
//Also know that it assumes that you're on the same page with the rest of the code below
//If not then you'll need to pass the page number along in <input type="hidden">
?>