Re: Refresh (F5) adds another SQL record.
| From: | Marcus Joyce | Date: | Tue, 17 May 2005 23:08:20 +0000 |
| Subject: | Re: Refresh (F5) adds another SQL record. | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-215423@lists.php.net to get a copy of this message | ||
Why dont you check that data isnt being duplicated?
$query = "SELECT auto_col FROM table where col1 = $var1 & col2 = $var 3.............";
$call_query = mysql_query($query,.......
$query_data = mysql_assoc($call_query);
if(!$query_data) { do form }
else echo "information already exists in database";
Pierce
Robert Meyer wrote:
Hello, Scenario: 1) User is presented a blank form. 2) User fills in form. 3) User submits form. 4) Record is added to database. 5) Back to 1). All is fine to here. 6) User clicks refresh. 7) Another record is added, same data except auto-increment field. How do I prevent these last two steps, or at least prevent a record from being added when refresh is clicked? Regards, Robert