[the_metro_man]

i am mixing javascript and php to graph sales dynamically from a mysql database - unfortunately i can only plot 1st sales value - i basically need javascript to call a php function that queries the database and returns the next sales value - here is a snippet from the php file

$x=0;
echo "
function loop() {
	ctx.clearRect(0, 0, canvas.width, canvas.height);";

$qt=mysql_query("select sales from gd_graph");
$y = mysql_result($qt, $x); 
$x+=1;

echo "
		yy_prev=yy;
		yy=" . $y .";\n";

echo "
		for(var i = 0; i < NUM_PARTICLES; i++) {
		particles[i].update();

		ctx.moveTo(particles[i].x, yy);
		ctx.lineTo(particles[i].x - particles[i].xvel, yy_prev);
		ctx.stroke();
		ctx.closePath();
	}
	setTimeout(loop, 1000);
}

any ideas much appreciated

cheers

Abbey

** Edit **

[przemass]

You should read about Ajax.

[forest51690]

Javascript and PHP can't communicate directly. It's not like you can call a specific function from a PHP file from JS. But there's a way you can communicate. JS can load a php file using AJAX. And the php page can be dynamic with GET or even POST variables. So the php file should compute the output and then output data for the Javascript. The data outputted should be in XML.