Re: [PHP] is this right

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

RE: [PHP] is this right

> 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