php

[psn]

I am using php & mysql

1)I am retreiving thousands of records from database.
But i want to display only 100 records per page
"select * from table limit 0, 100" will display only first 100 records .
So how to display remaining records(100 records per page) in the
same page.

2)I am having duplicate emailids in my mysqldatabase.
how to retreive all/distinct records based on emailid?
"select distinct colname1,colname2 form table where emailid ='$email'";

"select all colname1,colname2 form table where emailid ='$email'";

Both this statement works only if there is no duplicate emailid.
But for duplicate emailid it doesnot works. why?

Pls reply.

[laserlight]

But i want to display only 100 records per page
"select from table limit 0, 100" will display only first 100 records .

"SELECT FROM table LIMIT 100, 100" will display the next 100 records.
Search for pagination for more information.

I am having duplicate emailids in my mysqldatabase.

Do you need to allow duplicates in the first place?

"select distinct colname1,colname2 form table where emailid ='$email'";

"SELECT DISTINCT emailid WHERE emailid='$email'"