Get MYSQL Data Into AJAX

[RobertC]

I'm an AJAX novice and I'm having major trouble trying to get data out of mySQL and into my javascript function. What I want to do is loop through my data in php and somehow send that data into various named divs on the page.Here's the code from my javascript page:\[code\]function loadPageContent(){var projectID = getQuerystring('pid');var templateID = getQuerystring('t');xmlHttp=GetXmlHttpObject()if (xmlHttp==null){ alert ("Browser does not support HTTP Request") return} var url="getImages.php"url=url+"?projectID="+projectIDurl=url+"&templateID="+templateIDxmlHttp.open("GET",url,true); xmlHttp.onreadystatechange = function() {if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){ document.getElementById("statusdebug1").innerHTML=xmlHttp.responseText; } }xmlHttp.send(null);} \[/code\]Here's the code for my php page:\[code\] <?php $projectID = $_GET["projectID"];$templateID = $_GET["templateID"];include_once('includes/php/conn.php');$sql ="select * FROM imageSel WHERE projectID='$projectID' AND templateName = '$templateID'";$results=mysql_query($sql, $link);if(!($mysql_rs = mysql_query($sql, $link)))die("Error in executing query");echo "<script language='JavaScript'>";while($row =mysql_fetch_assoc($results) ){ $imageSelID = $row['imageSelID'];$templateName = $row['templateName'];$tNode = $row['box'];$image = $row['image'];$sql2 ="select * FROM products WHERE productid='$image'";if(!($mysql_rs = mysql_query($sql2, $link)))die("Error in executing query");//Retrieve values$row2 = mysql_fetch_array($mysql_rs);$productname = $row2['productname'];$subcategoryid = $row2['subcategoryid']; $sql3 ="select * FROM subcategory WHERE subcategoryid='$subcategoryid'"; if(!($mysql_rs = mysql_query($sql3, $link))) die("Error in executing query"); //Retrieve values $row3 = mysql_fetch_array($mysql_rs); $foldername = $row3['foldername']; $foldername = strtolower($foldername);$theImage = '<img src="http://stackoverflow.com/questions/2098927/images/lowres/' . $foldername . '/' . $productname .'" />';echo "document.getElementById(".$tNode.").innerHTML=".$theImage.";";}echo "</script>";?>\[/code\]