I have a function that helps to create a new user, the query looks like so:
$query="INSERT INTO users (username, password, etc, etc)
Now I need a function that updates the user details, so when I call update user it updates the database with all of the vlaues. The problem I have is that when I run this updateuser function in any of my scripta I get:
"Died inserting login info into db. Error returned if any: 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 '(username, password"
Off the following change:
$query="UPDATE users (username, password, etc, etc where username=$username)
$username is defined in the script as I have already run a query to select * from the user table.
ANy ideas? (I hope it is a simple one)