Jump to content


Photo

MySQL Records limit


  • Please log in to reply
2 replies to this topic

#1 turbocueca

turbocueca
  • Members
  • PipPipPip
  • Advanced Member
  • 62 posts

Posted 19 March 2006 - 06:25 PM

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.

#2 hitman6003

hitman6003
  • Members
  • PipPipPip
  • Advanced Member
  • 1,807 posts

Posted 19 March 2006 - 08:35 PM

[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] * FROM tablename LIMIT 50 [!--sql2--][/div][!--sql3--]

#3 turbocueca

turbocueca
  • Members
  • PipPipPip
  • Advanced Member
  • 62 posts

Posted 19 March 2006 - 09:05 PM

Thanks it works fine.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users