Re: Next page every second

"Greg Wardawy" <wardawyg@xxxxxxxxxxxxx> · Fri, 24 Dec 2004 08:46:42 -0600

Thanks a lot Sagar,

The logic looks perfect. Having no web programming experience at all I 
didn't even know what I was looking for.

And I didn't know I needed a java script for the PHP page.

Greg.

----- Original Message ----- 
From: "Sagar C Nannapaneni" <sagar@xxxxxxxxxxxxxxx>

To: "Greg Wardawy" <wardawyg@xxxxxxxxxxxxx>; <php-general@xxxxxxxxxxxxx>

Sent: Thursday, December 23, 2004 1:25 PM

Subject: Re:  Next page every second

If all you want to display each record one by one at a particular interval
of time
you could do this at one page itself...here is the procedure....

1. connect to mysql

2. grab the row you want

3. store the row number in a session variable

4. Add an autorefresh code to ur html..(lot of java scritps are there for

setting the time interval for the page refresh)

5.  when the page again loads grab the row number from session and 
increment

it by one

hope that the logic will work out...

/sagar
----- Original Message -----
From: "Greg Wardawy" <wardawyg@xxxxxxxxxxxxx>
To: <php-general@xxxxxxxxxxxxx>
Sent: Friday, December 24, 2004 10:39 AM
Subject:  Next page every second

Ladies and gentlemen of PHP,

I'm quite new to PHP (coming from Perl) so please don't laugh too hard if
I'm missing something obvious.
My scenario is as follows:
Connect to the MySQL server->grab the data from the table->display the
data
of the first row on the web page->sleep 1 second->display the data from
the
next row->sleep 1 second... and so forth up to the last row of the table.

I'm able to get the next page displayed by using a link to it (a snippet

below) but I'm out of ideas how to have the next page displayed every

second. So far I'm getting tons of tables displayed on the page or tons 
of

the variables displayed in a single cell of the table. I could really use

your help here.

Happy Holidays to all of you and many thanks for any suggestions given.

Greg.

############################################################################
#############
__SNIP__
<table width="420" height="12" border="3" cellpadding="6" cellspacing="4"
bordercolor="#9900CC">
  <tr>
    <th width="60" scope="col">Variable</th>
    <th width="360" scope="col">Value</th>
  </tr>
  <?php do { ?>
  <tr>
    <th width="60">1</th>
    <td width="360" nowrap="nowrap" bordercolor="#660066"
bgcolor="#FFFFFF"><div align="right" class="style8">        <?php echo
$row_gail_data['var1']; ?>    </div></td>
  <tr>
    <th width="60">2</th>
    <td width="360" nowrap="nowrap" bordercolor="#660066"
bgcolor="#FFFFFF"><div align="right" class="style9">        <?php echo
$row_gail_data['var2']; ?>    </div></td>
  </tr>
  <tr>
    <th width="60">3</th>
    <td width="360" nowrap="nowrap" bordercolor="#660066"
bgcolor="#FFFFFF"><div align="right" class="style10">        <?php echo
$row_gail_data['var3']; ?>    </div></td>
  </tr>
  <tr>
    <th width="60">4</th>
    <td width="360" nowrap="nowrap" bordercolor="#660066"
bgcolor="#FFFFFF"><div align="right" class="style7">        <?php echo
$row_gail_data['var4']; ?>    </div></td>
  </tr>
  <?php } while ($row_gail_data = mysql_fetch_assoc($gail_data)); ?>
</table>
</p>
<p><a href="<?php printf("%s?pageNum_gail_data=%d%s", $currentPage,
min($totalPages_gail_data, $pageNum_gail_data + 1),
$queryString_gail_data);
?>">Next</a>
</p>
__SNIP__

############################################################################
#############

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php