[PHP] mysql query . need help!!!!!

[lizlynch]

i have two tables here, i want to insert the customername from the Username table and 
insert it into the Classification table.
 is the below query correct cause i can't seem to get it to work.

 $query = "INSERT INTO Classification (Customername)
 (SELECT Customername)
  FROM Username
  WHERE Username = '$Username')";

i also want to insert a form value into the classification table at the same time is 
that possible.

cheers liz lynch