How to update comment count?

[itsallkizza]

Thanks but nothing gets displayed, blank page.

- What's a blank page? get_count.php? I can't help you with that one because I don't have access to your database - so I'd have no idea what you're doing wrong.

If your comments id is inserted via PHP on load, then do so, I don't see the problem:

function updateCounter()
	{
	var my_xmlhttputil = new XML_HTTP_Util();
	var handleCount = function(response)
		{
		document.getElementById("count").innerHTML = "Comment added ("+response.responseText+")";
		}
	my_xmlhttputil.sendRequest("get_count.php?id=<?php echo($_GET['id']) ?>",true,handleCount);
	}

[student101]

I didn't know that you could add the PHP values directly into the jscript like that, pretty cool.

Edit: It works once I add in the PHP

Only thing; In IE7 it shows once in FireFox it shows all the time after a page refresh/reload.
Any ideas there?

Edit: FIXED!!! Changed GET to POST

The code from the get_count.php is this;

PHP Code:

<?php
$sql = "SELECT COUNT(*) AS count FROM comments WHERE id = '$_GET[id]'";
$result = mysql_query($sql);
if($result){
  $row = mysql_fetch_row($result);
  $count = $row[0];
  echo $count;
} else{
  echo "Err";
}
?>

Edit:
This is so unbelievable THANK YOU!!!
WOW how cool is this!

[itsallkizza]

Glad I could help