Ajax refresh code every 5 seconds

[Freid001]

Ok so I have a PHP code below. How can I use Ajax to refresh this code every 5 seconds with out a page refresh?

Any help would be great!

 

Thanks 

--------------------------------------------------------------------------------------------

 

<?php

 

$host= XXXX

$mysql_user =  XXXX

$mysql_password =  XXXX

$mysql_database =  XXXX

;$username = $test;

 

$connection =  XXXX

 

$query = mysql_query("SELECT * FROM Game WHERE user='$username'");

$numrows = mysql_num_rows($query);

while ($row = mysql_fetch_assoc($query))

{

$Comment = $row['Comment'];

}

 

echo "$Comment";

 

?>

 

 

 

[Adam]

You can use the setInterval() method to periodically call your AJAX function. What have you tried so far?