Thread
:
a sql question anyone?
View Single Post
02-07-2005, 02:21 PM
RefaStud
Confirmed User
Join Date: May 2003
Posts: 183
if you are just updating the appear_id's and nothing else you can do something like this.
UPDATE records set appear_order=appear_order + 1;
that assumes you want to auto_increment the number by 1 in EVERY ROW in the DB;
RefaStud
View Public Profile
Find More Posts by RefaStud