passing array values to another function

[Anon]

Hello again everyone!

Thanks once again for your time.
Here's what i'm up to: I have a form, and in this form I have 2 drop down lists. The lists consist of values from another table. Anyways, I had to put these values in an array to work. My question is: Now that I have the values in the list, and I have chosen a value, how do I pass that value to my update function where I can change the record in my database?

Any ideas?

function edit(){
GLOBAL $dbName, $level_typeID, $levelID, $typeID, $levelName, $typeName;

$levelNameIDArray=Array();
$levelNameArray=Array();
$levelIDArray=Array();

$typeNameIDArray=Array();
$typeNameArray=Array();
$typeIDArray=Array();

$n=0;

//convert $levelName into array
$sql="SELECT levelID, levelName
FROM level";

$result=mysql($dbName, $sql);

while($row=mysql_fetch_row($result)){
	$levelID=$row[0];
	$levelName=$row[1];

	$levelNameIDArray[]="$levelID";
	$levelNameIDArray[]="$levelName";
	$n=$n+1;
}

//convert $typeName into array

$sql="SELECT typeID, typeName
	FROM type";

$result=mysql($dbName, $sql);


while($row=mysql_fetch_row($result)){
	$typeID=$row[0];
	$typeName=$row[1];

	$typeNameIDArray[]="$typeID";
	$typeNameIDArray[]="$typeName";
	$m=$m+1;
}

//puts values in levelIDArray and levelNameArray from levelNameIDArray.
for ($i = 0; $i < sizeof($levelNameIDArray); $i++){
$levelIDArray[] = $levelNameIDArray[$i];
$i++;
$levelNameArray[] = $levelNameIDArray[$i];

}
//puts values in typeIDArray and typeNameArray from typeNameIDArray.
for ($n = 0; $n < sizeof($typeNameIDArray); $n++){
$typeIDArray[] = $typeNameIDArray[$n];
$n++;
$typeNameArray[] = $typeNameIDArray[$n];
}

print"<h2>Modify Level Type Record</h2>";
print"<table border=1 bordercolor=#000000 cellpadding=1 cellspacing=0 width=50%><tr>";
PRINT"<FORM NAME=\"EditLevelTypeForm\" ACTION=\"level_type.php?section=update&level_typeID=$level_typeID\" METHOD=\"POST\">";

print"<br><br><table border=1 bordercolor=#000000 cellpadding=1 cellspacing=0 width=50%><tr>";

$i=0;
$j=0;
$m=$m+1;
$n=$n+1;

$sql="SELECT level_type.level_typeID, level.levelName, type.typeName, level.levelID, type.typeID
FROM level_type
LEFT JOIN type ON level_type.typeID =type.typeID
LEFT JOIN level ON level_type.levelID =level.levelID
WHERE level_typeID='$level_typeID'
ORDER BY '$level_typeID'";

$result=mysql($dbName, $sql) or die("database error");

while($row=mysql_fetch_row($result)){
$level_typeID=$row[0];
$levelName=$row[1];
$typeName=$row[2];
$levelID=$row[3];
$typeID=$row[4];

}

print"<tr><td>Level</td><td>";
print("<SELECT NAME=levelID>\n");
while($i<$n){

	print"<OPTION VALUE=\"$levelIDArray[$i]\" ";
		if($levelName==$levelNameArray[$i]){print "SELECTED";}
		print ">$levelNameArray[$i]\n</option>";

	$i=$i+1;

}
print "</SELECT>";
	print "</td></tr>";     ///////////////////////////////////

print"<tr><td>Type</td><td>";
print("<SELECT NAME=typeID>\n");
while($j<$m){

	print"<OPTION VALUE=\"$typeIDArray[$j]\" ";
		if($typeName==$typeNameArray[$j]){print "SELECTED";}
		print ">$typeNameArray[$j]\n</option>";
	$j=$j+1;
}
print "</SELECT>";
	print "</td></tr>";

?>

<tr><td colspan=2><center>
<INPUT TYPE="SUBMIT" VALUE="Submit"><INPUT TYPE="RESET" VALUE="Reset"></td></tr>
</center></form></table>
<?

} ///////////////// END EDIT FUNCTION

function update($i, $n){
GLOBAL $dbName, $level_typeID, $levelID, $typeID;

$levelNameArray=Array();
$levelIDArray=Array();
$typeNameArray=Array();
$typeIDArray=Array();

$sql="UPDATE level_type
SET level_typeID='$level_typeID',
levelID='$levelID';
typeID='$typeID';
WHERE (level_typeID='$level_typeID')";

$result=mysql($dbName, $sql);

print"Thank you! Record has been modified!";

} /////////////////// END UPDATE FUNCTION