Jump to content


Photo

LIMITS


  • Please log in to reply
3 replies to this topic

#1 korrupt_23

korrupt_23
  • Members
  • PipPip
  • Member
  • 13 posts

Posted 17 November 2003 - 01:52 AM

Hey, just quick question, but how would you make a limit be something though something. For example, 20 through 40?

I thought it was..

LIMIT 20.40

But it seems to cut it off at a weird point, so I just wanna make sure.


Thanks in advanced.
KoRRupt

#2 Arenium

Arenium
  • Staff Alumni
  • Advanced Member
  • 111 posts
  • LocationMassachusetts

Posted 17 November 2003 - 02:37 AM

err...not exactly, limits can be tricky the way you want to use them:

http://www.mysql.com.../en/SELECT.html

#3 triphis

triphis
  • Members
  • PipPipPip
  • Advanced Member
  • 62 posts

Posted 17 November 2003 - 04:16 AM

Im way to lazy to go find the correct answer, but LIMIT is either:

#how many records,where you start. for example

5,20 = records 20-24

OR

where you start,#records. for example

5,20 = records 5-25
Xac Attack

#4 korrupt_23

korrupt_23
  • Members
  • PipPip
  • Member
  • 13 posts

Posted 18 November 2003 - 01:47 AM

Ah, I do see a little bit.. thanks. It cleared up a few confusing things I had problems with. 8)
KoRRupt




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users