php - How to fetch million of record using mysql query within jquery pagination -


i have more 10 million data in table, need 1 column email table , want display list of of data website have used theme pagination done without database jquery, should use php pagination ?

please give me suggestion used query

select emails tablename 

when execute query returns error

500 - internal server error. there problem resource looking for, , cannot displayed. 

total record 1700,000 [rows]

you should use condition limit requested data. if dont php run memory problems. cause topic broad discribe here directly here's page dig it:

http://www.w3schools.com/sql/sql_where.asp


Comments