Database Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Codewalkers ForumsOther TechnologiesDatabase Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Codewalkers Forums Sponsor:
AT&T devCentral & BlackBerry(r) Webcast Series: BlackBerry and GPS -Build Location Awareness into your BlackBerry Applications, July 10th-1:00PM EST. Register Today!
  #1  
Old December 1st, 2003, 05:28 AM
mdhall mdhall is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Posts: 158 mdhall User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
Auto query at timed intervals?

Anyone know if its possible to have a select query automatically restart at timed intervals?
Say your page is being viewed, and you want the info from the db being shown to remain updated without the user refreshing the page. Ideally the query would restart at, theoretically, every 5 minutes, to show any changes in the db info. Can the query/php script be set up to do this, or would you need it like in an iframe that that would refresh with javascript?

Reply With Quote
  #2  
Old December 1st, 2003, 06:47 AM
mugane mugane is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Location: Charlottesville, VA USA
Posts: 425 mugane User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
Send a message via AIM to mugane Send a message via Yahoo to mugane
RE: Auto query at timed intervals?


There are many ways to do this, The simplest being to refresh the page itself using a meta refresh.

If you are trying to have dynamic refreshes without refreshing the entire page, you could use a hidden frame and javascript/dhtml.

The basic problem is that if you want to update page content after it's loaded, you will have to initiate the update on the client side.

Reply With Quote
  #3  
Old December 1st, 2003, 07:04 AM
Seadoo Seadoo is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Posts: 133 Seadoo User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
RE: Auto query at timed intervals?

<meta http-equiv="refresh" content="300; url=http://www.gohere.com">

300 means 300 seconds = 5 minutes.

Reply With Quote
  #4  
Old December 3rd, 2003, 10:04 AM
Danicek Danicek is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Location: Czech Republic
Posts: 79 Danicek User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
Send a message via ICQ to Danicek
RE: Auto query at timed intervals?

Idealy - with hidden windows you could run query in timed intervals and test if there is change in database and only if yes, then refresh page.

Reply With Quote
Reply

Viewing: Codewalkers ForumsOther TechnologiesDatabase Help > Auto query at timed intervals?


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway