RE: [PHP-DB] MySQL - Query within a query

2005-03-19 Thread Bastien Koert
] MySQL - Query within a query Date: Wed, 16 Mar 2005 00:03:19 -0500 I am looking to do the following w/ MySQL and PHP. Have 1 query that gets results, then use those results in another query: $l = 2; $result1 = (SELECT * FROM Drivers WHERE League = $l); $result2 = mysql_query(SELECT DriverID

Re: [PHP-DB] MySQL - Query within a query

2005-03-19 Thread Larry E . Ullman
I am looking to do the following w/ MySQL and PHP. Have 1 query that gets results, then use those results in another query: $l = 2; $result1 = (SELECT * FROM Drivers WHERE League = $l); $result2 = mysql_query(SELECT DriverID, Driver, CarNbr FROM Drivers LEFT JOIN $LeagueList ON

[PHP-DB] MySQL - Query within a query

2005-03-18 Thread Pete Ruby
I am looking to do the following w/ MySQL and PHP. Have 1 query that gets results, then use those results in another query: $l = 2; $result1 = (SELECT * FROM Drivers WHERE League = $l); $result2 = mysql_query(SELECT DriverID, Driver, CarNbr FROM Drivers LEFT JOIN $LeagueList ON