Loading Page whilst getting data from database

[dean_e_boy]

Between one web page and the next I generate a list based on a sql query that can take up to 40 seconds to run. How can I put a message stating that I am generating the data. I have written the two pages using php.

Any suggestions would be fantastic