Re: [PHP] Stringing sql queries?

2001-02-03 Thread Thomas Weber

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: [EMAIL PROTECTED]
Homepage: http://www.youngarts.org / http://www.visions-of-future.de

- Original Message - 
From: "Sandeep Hundal" [EMAIL PROTECTED]
To: "PHP General" [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail: [EMAIL PROTECTED]
 


-- 
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] Stringing sql queries?

2001-02-03 Thread Randy Johnson

What about an insert or an update instead of a select?

thanks

randy

-Original Message-
From: Thomas Weber [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 03, 2001 8:37 PM
To: Sandeep Hundal
Cc: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
Homepage: http://www.youngarts.org / http://www.visions-of-future.de

- Original Message - 
From: "Sandeep Hundal" [EMAIL PROTECTED]
To: "PHP General" [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail: [EMAIL PROTECTED]
 


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



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