Double Combobox & Mysql

[Anon]

Hi,

I need to do a search page using a double combo box like the example in http://www.wsabstract.com/script/cut183.shtml

which is written in javascript and manually defined links for the combo boxes..

Now, I need to fill in the options with mysql values on the 2nd box depending on the first box..

I have searched the forums and could;nt really find anything of help or a newbie like me..

Any input will be very appreciated.

basically, I tried this (implementing mysql calls in the javascript given on the above link:

/
Double Combo Script Credit
By Website Abstraction (www.wsabstract.com)
Over 200+ free JavaScripts here!
/

var groups=document.doublecombo.example.options.length
var group=new Array(groups)
for (i=0; i<groups; i++)
group=new Array()


if (i=0) {
<?php

$result = mysql_query(SELECT * FROM car_record WHERE made LIKE 'ferrari', $db);
while ($row = mysql_fetch_array($result))
{
printf("group[0][$i]=new <option value=''>$row[model]</option>");

}

?>

well, that doesn't work..

[matto]

Now, I need to fill in the options with mysql values on the 2nd box depending on the first box..

your example doesn't work because you're confused about which code controls which. I mean, you can use a server-side scripting language to produce some javascript code inside the html file which, interpreted by the client, will be regarded as static.

however, you can force the script to reload - this can be done by javascript. imagine this: user selects from first box -> javascript reloads the page with parameter (id of selected item) -> page is reproduced depending on that value.

a la: script.php?itemselected=12