Update query in for loop

Question

why it's not working.. i want to update my table in database this is my code. for ($i=0; $i <83 ; $i++) { $link="this is test".$i; $sql = "UPDATE tbl_gallery_images SET thumbnail_url='$link' WHERE gallery_id=1"; // Prepare statement $stmt = $conn->prepare($sql); // execute the query $stmt->execute(); echo $link."
"; } when i echo that link it's show 100% right but in db just update 82 number in all rows even it is in loop. thanks in advance. JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

UPDATE tbl_gallery_images SET thumbnail_url = '$link' WHERE gallery_id = 1 As it is, this query updates column thumbnail_url in all records that have gallery_id = 1. Running the same query 84 times in a loop results in the same set of records being updated again and again in each iteration, with an increasing thumbnail_url. After the last iteration, all records where gallery_id = 1 end up with thumbnail_url = 'this is test83. A sensible solution would be to add another criteria in the WHERE clause, in order to update just one record per iteration. Assuming that you have some integer column called id to disambiguate the records where gallery_id = 1, you would typically go: `UPDATE tbl_gallery_images SET thumbnail_url = '$link' WHERE gallery_id = 1 AND id = $i`