I am having a really bizarre problem!
That is I am updating a series of MySQL fields via Php While Loop.
However the 1st row is getting Updated but the other rows are not getting Updated regarding the MySQL Update, but they are getting executed regarding all other commands in the Loop!
And I have checked the MySQL Update commands, they are fine as they execute fine inside MySQL.
What could be causing this!!!!
In case, I have gone ahead and printed out a few lines of the Loop, printing out the MySQL Update command and following action in that Loop.
(1): UPDATE pap SET cc_number = '5424*******9191' WHERE id = 4156 AND user_id = 705| INSERTed cc_rem: 18082153
(2): UPDATE pap SET cc_number = '4388*******1002' WHERE id = 4157 AND user_id = 705| INSERTed cc_rem: 57602872
(3): UPDATE pap SET cc_number = '4388*******1002' WHERE id = 4168 AND user_id = 664| INSERTed cc_rem: 57602872
What in GODs name could be causing only the 1st MySQL Update to run and not others in the While Loop?