Change text box values with the dropdown selection

[dskanth]

Hello, i have a dropdown in the Accounts module. When i change the dropdown selection, the textbox values at the bottom must be populated with the corresponding values. For example, if i change the City in the dropdown, the address textbox at the bottom must be filled in with the detail from the database.
Please suggest me, where to make changes (in which file). Your help will be much appreciated.
Thanks.

[crmsiva]

Hi

Check this. This thread is a very basic example. You need to use AJAX to fetch data from DB.

[dskanth]

i have checked that, but i could not know how to establish connection to the database ?
Iam getting a fatal error on writing the database connection.

This is my custom code :

$query="select * from a234_clinics where id='$id'";
$res = $db->query($query);
while ($row = $db->fetchByAssoc($res))
$row=$db->fetchByAssoc($res);

Fatal error: Call to a member function query() on a non-object in /opt/lampp/htdocs/sugar51/modules/Contacts/.................... on line 298

Please can you suggest how to write the database connection, and how to read the values using Ajax ?
Thanks

[crmsiva]

you need to use the below in the code

global $db;