Loading form info on page load.

[acctman]

I have three questions, first one involves loading/retrieving info to a Form when a user loads the page and the second is Updating and Inserting data back into a db. I believe there is a mysql code that will Update or Insert all in one shot. Last question is how not to lose data when a submit error happens.

 

1. I have a .tpl (html and php code) file that has a form I need to retrieve all values from a database and display into form when user loads page.

 

2. When user submits changes Updates and new Inserts what would be the php sql code to use.

 

3. If user leaves a set field blank how can I error the submit without clearing all the data? Is there a way to do it with ajax/dhtml or php code.

 

thanks in advance