[RESOLVED] fill table cell from data held in array populated by mysql

PHP_Idiot

I have two arrays used to populate cells in a table
The first array is fixed:

$pointsArray = array( 
   1 => 500, 
   2 => 350, 
   3 => 250,
   4 => 200,
   5 => 150,
   6 => 100,
   7 => 75,
   8 => 50,
  );

To use the data from the First array in the table I have:

echo $points = isset($pointsArray[$counter]) ? $pointsArray[$counter] : 25; ;

This put the correct number of points in the points colunm depending on the finishing position of the player.

The Second array is filled from mysql and therefore can change

function QueryIntoArray($queryA){
        settype($retval,"array");
$resultA= mysql_query($queryA);
if(!$resultA){
print "Query Failed";
        }        

        for($i=0;$i<mysql_numrows($resultA);$i++){
                for($j=0;$j<mysql_num_fields($resultA);$j++){
                        $retval[$i][mysql_field_name($resultA,$j)] = mysql_result
($resultA,$i,mysql_field_name($resultA,$j));
                }//end inner loop
        }//end outer loop
return $retval;
}

The second array works and I can print a list of all the information held in it using:

<?php
OpenDb($hostname,$uid,$pwd,$dbname) or die("Failed Opening Database");
settype($myresultA,"array");
$queryA = "SELECT * FROM Player";
$myresultA = QueryIntoArray($queryA);
for($i=0;$i<count($myresultA);$i++){
print $myresultA[$i]["MembershipNo"];
print $myresultA[$i]["FirstName"];
print $myresultA[$i]["NickName"];
print $myresultA[$i]["LastName"];
}
?>

Now is the bit I'm stuck on!!
I want to populate the FirstName column with the data held in the second array, but based on the membership number entered in the MembershipNo column by the user.

I know this can be done using onkeyup but I just don't know how!!

Can anyone help me work it out please?

sneakyimp

I don't understand what you are asking. I fail to see how the two arrays are connected.

PHP_Idiot

Sorry it was late when I asked the question, as you correctly pointed out they are completely un-related! just ignor the first array.

Let me try again..

The second array and form allows the user to pick a value from a drop down list. What I need is for the primary key field of the record selected in the dropdown to appear in a seperate text field, so I can use both when I process the form.

I hope that makes more sense!!

sneakyimp

Sounds like you need some javascript. I am not sure which field might be the primary key, but let's assume it's MembershipNo. You can define a 'drop down list' like this:

<script type="text/javascript">
function get_pk(sel) {
  var pk = sel.options[sel.selectedIndex].value;
  alert ('value selected is ' + pk);
  document.getElementById('my_input_id').value = pk;

}
</script>
<input type="text" name="my_input" id="my_input_id" value="">
<select name="my_select" onChange="get_pk(this);">
<option value="-1">-- Please Choose One --</option>
<?
for($i=0;$i<count($myresultA);$i++){
?>
<option value="<?=$myresultA[$i]["MembershipNo"] ?>"><?=$myresultA[$i]["NickName"] ?></option>
<?
} // foreach $myresultA
?>
</select>