RE: [PHP] Stringing sql queries?

So you are talking about two different queris in one call? No, you can't do this ... you have to then use some kind of loop or something ... Sincerely, Maxim Maletsky Founder, Chief Developer PHPBeginner.com (Where PHP Begins) maxim@phpbeginner.com www.phpbeginner.com -----Original Message----- From: Randy Johnson [mailto:programmer@jennybug.com] Sent: Sunday, February 04, 2001 2:25 PM To: Thomas Weber; Sandeep Hundal Cc: php-general@lists.php.net Subject: RE: [PHP] Stringing sql queries? What about an insert or an update instead of a select? thanks randy -----Original Message----- From: Thomas Weber [mailto:thomas@youngarts.org] Sent: Saturday, February 03, 2001 8:37 PM To: Sandeep Hundal Cc: php-general@lists.php.net Subject: Re: [PHP] Stringing sql queries? Yep, try this: SELECT a.col1, a.col2, b.col3, c.col4 FROM table1 a, table2 b, table3 c This should give you an array [col1,col2,col3,col4] Thomas Weber --- EMail: thomas@youngarts.org Homepage: http://www.youngarts.org / http://www.visions-of-future.de ----- Original Message ----- From: "Sandeep Hundal" <sandeep_wde@yahoo.com> To: "PHP General" <php-general@lists.php.net> Sent: Sunday, February 04, 2001 1:44 AM Subject: [PHP] Stringing sql queries? > All, > can I string 2 sql queries one after the other? > like "select * from $table; select * from $table2;" ??? > > If I can, does that mean if I use mysql_fetch_array then it'll > convert results from both queries into variables? > > TIA > > > __________________________________________________ > Get personalized email addresses from Yahoo! Mail - only $35 > a year! http://personal.mail.yahoo.com/ > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net