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]
