The solution was CREATE TABLE copyname SELECT * FROM originalname I was having problem with a PHP command that's not pulling what I want from the table Ruling out random order for the rows was narrowing the focus on the PHP problem.
Why not just create a VIEW and leave your original table alone? thnx, Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
