>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')";
Incorrect in mySQL you can do
mysql> select 3+5;
returns 8
plus a whole lot of other functions that
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
3 matches
Mail list logo
