ajax php mysql

[itgetsharder]

Hi, im pretty new to this. basically, i have two database tables in mysql, one called items(id of the book, cookieid, quantity) and the other books(id, name, desc, price). my php returns xml(name, price, quantity and total amount). my code returns the name and price but i can't get it to return the quantity or total.

 

can anyone see any errors in my code? i think the problem is with the quantity which is the variable newCell2. I keep getting the error "object expected" with that part in IE. 

 

if (request.readyState==4) {
    		if(request.status==200) {

		var response =request.responseXML;
for(var i=0; i<=response.getElementsByTagName('store').length; i++)
{
var newRow = document.getElementById('table').insertRow(-1); // Insert the third row
                    var newCell1 = newRow.insertCell(0); // Insert the first cell
                    newCell1.innerHTML = response.getElementsByTagName('book')[i].childNodes[1].childNodes[0].nodeValue; // First cell's innerHTML
                    var newCell3 = newRow.insertCell(2); // Insert the second cell
                    newCell3.innerHTML = response.getElementsByTagName('book')[i].childNodes[3].childNodes[0].nodeValue;
                    var newCell2 = newRow.insertCell(1); // Insert the second cell
                    newCell2.innerHTML = response.getElementsByTagName('book')[i].childNodes[4].childNodes[0].nodeValue; // Second cell's innerHTML
                    var newCell4 = newRow.insertCell(3); // Insert the second cell
                    newCell4.innerHTML = response.getElementsByTagName('book')[i].childNodes[5].childNodes[0].nodeValue;
}

 

thanks in advance.

[ohdang888]

you only closed 1 bracket. you needa close another 2 at the end