Re: [PHP] Forming an SQL query

2005-08-02 Thread Jack Jackson
Ah, I had left out the third column the first time! Thanks. Now I can insert and not create dupes but for some reason it is not updating. Here's the code: if ( ($_POST['action'] == 'process') && (!sizeof($message) ) ) { foreach($_POST as $key=>$val) {

[PHP] Forming an SQL query

2005-08-02 Thread Jack Jackson
Hi, Thanks to everyone's help, that multipage monster of a form is now working properly (yay!). One problem I have though is that I stick the answers as each page is completed into a table. If the user hits the back button, rather than adding a new row to the table I'd rather update it if it'