PHP and JS problem

crazyrick

I'm making a page on which I basically fetch some data about weapons from a database and put them into a <select> in a form.

The code that I use it for is:

$result = $db->query("SELECT * FROM weapons WHERE id>0");
	while($row = $db->fetch_array($result))
	{
		$id = $row[id];
		$wid[$id] = $id;
		$wdr[$id] = $row[damage];
		$wsp[$id] = $row[splash];
		$wac[$id] = $row[accuracy];
		$wsi[$id] = $row[size];
		$wfr[$id] = $row[firerate];

	$weap_options .= "<option value=$row[id]>$row[name]</option>";
}

I also store the info in an array so that I could pass it on as a hidden value in a form.

What I want is that, when an user selects one of the weapons, the stats for it get displayed in <input type=text> boxes underneath the select. Now I need a JS function that would extract the needed info from the $wid array, and change the values of the stats text fields.

Can anyone please help me?

Thanks you in advance.

The_Chancer

All it would be is using the onchange option for the select tag, and making it select the info out of an array setup in javascript from your database values.

Then putting it into the text boxes would be easy.

Have a look on google for onchange javascript examples. There are quite a few out there.

For an example of the onchange select function affecting another select box, have a look at www.fish4cars.co.uk it has one on the front page.

crazyrick

ok i'll give it a go, but as I said I have no experience in JS.

Thank you for your time.

The_Chancer

I didn't before I started !! :p :p

If in doubt hardcode, then try putting in the database info with PHP, if it fails, then you know it is your PHP at fault....

Compare the two finished HTML products for differences as well... and you'll get there..

crazyrick

ok either i'm too dimwited or something, but I just can't figure it out, I just can't write any JS.

crazyrick

Anyone willing to help me more spefically? Please.

niroshan

hi,
I thought of doing this in a different way. I dont no whether u want this. but i think this will solve u`r problem.

Insted of using arrays i first grab the usefull parts to fill the combo box and fill it. then on combo changed i submit that form using JS. (I pass a hidden field also)

then i query again and get the results according to that combo value and display them. pretty simple.

here is the code just in case u need it.

<html>
<head>
<title>read Contents</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form name="form1" method="post" action="help.php">
<select name="select" onchange="document.form1.submit()"> 
<?php
mysql_connect("localhost","","");
mysql_select_db("crm");
@$result=mysql_query("select * from customer");
while(@$row=mysql_fetch_array(@$result))
{

print "<option value=".$row[first].">$row[first]</option>"; //store the values in the combo box

}
?>
</select>
<input type="hidden" name="go" value="yes">
</form>

<?php
if(isset($go)) // if value is selected from combo box
{
@$result=mysql_query("select * from customer where first='".@$select."'");
@$row=mysql_fetch_array(@$result);

print "  <br>";
print "  <input type=\"text\" name=\"textfield\" value=\"".@$row[first]."\">";
print "  <br>";
print "  <input type=\"text\" name=\"textfield2\" value=\"".@$row[last]."\">";
print "  <br>";
print "  <input type=\"text\" name=\"textfield3\" value=\"".@$row[first]."\">";

}
else
{
print " <br>";
print " <input type=\"text\" name=\"textfield\">";
print " <br>";
print " <input type=\"text\" name=\"textfield2\">";
print " <br>";
print " <input type=\"text\" name=\"textfield3\">";
}
?>
</body>
</html>

hope this would help!!!!

regards,
Niroshan