PHP Form Submits But Only Updates Last Row.

I am trying to update multiple data in the performance table but only the last row is being updated. In the performance table there are two primary keys. Player Id and Practice number. Each player can have multiple practice numbers. I am trying to update the practice performance data of each player but only the last practice performance data is being updated. Performance table is shown below.

This is the code which is not working and is only updating the last practice data for each player Id:

This is the code for update.php:

include("connection.php");

$query = "update performance set practise_no='$_POST[practise_no]',time='$_POST[time]',points='$_POST[points]' where id = '$_POST[id]' AND practise_no ='$_POST[practise_no]'";

$query_run = mysqli_query($link,$query);

?>

Please tell me what have I done wrong.

score id practise_no laptime 1 1 02:01:19.000000 98 1 2 02:02:14.000000 23 13 02:01:14.000000 74 2 1 02:01:14.000000 34 HTT

HOWCOSYS S SSSSSS Practise Number: 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Time Points: o HITE 32 33 34 35

1) in

36 37 38 39 40