LESSON LEARNED! Ouch! :(
Posted: Thu Aug 15, 2002 3:06 pm
ok so I'm writing a program for people to be able to update their pictures on their profiles...
well like a dumbass instead of taking some time to back up the table or make a test DB I just said, eh this is quick I'll use the live system
well here was my query statement:
instead of:
OH LORDY, it just updated all my records with the same damn file
luckily is under 100 records, but now I have to redo them all manually, I think I've learned my lesson on paying attention
well like a dumbass instead of taking some time to back up the table or make a test DB I just said, eh this is quick I'll use the live system
well here was my query statement:
Code: Select all
update user set user_image = '$filen'instead of:
Code: Select all
update user set user_image = '$filen' where user_id = $useridluckily is under 100 records, but now I have to redo them all manually, I think I've learned my lesson on paying attention