9 replies to this topic

[Aussiestinger]

Is there any way to show the 15 newest except the very newest?

say i got

$query = "SELECT * FROM news ORDER BY ID DESC LIMIT 15";

is there anyway to make it show the latest 15 except the very latest? or it more complicated then that and would have to do with php?

[Matthew.]

so, you want entries 15 - 30 (missing out the lastest 15) right?

try this:

$query = "SELECT * FROM `news` ORDER BY ID DESC LIMIT 15, 30";

[Erik Bernskiold]

So you want to display item 2-15 and not number 1, is that correct?

[Matthew.]

-->

So you want to display item 2-15 and not number 1, is that correct?
[/quote]

Could mean that also lol. People need to be more specific when posting



If that's the case.

• Back to top

[Erik Bernskiold]

Often that is the case, and in case you havn't noticed, I really left this question to you since I am not too good with PHP...you would have known this by the top of your head, wheareas I would have been searching

Aussiestinger, hopefully that was what you wanted?

[Aussiestinger]

Yeah the second one is what I needed, thanks heaps works perfectly.

[rc69]

.Matt, on Jul 7 2006, 02:55 PM, said:

$query = "SELECT * FROM `news` ORDER BY ID DESC LIMIT 1, 16";

Souldn't that 16 be a 15? I'm asking because my long absence from actually coding might have made me forget something, but i believe the number after the comma is total results, and the number before is record to start at.

Just wanted to bring this up for future readers.

Edited by rc69, 08 July 2006 - 12:04 AM.

[liveman]

Yeh, RC is right its 15, unless he still wants 15 shown except the first one?

[Matthew.]

lol, i think doing nothing coding wise apart from help on forums for a few months is begining to show :$

Quote

unless he still wants 15 shown except the first one?

Thats how i read it, he says it works so it was probably right Good point though rc69.

[rc69]

Thankfully my memory is good, so the decay will be slow at best. But either way, this will probably bug me till it's solved, and already knowing that, i decided to get MySQL's official opinion on the subject.

Since i read it the same way you two did, my way should be right.
[quote name='http://dev.mysql.com/doc/refman/4.1/en/select.html']The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement. LIMIT takes one or two numeric arguments, which must both be non-negative integer constants (except when using prepared statements).

With two arguments, the first argument specifies the offset of the first row to return, and the second specifies the maximum number of rows to return. The offset of the initial row is 0 (not 1):

SELECT * FROM tbl LIMIT 5,10; # Retrieve rows 6-15[/quote]

Either way, if it works how he wants it to, then it works, and there's nothing i'm willing to do to change that