Re: Refresh (F5) adds another SQL record.

As a last resort, I may have to do that, but that is by no means the preferred method. I want to keep database access to a minimum. I thought by this time this problem would have had a standard solution. It would be nice if PHP had a function like refreshed() so one could do ... if (!refreshed()) { ... } ..., but I guess not. Thanks for your input. Regards, Robert "Marcus Joyce" <newsletters@online-obsession.com> wrote in message news:428A7964.5000905@online-obsession.com... > 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 >>