COmbobox and textbox fill

Clee2004

Hi all,

Ive got a problem with a combobox and a textbox.

What have to happen is when i click on a item in the combobox the textbox must be filled with stuff out of the database.

Here is the code

This is the function

<?
function select_item_price()
{
	$qy = "SELECT debiteur,deb_naam FROM uren_deb";
	$rs = mysql_query($qy) or die (mysql_error ());

while ($r= mysql_fetch_array ($rs,MYSQL_NUM))
 {
 $select .= "<option value='{$r[0]}'>{$r[0]}</option\n>";
 $prices[] = $r{1};
 }


return array ($select, $prices);

}
?>

And the other page

include("selectitem.php");
?>
<HTML>
	<HEAD>
		<? list ($select, $prices) = select_item_price (); ?>
		<script>
		function showPrice() 
		{
			array prices(<? echo $prices; ?>);
			var i = document.form.item.selectedIndex;
			document.form.price = prices[i];
		}
		</script>	
	</HEAD>
	<BODY>



	<form name= "form">
		<select name="item" onUpdate="showPrice()">
			<? echo $select; ?>
		</select>
		<input type="text" name="price" value= "">
	</form>	
</BODY>
</HTML>

The combobox is filled with stuff, but when i click on a item it wil not fill the textbox.

I don't know what is wrong,

Thanks Clee2004

gotissues68

try

while ($r= mysql_fetch_array ($rs,MYSQL_NUM)): 
$select .= "<option value='{$r[0]}'>{$r[0]}</option\n>";
$prices[] = $r{1}; 
endwhile;

Clee2004

The while statement works, but it still won't fill the textbox

Is it something with value = "" ????

Clee2004

gotissues68

No value = "" shouldn't matter, but if you're going to fill in the box with something you have to tell it what to fill it with, sorry if I mis-understood your question from before 🆒 so you need to reference maybe the $price var for the item selected from the combo box?

nemonoman

Try this in your Javascript:
NOT

document.form.price = prices;

BUT

document.form.price.innerHTML = prices;

Clee2004

Still not working 🙁 .

Does someone have a working script for me???
It would really help me.

Tnx Clee2004

nemonoman

I have now actually read your javascript and discovered that you have no clue what you're doing.

First off, you're not using a textarea, you're using a text input field. To change the content of a text input field use javascript:
document.form1.price.value = 'x';

Give your form a name other than "form"

There's no need to recreate the select area in your javascript: javascript can already read it.

You want to pass the value onClick

You want to pass "this" -- the object being clicked -- to your function

I've made some changes quickly that will either work immediately or indicate what sort of direction you need to take to debug.
<HTML>
<HEAD>
<? list ($select, $prices) = select_item_price (); ?>
<script>
function showPrice(selecteditem)
{

        document.form1.price.value = selecteditem.value;
    }
    </script>    
</HEAD>
<BODY>



    <form name= "form1">
        <select name="item" onClick="showPrice(this)">
            <? echo $select; ?>
        </select>
        <input type="text" name="price" value= "">
    </form>

Oh, hell, read a tutorial