Re: [PHP] is this right

2001-07-24 Thread 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

RE: [PHP] is this right

2001-07-24 Thread 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

[PHP] is this right

2001-07-24 Thread Jeremy Morano
this doesn't work,how should it be done? insert into test (uid, companyUid) values(1, select uid from companysTable where company = "Micrsoft"); -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To cont

[PHP] is this right?

2001-07-19 Thread Jeremy Morano
is this right? cause its not working. first I connect, then I select my db, and then the problem $sql = "GLOBAL $company; DROP TABLE $company "; $result = @mysql_query($sql,$connection) or die("Couldn't execute query."); -- PHP General Mailing List (http://www.php.net/) To unsub