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. 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--] 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. Link to comment https://forums.phpfreaks.com/topic/5302-mysql-records-limit/#findComment-18889 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.