CodingForums.com - Possible function problem, data not entering.

Hello.

I'm really really stuck on this and can't see where I'm going wrong. The idea is you click the button 'save search' and it enters two bits of information.. 'memberid' and 'location' into the database, via AJAX and displays a 'saved!' message after it's clicked.

I've debugged it as much as i know how.. echoing the $location and $memberid[0] which both show up correctly, and also testing the php address with the values just typed in, and it enters into the database correctly (ie http://mywebsite.com/savesearch_save...camden&mem=165 directly into the browser address).

Can anyone see what I've missed? At the moment you just click the button and nothing happens.

Cheers
Pat.

HTML

Code:

<div id="saveSearch"><button onclick="ajaxSaveSearch(true,<?php echo $location;?>,<?php echo $memberid[0];?>)">save search</button></div>

JAVASCRIPT

Code:

function ajaxSaveSearch(doSave, location, memberid) {

    var ajaxRequest; // The variable that makes Ajax possible!

    try {

        // Opera 8.0+, Firefox, Safari

        ajaxRequest = new XMLHttpRequest();

    } catch (e) {

        // Internet Explorer Browsers

        try {

            ajaxRequest = new ActiveXObject("Msxml2.XMLHTTP");

        } catch (e) {

            try {

                ajaxRequest = new ActiveXObject("Microsoft.XMLHTTP");

            } catch (e) {

                // Something went wrong

                alert("Your browser broke!");

                return false;

            }

        }

    }

    // Create a function that will receive data sent from the server

    ajaxRequest.onreadystatechange = function () {

        var div = document.getElementById("saveSearch");

        if (ajaxRequest.readyState == 4) {

            div.innerHTML = ajaxRequest.responseText;

        } else {

            div.innerHTML = "<img src='Images/icons/loading.gif' />";

        }

    }

    var queryString = "?location=" + location + "&mem=" + memberid;

    var url = doSave ? "savesearch_save.php" : "savesearch_forget.php";

    ajaxRequest.open("GET", url + queryString, true);

    ajaxRequest.send(null);

}

savesearch_save.php

PHP Code:


		
			
include("connect.php");

$location = $_GET['location'];
$themember = $_GET['mem'];

$sql = "INSERT IGNORE INTO savedsearch (memberid, location) VALUES ('$themember','$location')";
if (!mysql_query($sql, $con)) {
    die('Error: '.mysql_error());
}
echo "saved!";