Reloading the page re-insert

[jaddy]

Hi,
I have some problems when I reload a page that contain Insert or Update query.

Each time I refresh that page, it will re-insert (or re-update) again to the database.
So the result will be mutiple extra records.

How can I improve my code so that when I do reload, no new data will be added to my database?

Thx.

[matto]

before doing the insert in your script, query the database if the record is already in it.

if so, don't do the insert.

of course the way of determining whether a record is already in a table depends on your db structure and the logic behind.

[jaddy]

It works fine, Thanx.

But I think there should be a better way to achieve this.
I dont think that quering the database is something perfect specially when you have a large size database.

My database has an auto-increment field and no other field is unique, so you have to include everything in that query.

Also I am destroying a session in that script,
so what I used to get in my database is an empty records whenever I refresh the page...

Is there is a better way to prevent reloading the page to re-insert records in my database??

Thx.