jQuery autocomplete error with JSON data

Question

I'm getting a JSON array from server :

mysql_select_db('******') or die("Error connecting to db.");
$res = mysql_query("SELECT DISTINCT(valeur) as val FROM *****") or die(mysql_error());
while($r = mysql_fetch_assoc($res)){
    $tab[] = $r['val'];
} echo json_encode($tab);
unset($tab);

And :

$.getJSON("autocomp.php?id=valeur", function(data){
    $("#other-valeur").autocomplete({delay: 100, source: data, dataType: 'json'});
});

The server returns me a correct json array :

["UMTS","RAN","Swap","Regions","Brasseur",...]

But when i start typing something in the input, i get this message in firebug:

c is null

In the jquery code...

What i dont understand is that i'm doing the exact same thing for another input on the same page, and it work perfectly, the json array look the same, the code is the same...

Could you provide more information? ie. What plugin are you using for autocomplete? What's c? — changelog
– changelog, Commented Apr 22, 2011 at 9:01
I'm using jquery ui autocomplete, i don't knows what c is, it's a jquery core variable. — Guillaume
– Guillaume, Commented Apr 22, 2011 at 9:17

h.ralitera · Accepted Answer · 2011-12-02 00:00:37Z

1

It will not work because autocomplete need the property "id" and "value" in your json. this is not the case here.

Try to return the json like that :

[{"id":"1","value":"UMTS","comment":"umts comment"},
{"id":"2","value":"RAN","comment":"ran comment"},
{"id":"3","value":"Swap","comment":"swap comment"}]

in your php, also return a content type of : application/json

answered Dec 2, 2011 at 0:00

h.ralitera

314 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

jQuery autocomplete error with JSON data

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related