Re: Stringing sql queries?
| From: | Thomas Weber | Date: | Sun, 04 Feb 2001 01:36:49 +0000 |
| Subject: | Re: Stringing sql queries? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-38018@lists.php.net to get a copy of this message | ||
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
>