javascript - jquery auto complete not working -
i have jquery/js code:
<script type="text/javascript"> $(function() { var availabletags = ["voip extension rental","voip extension rental","voip extension rental (leasing handsets)","voip extension rental","voip extension rental","voip extension rental","voip ivr rental","voip extension rental. handsets being leased 3 years.","multiple voip call diverts","voip extension rental","voip extension rental","voip extension rental","voip extension rental","voip extension rental","voip extension rental","voip extension rental","voip extension rental","voip extension rental","pstn phone line","pstn\/analogue phone line","pstn\/analogue phone line","pstn\/analogue phone line","pstn\/analogue phone line","pstn\/analogue phone line","integra fibre unlimited","integra fibre","fibre unlimited broadband","adsl 2+ broadband","integra fibre pro - 100gb download usage","isdn30 channels","isdn calling line identity","40 ddi numbers","pstn\/analogue phone line (01702 330012)","voip extension rental","voip extension rental","voip extension rental","voip extension rental","voip extension rental","voip extension rental","voip extension rental","voip extension rental","monthly pc maintenance","monthly pc maintenance (over phone support only)","monthly pc maintenance","monthly pc maintenance","monthly pc maintenance","monthly pc maintenance","hosted exchange email accounts","hosted exchange email accounts","hosted exchange email accounts","hosted exchange email accounts","hosted exchange email accounts","hosted exchange email accounts","hosted exchange email accounts (nextlevelofmobileadventure.co.uk)","monthly pc maintenance","hosted exchange email accounts","hosted exchange email accounts","voip extension rental","voip extension rental","hosted exchange email accounts","voip fax extension","integra unlimited fibre connection","integra 50 plan (line & broadband) 36 month contract","pstn line rental","integra business bronze","hosted exchange mailboxes","voip extension rental","pstn\/analogue phone line","monthly pc maintenance","integra bundle (line \/ broadband \/ voip)","level 4 bt response","pstn phone line","level 4 bt response","integra fibre unlimited",null,"bt 1571 service","voip extension rental","voip extension rental","phone line rental (for fibre)","integra fibre pro","bespoke crm database","integra starter web hosting","integra starter web hosting","integra starter web hosting","integra starter web hosting","integra starter web hosting","professional web hosting","integra starter web hosting","integra starter web hosting","integra starter web hosting","integra starter web hosting","hosted exchange email accounts","hosted exchange mailboxes","voip extension rental","tool room pstn line","voip extension rental","voip extension rental","voip extension rental","hosted exchange email accounts (tolmers.org.uk)","pstn \/ analogue line rental","pstn \/ analogue line rental","integra fibre unlimited","integra fibre unlimited","integra fibre unlimited","pstn phone line","level 4 bt response","integra professional web hosting","hosted exchange emails accounts","voip extension rental","voip extension rental","hosted exchange email accounts","pstn phone line","integra fibre unlimited","voip extension rental","integra fibre pro","hosted exchange mailboxes","hosted exchange mailboxes","hosted exchange mailboxes","integra fibre pro","business silver broadband","callback extension","voip extension rental","no direct debit setup - monthly charge","voip extension rental","offsite backup - 50p per gb","voip extension rental","business platinum","pstn\/analogue phone line","voip extension rental","outmail 2000","voip extension rental","voip extension rental","pstn line rental","voip extension rental","voip extension rental"] //autocomplete $(".auto").autocomplete({ source: availabletags }); }); </script> but not showing list on auto complete text input, if change above be:
var availabletags = ["voip", "voip2", "voip2"] it works fine , shows 3 options
php code generate list:
<?php $return_arr = array(); $sql="select * customer_billing "; $rs=mysql_query($sql,$conn) or die(mysql_error()); while($result=mysql_fetch_array($rs)) { $return_arr[] = $result["productname"]; } ?>
they worked if remove null in array
update
if don't want null value in query result, have set (your row product name) not null.
it becomes empty '' string.
Comments
Post a Comment