Accessing the same row twice.

[LiamBailey]

I am doing a blog that I want to allow other people to post to. I know how to set up the entry form, and how to insert the post into the DB.

What I want to do is then write the post into a html file, I know how to create and write the file, even how to put dashes in between the url, but how can I get it to create the file with the right row from the datatbase.

Like if two people posted simultaneously, how can I make sure the right file is created from the right post.

A better way to ask it may be, if I said that I wanted to have some information added to a row from a form on one page, and then on the next page some more information to be entered into the same row, how could I achieve this is multiple people were entering their data into the forms at the same time?

[peytonrm]

I'm not sure why you would want to output an html file versus just having a php script that reads the database and returns html. If it's SEO you're worried about, you might look into apache's mod_rewrite.

MySQL will lock the row (or the whole table depending on the table type) during a write, so you don't have to worry about simultaneous writing occuring. If you use a php script to pull from that row, you will always be getting what is most current in the database.