this script works great with a few small changes . . however . . when the external scripts are included . . a specific validation event returns false when it should be true. When a user clicks the addtocart asp:image of an asp:linkbutton . . it fires validation to ensure that the txtQuantity field is numeric . . with the autosuggest script files included . . this validation is returning false when it is clearly a number and should be fine. Does anyone have any clue as to why this might be happening? the asp:image, linkbutton, and textbox have nothing to do with the search textbox with autosuggest.
My solution probably won't help you, but might point in the right direction.
The problem that I have is that I can only see one autocomplete option being offered when I know there are more that one in my test sample.
I Figured Out :
this is the Code you need to Replace :
REPLACE THIS LINE in (autocomplete.htm) file:
var customarray=new Array('an apple','alligator','elephant','pear','kingbird','kingbolt', 'kingcraft','kingcup','kingdom','kingfisher','kingpin');
WITH THIS PHP CODE:
///// THIS IS YOUR DATA BASE CONNECTION/////////////////////////////////////
$db = mysql_connect("localhost","YOUR USER","YOUR PASSWORD");
echo "Error ";
//////////THIS LINE POPULATE YOUR ARRAY FROM A MYSQL QUERY///////////////////
$result = mysql_query("SELECT your_column FROM your_table ORDER BY your_column");
while ($row = mysql_fetch_assoc($result))
$customarray = $row[your_column];
hi i m reteriving data from sql server
i have fetched brand name and brand code from sql server table. i have created array of brandname now when user select any brand in the list then brand code should comes into next textbox automatically