mysql query . need help!!!!!
| From: | lizlynch | Date: | Tue, 04 Sep 2001 13:49:16 +0000 |
| Subject: | mysql query . need help!!!!! | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-65891@lists.php.net to get a copy of this 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