page refresh

[henryhenry]

I have a bit of an issue with refreshing pages...When you hit refresh, the script resends any SQL queries to the DB (the page is handled on the same page). This is particularly annoying on a form with INSERT queries.I have tried the following (which work but aren't great)- look up data and compare before the insert/update- make columns unique in database- redirect using headers() but can be a pain if 'headers already sent'I would love just to use a simple variable to tell me if the page was refreshed and if so not to run queries! Does anyone know a trick that can make this work?Thanks!Henry

[justsomeguy]

You can set a cookie when you do the insert, include the info that you just inserted in the cookie, and if you get a request for an insert and there is a cookie that contains the same info, then ignore the insert.Actually, the session would be better for that then cookies.

[Nakor]

Or you could add code to your SQL commands to not execute the commands if a table, column, cell, or anything already exists. I think that would be easier.

[justsomeguy]

I think the statements are probably insert statements, not dealing with table creation or altering a table, so the presence of a field in the table wouldn't tell you if an insert occured 5 seconds ago.

[Nakor]

Good point. It all just depends on what it is that they are doing. I suppose that I missed that part that said that he was going to be using the same form that submits the data to insert it. In that case you are definitely right.

[henryhenry]

HelloYes it was primarily insert/update/delete - I am using software to make tables/columns...The cookie method sounds perfect! I will definitely be giving that a try! Thanks once again! This forum is sooo helpful!Henry