Display new record every 5 seconds

[Jackbob]

Hi to everybody,
i've a page that display one product from a table (db access), i need to change the record displayed every 5 seconds without reboot the page.
I'm thinking at javascript or flash, wich is the quicker and simpler way?
Thank you very much.

[Terrorke]

Javascript or flash can be done.
Another way is to use Ajax for this.

[Jackbob]

Any tutorial or guide for it?

[gabriele]

take a look here (url: http://www.w3schools.com/Ajax/ajax_intro.asp )
and here (url: http://en.wikipedia.org/wiki/List_of...rks#JavaScript )

[Terrorke]

On the web there are several good tutorials on starting with ajax.
Try searchin on theme.
I think I have some good code examples of ajax. But I have to look for them.

[Jackbob]

thanks, i've already done something with ajax + php and ajax + cf , i'm looking for a tutorial if anybody knows, that explain my task.
I just need a box in a page that refresh every 5 seconds taking every times a new record from the db.
Hope somebody can help me.
Bye,
Giacomo

[gabriele]

you will need to do something like

<script type="text/javascript">
var counter = 1;
var timer=setTimeout("LoadNewRecord()",5000);

function LoadNewRecord()
{
 // Use ajax here to call another page which will take as parameter counter
// and will return the appropriate record (as rendered html) from the database
// something like
Ajax.get("dbreader.php?counter=" + counter, callbackfunction_once_ajax_completes);
counter++;
timer=setTimeout("LoadNewRecord()",5000);
}

function callbackfunction_once_ajax_completes()
{
 // get the response from the ajax
// and display it in the html
var contents = <the response from the ajax object>;
var mydiv = document.getElementById("theIDofyourDIV");
mydiv.innerHTML = contents;
}
</script>

a bit primitive .. but it is to get an idea ..