Re: mysql query . need help!!!!!
| From: | _lallous | Date: | Tue, 04 Sep 2001 15:25:52 +0000 |
| Subject: | Re: mysql query . need help!!!!! | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-65895@lists.php.net to get a copy of this message | ||
Nope,
MySql doesn't allow select within select...
try making two seperate queries...
"Lizlynch" <lizlynch50@hotmail.com> wrote in message
news:OE32IcXZwKIjKoNC8Bg00002d7e@hotmail.com...
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