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

 

[Pho]

Could you not use Javascript / AJAX to call another PHP script to check if the query has completed? When your query finishes it could insert the user's session ID (or some other unique value for the action their performing) into a temporary table which the AJAX script could check.

I imagine there's better ways though.