So I\'m creating a temporary table by selecting and summing a driverPoints column. How long does that table exist? Until I drop it, or just until the next query?
This query works when I enter it in PHPmyAdmin, but not when I run it from a script.
$Query1="create temporary table pointsList select carNum, sum(driverPoints) from raceResults group by carNum";
$Query="SELECT * from pointsList LEFT JOIN racePilotsAssoc ON pointsList.carNum=racePilotsAssoc.carNum LEFT JOIN raceDrivers ON pointsList.carNum=raceDrivers.carNum WHERE racePilotsAssoc.raceNum=$raceNum or racePilotsAssoc.raceNum IS NULL order by driverPoints";
I\'m not really a pro at this, but I can learn quick :-) Anybody have any ideas just from glancing at it?
Thanks a lot for any help anyone gives.[/code]