I have table
images with ID's starting from 1 to 5000. On the page they are showed straight from 1 to 5000. What I wonder is it possible to scramble the records inside database table not to query them by
RAND() on the page because they will be random on every refresh. I don't want this.
id(1) to become id(343)..
id(453)->id(4444) and so on.. just scrambling them.
UPDATE: This is the query which I'm trying
alter table images add column randorder double; update table images set randorder = rand(); create index idx_table_randorder on table(randorder);
When is executed I got column
NULL but the query return again
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table images set randorder = rand()' at line 1