ex: Last_Name, First_Name, Address, etc

When I select from the list. This is the value that is inserted in the autocomplete while the rest of the form is populated correctly. Here's the code.

2. $(document).ready(function() {
3. $("#zlhbcustlastname").autocomplete({
4. minLength: 3,
5. source: "ajax/clientlist.php", // Pull in names and addresses
6. select: function( e, ui ){ // When we select one
7. var keyvalue = ui.item.value;
8. $("#zlhbclientinfo").html(hTxt0+'Please Enter Clients Last Name'+aTxt1);
9. 
   
10. $.post("ajax/readclient.php",{id:keyvalue},
11. function(data){
12. if (data.Black_List != 0) { $("#zlhbclientinfo").html(aTxt0+'Alert: Client is Black Listed'+aTxt1); }
13. 
    
14. $("#zlhbClientID").val(data.Client_ID);
15. $("#zlhbcustlastname").val(data.Last_Name);
16. $("#zlhbcustfirstname").val(data.First_Name);
17. $("#zlhbcellphone").val(data.Phone);
18. $("#zlhbemail").val(data.Email);
19. $("#zlhbaddr").val(data.Address1);
20. $("#zlhbaddr2").val(data.Address2);
21. $("#zlhbcity").val(data.City);
22. $("#zlhbstate").val(data.Prov_State);
23. $("#zlhbzip").val(data.Postal);
24. $("#zlhbcountry").val(data.Country);
25. 
    
26. var clname = data.First_Name+" "+data.Last_Name;
27. $("#paymentCheckName").text(clname);
28. },"json");
29. $("#zlhbcommentsbut").button( { disabled: false } );
30. $("#zlhbcustcommentStatus").val(1);
31. thgColl(1);
32. }
33. });
34. });
35. clientlist.php
37. <?php
38. $term = trim(strip_tags($_GET['term'])); // Need for the jQuery Autocomplete
39. 
    
40. // Open the database
41. include "main.php";
42. $db = mysql_connect($hostname, $idname, $idpass);
43. if (!$db) die(mysql_errno($db).": ".mysql_error($db)."\n");
44. 
    
45. mysql_select_db("treeser");
46. 
    
47. $sql = "SELECT DISTINCT Last_Name, First_Name, Address1, City, Prov_State, Postal, Client_ID, Phone FROM clients WHERE Last_Name LIKE '".$term."%' ORDER BY Last_Name";
48. 
    
49. $q0 = mysql_query($sql);
50. if (!$q0){error_log($sql,0);}
51. else {
52.     $json = '[';
53.     $first = true;
54.     while ($row = mysql_fetch_assoc($q0)) {
55.         if (!$first) {
56. $json .=  ',';
57. } else {
58. $first = false;
59. }
60. $json .= sprintf('{"value":"%s, %s, %s, %s, %s, %s, %d, %s"}',
61. $row['Last_Name'],$row['First_Name'],$row['Address1'],$row['City'],$row['Prov_State'],$row['Postal'],$row['Client_ID'],$row['Phone']);
62.     }
63.     $json .= ']';
64. }
65. echo $json;
66. ?>
67. readclient.php
69. <?php
70. $c = trim(strip_tags($_POST['id']));
71. $client = explode(',',$c);
72. $cid = $client[6];
73. 
    
74. // Open the database
75. include "main.php";
76. $db = mysql_connect($hostname, $idname, $idpass);
77. if (!$db) die("Could NOT connect\n");
78. mysql_select_db("treeser");
79. 
    
80. $flds = "Client_ID,Last_Name,First_Name,Address1,Address2,City,Postal,Email,Phone,Phone2,Prov_State,Black_List,Country";
81. $sql = sprintf("SELECT %s FROM clients WHERE Client_ID = %d",$flds,$cid);
82. 
    
83. $q0 = mysql_query($sql);
84. if (!$q0){error_log($sql . ', ' . mysql_errno($db).": ".mysql_error($db),0);}
85. else {$row = mysql_fetch_array($q0);}
86. //error_log($row['Last_Name'],0);
87. echo json_encode($row);
88. ?>

The data.Last_Name field becomes the initial prompt from the selection list. The code all works except for the first field where the list is populated from.