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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
