Hi, I have a form for customers to enter requests, this form posts to a php script which checks if all fields have been populated and, if so, sends the data to a database. If not all fields have been populated the user gets returned to the form and error messages appear to tell them what was missing.

My problem is that when the form is displayed with the error messages, all the data the user had entered is gone so they have to fill...

thanks jpr0325, this is exactly what i was looking for

I am using a text box to search database for a reference number, the search is working ok but i am getting this error when i load the page for the first time:

Warning: mssql_fetch_obj ect(): supplied argument is not a valid MS SQL-result resource in C:\Documents . . . on line 167

When i do a search i get the expected results and the error disappears

here is my code:
...