Javascript-Quelltext

$( "#article" ).autocomplete({
            minLength: 1,
            source:"inc/ajaxload/article.php",
            select: function( event, ui ) {
                $( "#article" ).val( ui.item.article );
                $( "#unit" ).val( ui.item.unit);
                $( "#unit_price" ).val( ui.item.price);

                return false;
            }
        })

PHP-Quelltext

<?php
    include ('../mysql.php');
     
     
        $param = mysql_real_escape_string($_GET['term']);
     
        //query the database  
        $query = mysql_query("SELECT sh.unit as unit, g.name as article, sh.unit_price as price 
FROM goods g INNER JOIN shopping sh ON(sh.goods_id = g.id) WHERE g.name LIKE '$param%'");  
     
        //build array of results  
        while($row = mysql_fetch_assoc($query)){
            $friends[] = array(     "label" => $row["article"].' Menge: '.$row["unit"].' Preis:'.$row["price"],
                                    "article" => $row["article"],
                                    "unit" => $row["unit"],
                                    "price" => $row["price"]
                );  
        }
       
     
        //echo JSON to page  
        echo json_encode($friends);
     
    ?>