executing some PHP code within a javascript function

toubia

Hi,
I'm using a javascript function to refresh a page automatically (I'm using javascript to allow the refreshed page to scroll down to the previous position automatically instead of going back to the top each time).
However I'd like this refreshing to happen only if something has been written to a mySQL database. I thought that one way to do it might be to include some php code into the javascript function that would check the number of entries in the data base, but I don't know how to execute some php code from a javascript function.
Any help on this or on the initial problem (refresh only if something new in the db) would be very appreciated. Thanks

shawon22

try this code:

<?
if($db_ok)
{
?>
<html>
<body onload=doLoad();>
<?
}
?>

function doLoad()
{
//refresh value every 2 second
setTimeout( "refresh()", 2*1000 );
}

function refresh()
{

var sURL = unescape(window.location.pathname);

window.document.write(i++)
window.location.href = sURL;

}

</script>

toubia

Thank you very much for your help.
However, if when the page is loaded the first time, nothing has been added to the db, then it seems that the doLoad function would never be called and the page would never refresh itself, even if something is later added to the db.
What I'd like to be able to do is check every 2 seconds whether something has been added to the db.

Thanks.