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!


PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to