jQuery $.ajax request of dataType json will not retrieve data from PHP script -

i've been looking on solution cannot find works. trying bunch of data database , via ajax autocomplete input fields in form. i've decided use json, because why not, right? alternatively i've been thinking send delimited string , tokenise it, in hind-sight would've been easier , spared me headache... since i've decided use json though, guess should stick , find out went wrong! happens when get_member_function() executed, error pops in alert dialogue , reads "[object object]". i've tried using request, , setting contenttype ”application/json; charset=utf-8″. alas, no dice. can please suggest doing wrong? take care, piotr.

my javascript/jquery function follows:

function get_member_info()    {     var url = "contents/php_scripts/admin_scripts.php";     var id = $( "select[ name = member ] option:selected" ).val();     $.ajax(    {        type: "post",       datatype: "json",       url: url,       data: { get_member: id },       success: function( response )        {             $( "input[ name = type ]:eq( " + response.type + " )" ).attr( "checked", "checked" );           $( "input[ name = name ]" ).val( response.name );           $( "input[ name = fname ]" ).val( response.fname );           $( "input[ name = lname ]" ).val( response.lname );           $( "input[ name = email ]" ).val( response.email );           $( "input[ name = phone ]" ).val( response.phone );           $( "input[ name = website ]" ).val( response.website );           $( "#admin_member_img" ).attr( "src", "images/member_images/" + response.image );        },       error: function( error )       {           alert( error );        }     } );  } 

and relevant code in "contents/php_scripts/admin_scripts.php" follows:

   if( isset( $_post[ "get_member" ] ) )    {        $member_id = $_post[ "get_member" ];       $query = "select * members id = '$member_id'";        $result = mysql_query( $query );        $row = mysql_fetch_array( $result );        $type = $row[ "type" ];       $name = $row[ "name" ];       $fname = $row[ "fname" ];       $lname = $row[ "lname" ];       $email = $row[ "email" ];       $phone = $row[ "phone" ];       $website = $row[ "website" ];       $image = $row[ "image" ];        $json_arr = array( "type" => $type, "name" => $name, "fname" => $fname, "lname" => $lname, "email" => $email, "phone" => $phone, "website" => $website, "image" => $image );        echo json_encode( $json_arr );     } 

i think know one...

try sending json json using php's header() function:

/**  * send json  */ header("content-type: application/json", true); 

though passing valid json, jquery's $.ajax doesn't think because it's missing header.

jquery used fine without header, changed few versions back.

also

be sure script returning valid json. use firebug or google chrome's developer tools check request's response in console.

update

you want update code sanitize $_post avoid sql injection attacks. provide error catching.

if (isset($_post['get_member'])) {      $member_id = mysql_real_escape_string ($_post["get_member"]);      $query = "select * `members` `id` = '" . $member_id . "';";      if ($result = mysql_query( $query )) {         $row = mysql_fetch_array($result);         $type = $row['type'];        $name = $row['name'];        $fname = $row['fname'];        $lname = $row['lname'];        $email = $row['email'];        $phone = $row['phone'];        $website = $row['website'];        $image = $row['image'];         /* json row */        $json = array( "type" => $type, "name" => $name, "fname" => $fname, "lname" => $lname, "email" => $email, "phone" => $phone, "website" => $website, "image" => $image );      } else {          /* query failed, use mysql_error report why */         $json = array('error' => 'mysql query error');      }       /* send json */      header("content-type: application/json", true);      /* return json */     echo json_encode($json);      /* stop execution */     exit;  }