SQL problems....Error 28

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Locked
Deseree
Forum Commoner
Posts: 84
Joined: Mon Feb 13, 2006 11:35 pm

SQL problems....Error 28

Post by Deseree »

SELECT *
FROM `000_data_01`
WHERE `data_used` =0
ORDER BY RAND( )
LIMIT 10


MySQL said:

#1030 - Got error 28 from table handler
How do i fix this??? I have 2 million rows of data in table 000_data_01, and I want it to randomly return 10 rows.... and then mark those ten as used so they don't get used again....
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

You already tried threadjacking, and now multiple, identical threads?

Topic Locked.
Locked