[Resolved] Another Quick Question

[jazappi]

If I am adding customers to a database and then display them in a table at the bottom of the page, what is the best way to do that.

Example: Customer is adding information and hits a submit button that adds the info to a table in the db, below the form I have a table that shows the current information in that db table, so each time that I hit submit I need it to reload that table and show the new info.

Edit:
To tell you how I have it now.

Right now I have a the sql insert query the form and the display table all in the same page. I have a if statement around the insert query that checks to see if the form has been submitted, by lookin at a hidden field that has a value of "1" if its been submitted, the problem is if the user hits refresh and adds the info to the db again. So I need to clear the info some how.

[Phodetheus]

Users pressing refresh after a form subbmission will always be a problem as it re-submits the post form data.

You need to add a de-dupe check in your script that submits the data to the table i.e if it already exists don't add it.

Phodetheus

[kingbear]

Another option is you could POST to a php script which handles INSERTing the query into the DB and then at the end of the script you redirect the browser to the display table page, like, header("Location: DisplayTable.php"); This way a user hitting reload won't resubmit the form.

[jazappi]

what exactly is a de-dupe check?

[kingbear]

de-duplicate - that is, not inserting the same record twice.

[jazappi]

that makes sense, I was going to have the insert on the seperate page, but I wanted it to be quicker, so I will do that duplicate check. Thanks again guys.