Re: Recreate Table With Sorted Data

[Chris Boget]

> 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