Re: Re: mysql query . need help!!!!!
| From: | Jon Farmer | Date: | Tue, 04 Sep 2001 16:17:51 +0000 |
| Subject: | Re: Re: mysql query . need help!!!!! | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-65904@lists.php.net to get a copy of this message | ||
>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 can be selected without a table
name.
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07968 524175
PGP Key available, send blank email to pgpkey@bctech.co.uk