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");
If you're using MySQL 4.1, which supports subqueries, you might be able to write this all up as one nice query (using a sub-select).
Larry