I am using php and mysql database.
1)i want to retreive thousands of records from database and display only 100 records per page.(that is in same page called
as records.php but 100 records per page every time)
"select * from table limit 0, 100" displays only first 100 records .
how to display remaining records.
2) which sql query we should use to retreive distinct records
example " select * from table Distinct."
wheter this works to avoids duplicates.
pls reply
