Display two fields from database table to populate jquery autocomplete

Question

I have implemented a jquery ui autocomplete with data from database. Right now what I have done is only to display one field. Let's say for example I have a database:

| id | suburb | code
  0     DAR      10
  1     ASD      20
  2     DEF      30
and so on....

my html code:

<form id="auto_test">
<label for="tags">Tags: </label>
<input id="tags" type="text" name="tags" />
<input type="button" id="auto_test_btn" value="save" />

jquery:

jQuery("#tags").autocomplete({
        source: "<?php echo WP_PLUGIN_URL.'/plugin_name/php_file.php'?>"
    });

php :

$t = $_GET['term']; 
$code = $wpdb->get_results(
        "SELECT suburb as label, suburb as value
        FROM Sheet1
        WHERE suburb like '%$t%'
        LIMIT 25
        ",ARRAY_A
        );  
echo(json_encode($code));

The autocomplete displays only the 'suburb' for it is defined as label. What I wanted to do is to display both the suburb and the code.

What would be the nice thing to do?

nnnnnn · Accepted Answer · 2012-05-18 05:40:32Z

2

You can concatenate the columns (with an appropriate separator) within your SQL select statement, perhaps something like this:

"SELECT Concat(suburb, ' ', code) as label, suburb as value

answered May 18, 2012 at 5:40

nnnnnn

150k30 gold badges210 silver badges247 bronze badges

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

Comments

Sergey · Accepted Answer · 2012-05-18 05:40:37Z

2

"SELECT concat(suburb, ' ', code) as label, suburb as value

answered May 18, 2012 at 5:40

Sergey

5,20727 silver badges37 bronze badges

Comments

Wazan · Accepted Answer · 2012-05-18 05:42:16Z

0

try this your sql query..

SELECT suburb as label, code as value
            FROM Sheet1
            WHERE suburb like '%$t%'
            LIMIT 25

answered May 18, 2012 at 5:42

Wazan

5391 gold badge9 silver badges27 bronze badges

Collectives™ on Stack Overflow

Display two fields from database table to populate jquery autocomplete

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related