id generation for dynamic input text field

[soundobj]

HI there all,

I am creating form for inputing data onto MySQL, the form is dynamically generated depending on how many staff exist on the db so I dont know the id of the input text fields. I managed to work out something such as this:

for ($i= 0 ; $i <= $num_results-1 ; $i++){
$row = mysql_fetch_array($result);

echo '<TR><TD WIDTH="113" >'.htmlspecialchars(stripslashes($row['staff_no'])).'</TD>';

for ($b = 0 ; $b <= 6 ; $b++){

echo '<TD WIDTH=" 81.6 " ALIGN="CENTER"><INPUT TYPE="text" NAME="'.$row['staff_no'].$b.'" SIZE="3" MaxLENGTH="3" </TD>';

	}

echo '</TR>';

}

when I do print_r($_POST) I get this:

[02E600] => [02E601] => [02E602] => [02E603] => [02E604] => [02E605] => [02E606] => [1To5K0] => [1To5K1] => [1To5K2] => [1To5K3] => [1To5K4] => [1To5K5] => [1To5K6] => [28kfk0] => [28kfk1] => [28kfk2] => [28kfk3] => [28kfk4] => [28kfk5] => [28kfk6] => )

I managed to create an unique ID for each field.
based on the staff_id plus the loop $b value

the problem I have now is how to retrieve this values. I know how many staff will be in the db and the and the added digits is allways from 0 to 6 but I cannot figure out how to do it

any help would be much appreciatted

any ideas?

[devinemke]

is staff_no a unique field in the db? if so you can just use that as the id and return all the data as an array:

while ($row = mysql_fetch_assoc($result))
{
	echo '<input type="text" name="input[' . $row['staff_no'] . ']"><br>';
}

you will then have an array called $_POST['input'] with the staff_no's as the keys and the user input as the vaules.

[soundobj]

HI there again:

i am getting closer, now I managed to simulate the $_posted variables indexes creating a 2 dimensional array:

for ($i=0 ; $i <= $num_results-1 ; $i++){

$row = mysql_fetch_array($result);

$id[$i] = $row['staff_no'];

$a=0;
$b=1;
$c=2;
$d=3;
$e=4;
$f=5;
$g=6;

$mem[$i]= array ( $member[0]= $id[$i].$a,
$member[1]= $id[$i].$b,
$member[2]= $id[$i].$c,
$member[3]= $id[$i].$d,
$member[4]= $id[$i].$e,
$member[5]= $id[$i].$f,
$member[6]= $id[$i].$g);
}

now I get this output:

print_r($mem);

Array ( [0] => Array ( [0] => 1To5K0 [1] => 1To5K1 [2] => 1To5K2 [3] => 1To5K3 [4] => 1To5K4 [5] => 1To5K5 [6] => 1To5K6 ) [1] => Array ( [0] => 28kfk0 [1] => 28kfk1 [2] => 28kfk2 [3] => 28kfk3 [4] => 28kfk4 [5] => 28kfk5 [6] => 28kfk6 ) [2] => Array ( [0] => 0 [1] => 1 [2] => 2 [3] => 3 [4] => 4 [5] => 5 [6] => 6 ) )

for some reason it is skiping the first staff_id 7 input fields
any ideas why?

[soundobj]

nope, the structure of the table is as follows:

DROP TABLE rota;
CREATE TABLE rota
(rota_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
r_date DATE,
status CHAR (3) CHECK (status IN (‘ONN’,‘OFF’,‘HOL’,‘SCK’,‘ABS’)),
comment VARCHAR (150),
staff_no CHAR(5) NOT NULL ); -- FK REFERENCES Staff (staff_no)

Thanks a lot for your reply, will take that on account