You cant use a select statement withoug using a table name.
check out this
$query = "insert into classification(customername) (select customername from username 
where username='$username')";

i cant answer ur second question, since i dont the
structure of your table


original message ------------------------

MySql doesn't allow select within select...
try making two seperate queries...

"Lizlynch" <[EMAIL PROTECTED]> wrote in message
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

Reply via email to