Re: [PHP] is this right

[Alexander Wagner]

Jeremy Morano wrote:
> insert into test (uid, companyUid)
> values(1, select uid from companysTable where company = "Micrsoft");

insert into test (uid, companyUid) select 1,uid from companysTable 
where company = "Micrsoft";

I hope this works.

HTH
Wagner

-- 
Madness takes its toll. Please have exact change.

-- 
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]

RE: [PHP] is this right

[Boget, Chris]

> this doesn't work,how should it be done?
> insert into test (uid, companyUid)
> values(1, select uid from companysTable where company = "Micrsoft");

If you are using MySQL, it doesn't support sub selects...

Chris