JohnMcCain2008
New Member
Hello I am using autocomplete to allow users to search venues stored in a MySQL database. The autocomplete plugin is currently listing the venues when the user begins typing and prints the selected venue using the result handler.I would like to also print the address, phone number and website of the venue as well but I am not sure how to do this.I have the autocomplete plugin running a php script to print out the venue names from the database. I am not sure how to retrieve the other fields in the database without displaying the autocomplete input field...This is what I have so far:JQuery\[code\] $(document).ready(function(){ $("#example").autocomplete("search.php", {width: 260, selectFirst: false}).result(function(event, data, formatted) { $("#result").html( !data ? "No match!" : "Selected: " + formatted); });});\[/code\]PHP\[code\]$search = $_GET['q']; $search = "%".$search."%"; $result = mysql_query("SELECT club_name FROM clubs WHERE club_name LIKE '$search'") or die('Something is wrong'); while($value = http://stackoverflow.com/questions/2054403/mysql_fetch_array($result)){ $club = $value[club_name]; echo"$club\n"; }\[/code\]The php above only select the club name because when I try to select more fields they display in the search results on the JQuery side.I am new to JQuery so I am a little lost... Any suggestions?