Query Status Display

[Raskolnikov]

I know this topic has been beat in to the ground as i have found quite a few treads on it. however they all deal with file download or file upload.

does anyone have a good way to keep the user entertained a mySql query is being made.

I have a database that query's rather slow. even just a motion graphic or something while it is loading the page would be nice.

part of it has to do with my server's amount of RAM. low budgets mean i have to make do with what i got till July. (it is for an intranet - only connected to about 12 other computers)

any help would be appreciated.

[jaswinder_rana]

try this. might be what you looking for
Goto this website http://www.trafficzap.com/pagerank.php
and enter any url to search google rank. while its searching for it, it opens a little popup which has a image in it which looks like a progress bar(kind of).

you can do something like this, in the same way or different way.

hope this helps

[ToolboxTech]

That's a great idea jaswinder_rana. Simple yet effective. Another option that I could think of is:

1) Upon clicking on the link, they are directed to a loading.php page which has a status graphic.

2) This loading page will make the query and store the results somewhere and, when complete, will redirect to the next page which has the results.

It's kind of complex so I would recommend using the idea above, but this was just a thought.

[Raskolnikov]

jaswinder...

I like the way that works. However, the loading box never disapeared. THat is something i could probably deal with, but do you know how you would code it to close the window automatically when the page is done loading?

Thanks

[jaswinder_rana]

now, i am not sure about this. i think they use refence to that window and then when they are done loading (whatever they load), they use that reference and close the window. this question might go in javascript section.