| NamePros Regular Location: mysitememberships.com Join Date: Jul 2005
Posts: 891
NP$: 4687.90 ( Donate)
| well you should have a key field with ID and then probably another field of "rank" which are numbers which you probably update manually or whatever.
just add ORDER BY rank ASC at the end of your sql statement and it'll order them for you. don't bother moving the entries aruond, cuz that'll take wayyy too many resources, especially if u get a large db.
edit: actually, after rereading your post, i think the proper sql command you're looking for is UPDATE. make sure you have a primary key field of id which autoincrements or w/e and then u can do an UPDATE command. google the exact syntax, i never get it perfectly right... |