javascript and php

[vinny69]

i have a problem getting my Javascript function to call when my php comments timestamp is the same as NOW() time...

the page with this code is called onto another page via AJAX and refreshes every second

here is the Code:

$sql="SELECT * FROM users WHERE username='".$_GET['q']."'";

$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
 {
 $sql2="SELECT * FROM comments WHERE user='".$row['accessid']."'";

$result2 = mysql_query($sql2);
while($row2 = mysql_fetch_array($result2))
 {
 if($row2['timestamp'] == DATE('F j, Y H:i:s')) {
 echo "<script>window.onload = function() { sendRequest('userRequest', '".$row2['sent_by']." sent you a message.'); }</script>";
 }
 echo $row2['comment']."<hr>".$row2['timestamp']."<br><br>";
 }
}
?>

i want this code to display a message box when someone leaves a comment.
i set a comment in the future, so when the current time hits the same as the comment timestamp it should call the function but it doesn't...
can someone please help me.

thanks in advance.

[scrupul0us]

well... id say youd need a timer to monitor the curernt time vs triggers it needs to handle...

to simply load some page code that says "do this in an hour" and just have the page sit there idling isnt going to work as javascript doesnt just sit there and wait unless you either have the page refresh or a timer running in the BG

[vinny69]

i have an AJAX script that pulls the coding on the page into a div box every second

heres the code

<script type="text/javascript">

var xmlHttp2;

function showComments(str)
{ 
xmlHttp2=GetXmlHttp2Object();
if (xmlHttp2==null)
  {
sendRequest('ErrorMessage', 'Javascript Error.<br>Your browser does not support AJAX!');
  return;
  } 
var url="loadComments.php";
url=url+"?q="+str;
url=url+"&sid="+Math.random();
xmlHttp2.onreadystatechange=stateChanged2;
xmlHttp2.open("GET",url,true);
xmlHttp2.send(null);
}
function stateChanged2() 
{ 
if (xmlHttp2.readyState==4)
{ 
document.getElementById("comments").innerHTML=xmlHttp2.responseText;
}
}
function GetXmlHttp2Object()
{
var xmlHttp2=null;
try
  {
  // Firefox, Opera 8.0+, Safari
  xmlHttp2=new XMLHttpRequest();
  }
catch (e)
  {
  // Internet Explorer
  try
    {
    xmlHttp2=new ActiveXObject("Msxml2.XMLHTTP");
    }
  catch (e)
    {
    xmlHttp2=new ActiveXObject("Microsoft.XMLHTTP");
    }
  }
setTimeout('showComments(\"<?php echo $username; ?>\")', 1000);
return xmlHttp2;
}
</script>

<span id="comments">


</span>

[scrupul0us]

at this point you are much better off seeking assistance in the Javascript section as you are only calling/rendering JS with PHP

[vinny69]

okay, thankyou