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@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:428A7964.5000905@xxxxxxxxxxxxxxxxxxxxxxx
> 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
>>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
