update every 10 seconds

phphelpme · #1 (**permalink**) 09-20-11, 06:56 PM

ok well i have this script right here that tells how many members are in the database

PHP Code:


			

//This is on the home page displaying every member in the database , i want it to update every 10 sec
$sql = mysql_query("SELECT id FROM myMembers WHERE email_activated='1' ORDER BY id ASC"); 
$nr = mysql_num_rows($sql);

now how would i make ajax update this without having to refresh the page?

AlexPT · #2 (**permalink**) 09-21-11, 04:01 AM

<html>
<head>
<script src="./js/jquery-latest.js"></script>
<script>
var refreshId = setInterval(function()
{
$('#div').fadeOut("slow").load('response.php').fad eIn("slow");
}, 10000); //10 seconds
</script>
</head>
<body>

<div id="div"></div>
</body>

phphelpme · #3 (**permalink**) 09-22-11, 05:38 PM

where is js/jquery-latest.js at?

xtron · #4 (**permalink**) 09-27-11, 01:58 AM

jQuery is a javascript framework / library. You can download it from their website...