turbocueca Posted March 19, 2006 Share Posted March 19, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/5302-mysql-records-limit/ Share on other sites More sharing options...
hitman6003 Posted March 19, 2006 Share Posted March 19, 2006 [!--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--] Quote Link to comment https://forums.phpfreaks.com/topic/5302-mysql-records-limit/#findComment-18877 Share on other sites More sharing options...
turbocueca Posted March 19, 2006 Author Share Posted March 19, 2006 Thanks it works fine. Quote Link to comment https://forums.phpfreaks.com/topic/5302-mysql-records-limit/#findComment-18889 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.