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 /sagar original message ------------------------ Nope, MySql doesn't allow select within select... try making two seperate queries... "Lizlynch" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... 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
