Hi, guys quick question
I have a form that’s going to have multiple pull down menus on it. The pull down menus are going to be populated from tables off the database. Its nothing fancy, by that i mean if you make a selection in one pull down menu the entire page or other pull down menus won't change. However i'm not sure if this is possible. I can get one pull down menu to work pulling the information off a database. But i'm not sure how to apply the same rule to multiple pull down menus. Each pull down menu uses a different table.
Any suggestions or a place to begin would be much appreciated. I though functions might be the answer. But I’m not sure how to pass more then one value out of a function.
For example I tried something like that but it didn’t work.
function getclass ()
{
$result = mysql_query ("Select CLASSDESC, CLASSID from CLASSLIST", $db);
$num = mysql_num_rows($result);
$rrow = mysql_fetch_array ($result);
$returnf = $rrow["CLASSDESC"];
$returni = $rrow ["CLASSID"];
return ($returnf, $returni);
}