Solved

auto complete using jquery...

Posted on 2013-01-10
2
217 Views
Last Modified: 2013-01-10
Hi, I have an autocomplete code as attached. The problem is that it picks up the match anywhere in the string. How can I change the code to pick the match staring from the beginning of the string?

Eg; search 11 needs to pick up 11237 and not 198112. Thank you for the help.

A
<script type="text/javascript">
$().ready(function() {
	
	$("#account").autocomplete("account.php", {
		width: 260,
		matchContains: true,
		mustMatch: true,
		selectFirst: true
	});
	
	$("#account").result(function(event, data, formatted) {
		$("#account").val(data[1]);
	});
});
</script>

Open in new window

0
Comment
Question by:aej1973
2 Comments
 
LVL 82

Accepted Solution

by:
leakim971 earned 200 total points
ID: 38764522
you have nothing to do with Javascript. you must work on your script "account.php"

in your SQL query, instead : '%$q%'
use : '$q%'
0
 

Author Comment

by:aej1973
ID: 38764612
yes, that worked. Thank you very much.

A
0

Featured Post

ScreenConnect 6.0 Free Trial

At ScreenConnect, partner feedback doesn't fall on deaf ears. We collected partner suggestions off of their virtual wish list and transformed them into one game-changing release: ScreenConnect 6.0. Explore all of the extras and enhancements for yourself!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Jquery GMAP3 Hierarchy 1 28
Select case on click 3 16
Jquery 2 13
Hide Table in merge 3 10
I've been trying to accomplish this for a while and it just struck me yesterday how to accomplish this task. I have done searches all over the internet looking for ways to email pages from my applications and finally I have done it!!! Every single s…
In Part 1 (http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/A_7849-Hex-Maze.html) we covered the hexagonal maze basics -- how the cells are represented in a JavaScript array and how the maze is displayed.  In this part, we'…
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question