I have a 3 page registration form where a user can regsiter for an online service. Page 1 gathers personal info and page 2 gathers services desired.
In page one I have an INSERT script to input all the data. In page 2 of the registration I have a $_SESSION that grabs the ID created from page 1 and then instead of an INSERT script I have an UPDATE script to update the additional fields needed for the user.
So, when you click on "next" of page 1 of the registration form everything works fine (you're taken to the next page, data is entered in the DB), when you hit "next" on page 2 I get the following error:
Any help would be greatly appreciated... let me know if you would like to see code or anything to help me out!Code:Error in query: UPDATE client SET service='service1' WHERE ID=. You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1