Posted by Sam on 11/18/05 17:38

Hi,

Another question:

As per my previous post, my database is very simple: User ID, Country,
Postcode and Date.

This information is entered through the browser via a standard form
which works well.

Problem: If the user clicks on the browser's refresh button, the same
data gets added to my SQL database as a new record. Everytime refresh
is hit, a new record is added with the same data.

What's the best way to prevent this from happening?

I know you can set fields as being unique in MySQL, but can you set -
say - an entire row? So another duplicate row containing all of the
same values could not be written? This would be sufficient for my
needs!

Thanks in advance!

Sam Day.

• Next in forum: Re: Adding hyperlinks to a table?
• Prev in forum: Re: tried everything
• Thread view: Ensuring a web page refresh doesn't create a new record

[Reply to this message]