nards656

So... I can use CREATE TEMPORARY TABLE pointsList AS SELECT carNum, sum(driverPoints) AS totalPoints FROM raceResults GROUP BY carNum Or is that too many ASes? Of course there would also be some changes to the second query. I simply could not invent a way to do this with a single query, but my inexperience could be the cause for that. Thanks a lot.

Thanks so much; I\'ll take a look at this later tonight. \"AS\" is quite honestly not a thing I understand completely yet, so I\'ll be studying some SQL to get in my head how your solution really works. Also found out that part of my trouble was in the (sum)driverPoints; using that command in the temporary table leaves me with a column named \'sum(driverPoints)\', and then referring to it by that name later in my mysql_fetch_array loop resulted in an error. I was able to go to the numeric reference and eliminate that confusion, but there may be a better way??? Thanks again.

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]