Solved

auto complete using jquery...

Posted on 2013-01-10
2
215 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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

In this article, we'll look how to sort an Array in JavaScript, including the more advanced techniques of sorting a collection of records either ascending or descending on two or more fields. Basic Sorting of Arrays First, let's look at the …
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…
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…

758 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now