MySQL AJAX insert and refresh

[markxtra]

Hi All

I hope you can help.

I've got a <select> code that pulls the options from a MySQL database. If an option that is needed isn't there, I would like to create a script that adds the option to the database and then refreshes the select box to include the new option without refreshing the page.

Is this possible?
Is this where AJAX would come in?

I have a very good understanding on PHP and MySQL. A basic knowledge of Javascript and no idea about AJAX.

Any help would be much appreciated.

Mark

[ssystems]

This will help.

function getXmlHttpRequestObject() {
	if (window.XMLHttpRequest) {
		return new XMLHttpRequest(); //Mozilla, Safari ...
	} else if (window.ActiveXObject) {
		return new ActiveXObject("Microsoft.XMLHTTP"); //IE
	} else {
		alert("Your browser doesn't support the XmlHttpRequest object.");
	}
}

function makeRequest(url, param) {
	if (receiveReq.readyState == 4 || receiveReq.readyState == 0) {
		receiveReq.open("GET", url, true);
		receiveReq.onreadystatechange = updatePage; 
		<your headers>
                receiveReq.send(param);
	}   
}

function updatePage() {
	if (receiveReq.readyState == 4) {<do the updating>;
	}
}

function getSelect() {
	var url = '<your url>';
	var postStr = '<your postStr if there is one>';
	makeRequest(url, postStr);
}

var receiveReq = getXmlHttpRequestObject();