1000000000000000000000 thanks for this brity and great text box, i am looking for this box in about week anf finaly find may need.
It's gread and helpfully....
Great tool, but I'm only ever able to show one option from my array in my list. I have an array containing over 20k items, pulled from a db and know that there should be more than one sometimes.
My solution probably won't help you, but might point in the right direction.
I use PHP/MySQL/Smarty (templating system). I do my query and build an array (in my case, 22000 publisher names), and then pass the array to the template. All javascript in the template must be 'controlled' so that the template engine does not try and interpret it, but just let it through. This is done by adding {literal} before and {/literal} after the js code. by placing '{/literal}{$pub_array}{literal}' into the array part of the js code, I can populate the array with my MySQL output.
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:
<?php
///// THIS IS YOUR DATA BASE CONNECTION/////////////////////////////////////
function db_connect()
{
$db = mysql_connect("localhost","YOUR USER","YOUR PASSWORD");
if (!$db)
{
echo "Error ";
exit;
}
mysql_select_db("YOUR DATABASE");
}
db_connect();
//////////////////////////////////////////////////////////////////////////////////////////////
//////////THIS LINE POPULATE YOUR ARRAY FROM A MYSQL QUERY///////////////////
$result = mysql_query("SELECT your_column FROM your_table ORDER BY your_column");
if (mysql_num_rows($result))
{
while ($row = mysql_fetch_assoc($result))
{
$customarray[] = $row[your_column];
}
}
hi i m reteriving data from sql server
e.g
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
Hi does any body know how to change the font color from black to white when moving over the list....I have customized the code and applied the hcolor to purple so now the characters in side cannot be seen...so when i move over the options the color of the character should change to white for visibility...if any one has idea plz reply ....its very very urgent....
You helped me my job........ i am trying this code from past 4 days. i thought to try in google once. unexpectedly i saw your code and i have tried it's working excellent....
i request you one more thing is i want the same futhure's of the another textbox which present in the same page.... can you suggest me...
Hi,
suppose there is elephant in custom aray and user types elepha then why do after pressing enter elephant get selected .
Rather if user press up and down arrow then it should get selected.
Any help on this will be helpful.