refreshing variables after a selection

lsobrino

hi guys...

i'm writing an application using php. i have one page in which the usr will choose from a select table a product code. in the mysql select statement i selected the product code, the product description and the product price.

how could i achieve the following need?...

if the user selects a product code from the select, i need to refresh the value of the "description" and "price" fields (already shown in the page).

so far nothing i've tried has worked out (even javascript), and i wouldn't like to use a couple of pages to achieve this.

could anyone hekp? it's important...

thanks in advance!

ps. pls take a look at the attached file so you can have an idea on how the layout looks right now...

cgraz

If you wanted to do it in php, you just submit the form (so that the page refreshes) and then run if statements to load the other selects. If you want to use javascript (so that you don't have to refresh the page), visit javascripts.com for some sample code.

Cgraz

lsobrino

cgraz:

thanks for the tip. i'm visiting the javascripts.com page at this moment. do you know under which category could i find this kind of sample code?

i'll try the submit option and see how it works...

thanks

stolzyboy

not sure about javascripts.com, but you can look here for javascript form help scripts

http://javascript.internet.com

good luck

cgraz

hey losobrino, i found the link. I wasn't home when I posted earlier so I didn't have the link handy.

http://webdeveloper.earthweb.com/webjs/jsnavigation/item.php/91311

Cgraz

stolzyboy

i think the submitting, cgraz would prove to be a better method, otherwise he will have to make arrays out of all the information regardless what he picks in the first drop down

you can always do an onchange and submit the form when you choose one selection, then it will grab the next drop down list from db, and so on.........

i think this is more what he wants

lsobrino

hi guys...

i found your posts to be very helpful. today i'll be trying both, the cascading method and also the submit method.

can i emulate the submit with js's submit() method instead of doing a real html submit, right? and also, i would have to add some "if" statements in order to determine if the page is being loaded for the first time or after the submit has ocurred.

i'll let you know how this one goes. and thanks again...

stolzyboy

here is an example of the onchange and submitting form, this one just takes you to the website you want it to, but i think you will get the idea, you can just put your url in each drop down (static or dynamic) and append id's or whatever on the url to pass the information, or whatever, and yes you will have to do if checking to see if anything has been passes

<html>
<HEAD>
<SCRIPT LANGUAGE="JavaScript">
function formHandler(form){
var URL = document.form.site.options[document.form.site.selectedIndex].value;
window.location.href = URL;
}
</SCRIPT>
</HEAD>
<BODY>
<center>
<form name="form">
<select name="site" size=1 onChange="javascript:formHandler()">
<option value="">Go to....
<option value="http://www.yahoo.com">Yahoo
<option value="http://www.metacrawler.com">Metacrawler
<option value="http://www.altavista.digital.com">Altavista
<option value="http://www.webcrawler.com">Webcrawler
<option value="http://www.lycos.com">Lycos
<option value="http://javascript.internet.com">JavaScript Source
</select>
</form>
</center>
</body>
</html>