showing graphic while search db

ugasucks

goodmorning/afternoon/evening all.

i was approached today and asked to show an animated "searching" logo while a database query is taking place (it's a query on two databases that it fairly complex.) the el bosso wants the user to not feel like something has stalled while the query is running, thus the need for the graphic.

how should i approach this? all that i've done is run queries and output results... is there a return value from the database that i can monitor and then transition the user using a header()?

any help, insight, or insults will be appreciated.

bastien

when executing the search, call the animation for your search logo, then when the page has results either call the function to show the data or redirect to another page...

Xnuiem

how would it handle multiple pages? Is there a way to cache the results so each page using next/prev buttons is nice and quick?

Tracer

I asked this question couple weeks ago and somone posted this javascript... works great.

// all you logs and everything

<html>
<head>
<script language="JavaScript">
function opener() {
theChild = window.open('progress.html','wind_ref','height=200,width=200,');
}
</script>
</head>
<body onUnload="if ((theChild) && !(theChild.closed)) theChild.close()">

</body>
</html>