Page Refesh

vivin1

Hi there -
I have queries that take 10-15 seconds to run, they pull data from 10-12 tables, the data varies anywhere from 500 - 2000 rows. Thats really not my issue.

My issue is probably something to do with HTML refresh. What i want is a temp page to be displayed while the query is running. As soon as the query is complete, the temp page shud dissapear and the results of the query shud take its place, something like the one in Priceline, orbitz (Wait... Searching for the best available deal ')

Heres the structure of my code

</form>

run_query.php

<?
include('temppage.php'); // This is the temp page that i m

//referring to

run query; // execute the query here

include('displayresult.php') // include a new page that display the
// results of the page the

But wat happens here is that - since temppage.php is already included at the begining, displayresult.php gets displayed below it, so both the pages show after the query is executed.

Wat i want is - after the query is exected just one page is displayed - 'displayresult.php' and not both

is there any way i can do it ???

Your help wud be greatly appreciated

Thank you
Viv

batman

Try:

**************** 
run_query.php 
***************** 
<? 
include('temppage.php');

$sql = mysql_query("SELECT * FROM table"); 

if(!$sql)
{
echo "I'm sorry no results were found at this time.";
}
else
{
include('displayresults.php'); 
}


?>

vivin1

Batman - that won't work

<?

include('temppage.php');

$sql = mysql_query("SELECT * FROM table");

if(!$sql)
{
echo "I'm sorry no results were found at this time.";
}
else
{
include('displayresults.php');

}
?>

with your code - two pages wud still be displayed
temppage.php
displayresults.php (wud be dispalyed below temppage.php)

and temppage.php is the one which has my message - 'Processign Query... Please wait'

Do you see any other way ???

Thank you
Viv

batman

I dont think you understand. The way I set it up is to where it will show temppage.php all the time, which is the page that says "doing query....please waite."

After that I made it to where it will only show results.php if it gets something from the database. Other wise it will give error.

Did you even try the code?

vivin1

I did try your code

But then tempapge.php stays there forever - so the message 'processing query - please wait' stays there regardless of the results being fetched.

so the final output is lsoething ike (assuming that the query did pull some records)

Processing query, please wait.....

customer | order
ANF 1000
REEBOK 1001

Wat i want is that the message 'Processing query, please wait.....' (i.e. the file temppage.php) should not stay and after query execution there be some kind of refresh automatically so that next time only 'displayresults.php' gets included.

batman

<? 
$done = $_GET['done'];

if($done == "")
{
$sql = mysql_query("SELECT * FROM table");

if(!$sql) 
{
echo "I'm sorry no results were found at this time."; 
} 
else 
{
$done = "yes"; 
}
echo "Please stand by.....";
}
else
{
//do an http refresh right here to $PHP_SELF
//like: slef.php?done=yes
}


//link to this page like:  page.php?done=
?>

I am a little tired so what I wrote might not work without some tweeking. You might get the general idea of what I am trying to do here. I hope so.