Help... Insert into statement

[kpowning]

Ok, I have the following piece of scripting. What I'm trying to do here is insert the values() into a column named "vimage" where the row includes the usersname='$username'.

But I keep getting this error:

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 'where Username='kpowning'' at line 1

WHY??? PLEASE HELP I HAVE BEEN WORKING ON THIS SCRIPT FOR OVER 5 DAYS AND NO LUCK, VERY TIRED!!!

My script:

mysql_query("insert into membersrigs (vimage) values ('" . $_FILES['file']['name'] . "') where Username='$username'");

[LordShryku]

If you're using a "WHERE" clause, you should be doing an update....not an insert.

[kpowning]

Thank you, it works.. I really appreciate the help! 🙂