javascript - AJAX query with php and mysql -

$(document).ready(function(){     $('input.phonebook_user').phonebook_user({         name: 'phonebook_user',         remote:'search.php?type=phonebook&key=%query%',         limit : 10     }); }); 

and

<form method="post"> <table border="0"> <tr> <td><input type="text" name="phonebook_name" placeholder="phonebook name" required /></td> </tr> <tr> <td><input type="text" name="phonebook_user" class="typeahead tt-query" autocomplete="off" spellcheck="false" placeholder="type username manage phonebook"></td> </tr> <tr> <td><button type="submit" name="com_btn-phbook-create">create phonebook</button></td> </tr> </table> </form> 

and

$type=$_get['type']; // user or company if($type=="user") {     $key=$_get['key'];     $array = array();     $query=mysql_query("select * `users` `email` '%{$key}%'");     while($row=mysql_fetch_assoc($query))         {             $array[] = $row['email'];         }     echo json_encode($array); } else if($type=="company") {     $key=$_get['key'];     $array = array();     $query=mysql_query("select * `company` `company` '%{$key}%'");     while($row=mysql_fetch_assoc($query))         {             $array[] = $row['name'];         }     echo json_encode($array); } else if($type=="phonebook") {     $key=$_get['key'];     $array = array();     $query=mysql_query("select * `users` `username` '%{$key}%'");     while($row=mysql_fetch_assoc($query))         {             $array[] = $row['user_id'];         }     echo json_encode($array); } 

i'm trying pull e-mail of user name getting typed , box not seem show drop down list of user names select when start type in user name. curious going wrong code.

my goal user types in user name, drop down list shows possible matches , when select name, pulls e-mail submitted query.

i had working when using ?key=%query% in javascript.

am doing if , else statements wrong?

thought problem due %. sending search string enclosed in %

remote:'search.php?type=phonebook&key=%query%', 

and enclosed in % in query

select * `users` `email` '%{$key}%' 

also check cases of variables in url 'type' , in php code $_get['type'] $key , $key