Perform query on existing query

[NigeB]

Is there a way to perform a query and generate a table then perform a query on that table to give another? This is probobly easy, but I require this to be done each time the first query is run to bring back data to a web page (PHP)

Many thanks in advance

Nigel.

 

[rycamor]

See

http://www.mysql.com//doc/I/N/INSERT_SELECT.html

and

http://www.mysql.com//doc/M/i/Missing_SELECT_INTO_TABLE.html

Your best bet is to create a temporary table of type=HEAP, which will run in memory, thus much faster. The only problem with this type of table is that it doesn't support BLOBS or TEXT, but it supports all the other types.

 

[NigeB]

when you say type=HEAP, do you refer to the first table or the second which the ultimate query will be performed upon.

To give a little more information -

1st query - select last 3 outings for each team

2nd query - select all records less than 4 months old.

3rd query - group each team and printf [fastest time] for each team

I have no problem writing the individual queries, but I am unable to write one query to cover all criterea. (having done the same task in access, it took 3 sepertae queries)

And how do I remove all the records once the data has been retreived and displayed, should this be done prior to the first query and should I delete the tables or after the last query?

Many thanks in advance for your advice.

Nigel.