Nameless,
I see someone mentioned the setTimeout(function, milliseconds) function for JavaScript. I would also like to point out that you can use setInterval(function, milliseconds) in order to have an event repeat at a set interval. For instance, let's say you had a page laid out like so:
---
<div id="blah">
Text here
</div>
---
You would want to add a script somewhere that would begin the interval in order to update the div:
---
<script type="text/javascript">
function ajaxRequest()
{
// <insert postback code here>
document.getElementById("blah").innerHTML = ajax.responseText;
}
var t = setInterval("ajaxRequest()", 5000);
</script>
---
This assumes that your XmlHttpRequest object is named "ajax". Assigning the interval to variable "t" ensures that you can clear the interval if you need to (via "clearInterval(t);").
I suppose "innerText" can be used instead of "innerHTML", as well. I would recommend using innerHTML only if you will be populating the div with HTML code, however.
Hope this helps,
Todd Boyd
Web Programmer
> -----Original Message-----
> From: admin@xxxxxxxxxxxxxxxxxxx [mailto:admin@xxxxxxxxxxxxxxxxxxx]
> Sent: Tuesday, May 20, 2008 3:25 PM
> To: php-general@xxxxxxxxxxxxx
> Subject: php mysql live feed
>
> Okay before i pull more hair out...
>
> I am trying to use php to pull mysql data and refresh the mysql data
> every say 5 seconds for like a live display of the database without the
> screen reloading.
>
> I want the data to refresh but not the screen. Ajax seems to hate me
> because everything i have seen/read/tried is wrapped around ASP.NET or
> requires a user interaction to invoke the query.
>
> If you have example scripts or a good tutorial that actually works
> where you can open a php script and the data changes on the page as the
> database does and the screen does not refresh, and you don’t have to
> onclick, onfocus, or onblur kind of thing. I would be in your debt
>
> Frustrated Rick
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
