the update query just update the last row and affect other with it’s value

by

You need to change the form so that each row has a hidden input containing the ID of that row. 

while($row=mysql_fetch_array($result)){   ?>
<tr>  
    <td><input type="hidden" name="id[]" value="<?php echo $row['id'];  ?>" /></td>
    <td><input type="text" placeholder="First Lecture" name="day[]" value="<?php echo $row['day']; ?>"></td>
    <td><input type="text" placeholder="First Lecture" name="f[]" value="<?php echo $row['first']; ?>"></td>

</tr>
<?php }

Then use that ID in the UPDATE statement, not group_num.

foreach ($_POST['id'] as $i => $id) {
    $scoreaway = $_POST['f'][$i];
    $day = $_POST['day'][$i];
    $query = "UPDATE lectures_table 
                SET first="$scoreaway", day = '$day' 
                WHERE id = $id";
    mysql_query($query);
}

Also, you should switch from the obsolete mysql extension to mysqli or PDO, and use prepared statements. Your current code is vulnerable to SQL injection. See How can I prevent SQL injection in PHP?

More Related Contents:

  1. How to find missing attendance from the database table
  2. Php mysql tabs don’t output [closed]
  3. Update Mysql except when field not null
  4. PDO support for multiple queries (PDO_MYSQL, PDO_MYSQLND)
  5. How to use mysqli prepared statements?
  6. PHP MySQL Google Chart JSON – Complete Example [closed]
  7. pdo prepared statements with wildcards
  8. I cannot get my login form to connect interact properly with mySQL database [closed]
  9. Do I have to guard against SQL injection if I used a dropdown?
  10. Best way to check if mysql_query returned any results?
  11. mysql_fetch_array return only one row
  12. php include error not findind the path
  13. mysql_num_rows(): supplied argument is not a valid MySQL result resource [duplicate]
  14. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  15. a better approach than storing mysql password in plain text in config file?
  16. Selecting a float in MySQL
  17. mysql query result in php variable
  18. mysql_real_escape_string is undefined
  19. Unknown database error in PHP but it exists in PHPMyAdmin
  20. How do detect that transaction has already been started?
  21. CakePHP Database connection “Mysql” is missing, or could not be created
  22. How to get primary key of table?
  23. Simple way to read single record from MySQL
  24. How to insert json array into mysql database
  25. Why do I get “Resource id #4” when I apply print_r() to an array in PHP? [duplicate]
  26. How to backup MySQL database in PHP?
  27. Auto Increment skipping numbers?
  28. Convert Time String to Decimal Hours PHP [closed]
  29. What is the PDO equivalent of function mysql_real_escape_string?
  30. Installing PDO driver on MySQL Linux server

Leave a Comment