Hi,
I'm not even sure where to begin, but hopefully one of the gurus here can point me in the right direction.
I have a form, with many fields, one of which is a dropdown menu. The menu is built via a mysql query:
function the_dropdown() {
$query = "SELECT * FROM TableA ORDER BY Name ASC";
$result = @mysql_query ($query);
echo "<select name=\"dropdown1\">";
while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) {
echo "<option value=\"{$row['Name']}\">{$row['Name']}</option><br />
";
}
echo "</select>";
}
TableA has 3 fields in it: ID, Name, and Picture
What I want to do is this:
When the user selects something from this dropdown, I want another text field ("picture") to update automatically.
So, I know that I can write a query, and then return the value, but how can I get it to "automatically refresh" while keeping all of the values already entered?
