Select data with a record limit

[mt7890]

i have created a database with contain a thousand of data.When i select records form the database with "Mathematics".It return me 200 record and show out in 20 page(each page can show 10 record only)

The question is :
1.How can i select the record with record limit=50?(that mean for the first search,display the first 50 records and so on on next search)

2.How can i selct the record randomly?(that mean not order in record_id and when next search held,no record will be repeat with the previous search)

[Anon]

1) SELECT field FROM table LIMIT 0, 50

2) Set up a rand number generator:

srand(microtime());
$num = rand(1,200);

Assuming your data has an auton-numeric field (add one if it hasn't), try this query

SELECT field FROM table WHERE autonum_field = $num

Hope this helps

fLIPIS