MySQL - Query within a query
| From: | Pete Ruby | Date: | Wed, 16 Mar 2005 05:03:19 +0000 |
| Subject: | MySQL - Query within a query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-38958@lists.php.net to get a copy of this message | ||
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 Drivers.DriverID = $Result1.DriverID
WHERE $Result1.DriverID) Is Null ORDER BY Drivers.DriverID");
I can do it w/ Access and MSSQL, but if I try in MySQL, i get an error, both
in DBManager (MySQL interface), and in PHP.
Any help is appreciated. Thanx!
Pete