Thread: UPDATE Problems
View Single Post
03-11-2008, 04:31 PM
#2
Dr John is offline Dr John
Status: Junior Member
Join date: May 2005
Location:
Expertise:
Software:
 
Posts: 77
iTrader: 0 / 0%
 

Dr John is on a distinguished road

  Old

WHERE 1=1
will result in all entries in the settings table being set to the values being input!!!
Even if there is only one entry in the table, and will only ever be one entry, this is a dangerous way to code things! One day you'll do that when there are lots of different entries in a table...