Aren't we oversimplifying the issue assuming that the records inserted cannot have everything duplicated but the autoincrement field?
If you are taking an order and the customer says 'hey, add another of this', with the code below the system will reject it because it assumes that it is a refresh and not a new addition to the order. You are in the supermarket line and the teller is scaning your purchase for the barcodes. You wouldn't be able to buy more than one of each! (I know that you wouldn't use a browser in that environment, but for the purpose of the database analysis, it just shows the point) NO, some tables do have records which are basically duplicate of one another except for the autoincrement field, and those cannot be checked this way. And, besides, as mentioned elsewhere in this thread (myself included) there are easier ways which do not even involve database access. Satyam "Marcus Joyce" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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
