Insert Query help

[PRodgers4284]

Im looking to use an insert query to insert values into a table, i need the query to lookup the username of the person that is logged in and add the values to the table row assigned to that user.

 

$query = "INSERT INTO cv (name, size, type, path ) ".
		 "VALUES ('$fileName', '$fileSize', '$fileType', '$filePath')";

 

I need add the followinf where statement in

 

WHERE username='" . $_SESSION["username"] . "'")); 

 

 

[Daniel0]

You cannot have WHERE clauses in an INSERT. What are you doing to check against after all?

[PRodgers4284]

You cannot have WHERE clauses in an INSERT. What are you doing to check against after all?

 

Just want values to be inserted in the correct row in the table based upon the user that is logged in

[rhodesa]

You are looking for an UPDATE not an INSERT

 

http://dev.mysql.com/doc/refman/5.0/en/update.html