In message <[EMAIL PROTECTED]>, Brian Cummiskey <[EMAIL PROTECTED]> writes >> I hate to disagree (he lied <G>) but adding an autoinc field will make >> that field automatically renumber itself. > >yes, it will work. but, IMO, its VERY impractical. Especially if >you're trying to keep the table useful in a relational database >structure.
If you are about to give these records a number, so that you can add child records in another table, then it's perfect. Or if you might, in the future. >you want them in order? you have the ORDER BY clause. >you want to display them in order, with nice 0 through 25 (for example) >numbers, do it in php or in the sql statement itself. Agreed. -- Pete Clark http://www.hotcosta.com http://www.spanishholidaybookings.com Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
