This will get the last entry into a database where COL is equal to something.
SELECT * FROM TABLE WHERE COL=something ORDER BY id DESC LIMIT 0,1
Handles response from an ajax request.
function ajaxRequest()
{
var opt = 's=whatever you want to pass';
var page = 'ajax_page.php';
var http = createRequestObject();
http.onreadystatechange = function()
{
if((http.readyState == 4) && (http.status == 200))
{
var text = http.responseText;
}
}
http.open('POST', page, true);
http.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
http.setRequestHeader("Content-length", opt.length);
http.setRequestHeader("Connection", "close");
http.send(opt);
}
Checks to see if browser is IE based or other.
function createRequestObject(handler)
{
var xmlHttp;
try
{
// Firefox, Opera 8.0+, Safari
var xmlHttp = new XMLHttpRequest();
xmlHttp.onload=handler;
xmlHttp.onerror=handler;
return xmlHttp;
}
catch (e)
{
// Internet Explorer
try
{
xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
return xmlHttp;
}
catch (e)
{
try
{
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
return xmlHttp;
}
catch (e)
{
alert("Your browser does not support AJAX!");
return false;
}
}
}
}
