Hi, > I need to add a new auto field to my db, but I need to make sure the records are listed in order of one of the other fields first which is a date field. > > Any ideas how I do this would be greatly appreciated!
"listing records" is in no particular order, unless you ask for an order. SELECT ... column names ... FROM ... table name(s) ... WHERE ... where clause ... ORDER BY MyDateColumn With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]