[SOLVED] Selecting the last, biggest

[regdude]

Hi!

I can't figure out how to make a script (in mysql) that will select from a table the largest ID that has visible=1 and the limit is for example 3.

The idea is that the script will tell PHP wich will be the next ID.

This is what i made for now(doesn't work):

SELECT * FROM table WHERE visible="1" ORDER BY id LIMIT 3;

This could be the table:

id....visible

1.....0

2.....1

3.....1

4.....0

5.....1

6.....0

7.....1

........

 

The next ID would be 7, but how could i select that?

The LIMIT is changing everytime! So if the LIMIT would be 2 - the next ID would be 5.

[allenskd]

Try this one

SELECT * FROM table WHERE visible="1" ORDER BY id DESC LIMIT 3;

 

Will display descending the ids

[regdude]

Yeah, i know that, but i want the biggest ID - one number.

I further need it for use.

$biggestID = ...;

[allenskd]

Well, I don't know how well this is going to scale but

SELECT MAX(id), visible FROM table WHERE visible="1" ORDER BY id LIMIT 3;

Give that a try

[regdude]

Ok, thanks!