Displaying Data From Mysql?

[clovis 0]

how can i display data from mysql with php, just that on one page i want to display only the first 10 things and the next page the next 20 ...etc.. how can i do that?

[soleimanian 0]

there are many tutorials on the web
go to following url, you can find your answer
http://www.onlamp.com/pub/a/php/2000/11/02ous.html?page=1

[jvizueta 0]

Doing this has got nothing to do with php it self, or php library for mysql, but with the sql statement you send, you just have to stablish limits for your query results, like this

 

 

SELECT * FROM TABLE LIMIT 0, 10

the first argument to LIMIT it would be the offset, and the second one is the number of rows to show, you just have to play with that, but this is really something you shouldn't do, because although it's not a difficult thing to do, you can find that script anywhere

 

try searching in phpclasses.org, I've seen some of those there

 

just write "paging" in the search textfield

[iGuest 3]

How do I put data from mysql in form of checkboxes?Displaying Data From Mysql?

I need to put data from mysql into checkboxes, select option aswell, so that it exports and prints a table! 

Any help, would be appreciated!