Multiple update records not updating any records.

I have attached current DB table RestaurantTimings

Also attached the page of updating multiple records. screenshots of update record also attached. don't know whats wrong.

The page is retrieving old data properly. i have an multiple insert record behaviour made properly. but update ain't working. i don't know where i have gone wrong!.

Your column names "Start" and "End" are both reserved words in mySQL that shouldn't be used as column names. That may be what is causing this issue.

https://dev.mysql.com/doc/refman/5.5/en/keywords.html

i changed it to starttime & endtime yet same results. Not updating results

I'd need ftp access and steps to reproduce in order to debug it myself. I'd start by adding code below line 91 like:

echo($WA_Sql);
die();

and see what the update statement looks like... then try to run it in phpMyAdmin directly and see if it generates an error.

i got following error:

UPDATE `RestaurantTimings` SET `DayID` = 1, `RestaurantID` = 1, `Starttime` = '09:00:00', `Endtime` = '21:30:00', `Closed` = '' WHERE `RestaurantTimingID`='
Notice: Undefined index: RestaurantTimingID in /Applications/XAMPP/xamppfiles/htdocs/food/admin/edit-timings.php on line 171

Btw RestaurantTimingID are unique ID FYI.

Its all on my local server.

line 171:
<input type="hidden" name="WADA_RepeatID_RestaurantTimingID_<?php echo $RepeatSelectionCounter_1; ?>" id="WADA_RepeatID_RestaurantTimingID_<?php echo $RepeatSelectionCounter_1; ?>" value="<?php echo $row_Daylist["RestaurantTimingID"]; ?>" />

i found the error. its on the value <?php echo $row_Daylist["RestaurantTimingID"]; ?>
its wrong rs linked to. debugging functions really help. are there more as such debugging codes available so next time we can do it ourself?

Debugging is almost always done with echo() and die() statements in places to view the data when a problem occurs. In this case you were having a problem with the update, so I had you add it after the line of code that does the update.

alright thnks a lot