Jump to content


This topic is now archived and is closed to further replies.


MySQL Records limit

Recommended Posts

I'm sorry, maybe you're getting tired of me, but this is very important to me, and you are great people.

I can now easily output mysql records but if I have 50 records, mysql outputs those 50recs to my php script, what I want is to have a limit of the records like showing just 20 records, and then having a link to show more 20 records, and another link to show the rest.

The links to the rest of the db are not need right now, I just want to limit the records number for now.

Thanks before.

Share this post

Link to post
Share on other sites
[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] * [color=green]FROM[/color] [color=orange]tablename[/color] LIMIT 50 [!--sql2--][/div][!--sql3--]

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.