[jonnekke]

Hi there,

I got a value on my site (a price) which will increase if someone
place a bet (by submitting a form). I want this price to "be updated"
each 2 sec. But not my entire site, because then the data that is filled in the
form will dissapear each 2 seconds.

Who knows how to fix this?..

_j

[landing]

A touch of javascript may be required. Or place the price display in an iframe and refresh the frame every 2 secs

[jonnekke]

Hi there,

I get this value from my database:

PHP Code:

$check = mysql_query("SELECT * FROM example WHERE checking='yes'") or die(mysql_error()); 

$nrcheck = mysql_num_rows($check);



$begin = "15000";

$huidig = ($nrcheck*250)+$begin; 

This is displayed on my site. Now I want this value to be updated every second.
So it needs to be determined each second and be refreshed on my site..

How to solve this??..

_j

[Nico]

I merged your threads. Please do not cross-post...


And you need AJAX to achieve this. This tutorial is pretty straight-forward.

http://www.tizag.com/ajaxTutorial/

[jonnekke]

thnx nico...

I'll give it a try there... even though I'm not that good in javascript and AJAX..

[jonnekke]

I got it working in my mac browser (safari and FF) but in
IE I got an error that the access is denied on this line:

xmlHttp.open("GET","http://www.mysite.nl/teller.php",true);

I got really no clue where it comes from.. can some help me out here?..

_j


this is the total script:

Code:

<script type="text/javascript">
function Ajax(){
var xmlHttp;
	try{	
		xmlHttp=new XMLHttpRequest();// Firefox, Opera 8.0+, Safari
	}
	catch (e){
		try{
			xmlHttp=new ActiveXObject("Msxml2.XMLHTTP"); // Internet Explorer
		}
		catch (e){
		    try{
				xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
			}
			catch (e){
				alert("No AJAX!?");
				return false;
			}
		}
	}

xmlHttp.onreadystatechange=function(){
	if(xmlHttp.readyState==4){
		document.getElementById('ReloadThis').innerHTML=xmlHttp.responseText;
		setTimeout('Ajax()',1);
	}
}
xmlHttp.open("GET","http://www.mysite.nl/teller.php",true);
xmlHttp.send(null);
}

window.onload=function(){
	setTimeout('Ajax()',1);
}
</script>

[Nico]

Try is this way:

Code:

xmlHttp.open("GET", "/teller.php", true);

EDIT:
And change the seconds in setTimeout(). One second isn't enough. People with slow internet connections will have problems. And besides, the number of seconds needs to be in milliseconds. So 1000 = 1 second.

Code:

setTimeout('Ajax()', 1000);

[jonnekke]

thnx nico..

the error is gone.. but there is no refresh in IE..
there is in firefox en safari..

what needs to be showed is showed but there
is no refresh..