regdude Posted July 4, 2008 Share Posted July 4, 2008 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. Quote Link to comment Share on other sites More sharing options...
allenskd Posted July 4, 2008 Share Posted July 4, 2008 Try this one SELECT * FROM table WHERE visible="1" ORDER BY id DESC LIMIT 3; Will display descending the ids Quote Link to comment Share on other sites More sharing options...
regdude Posted July 4, 2008 Author Share Posted July 4, 2008 Yeah, i know that, but i want the biggest ID - one number. I further need it for use. $biggestID = ...; Quote Link to comment Share on other sites More sharing options...
allenskd Posted July 4, 2008 Share Posted July 4, 2008 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 Quote Link to comment Share on other sites More sharing options...
regdude Posted July 4, 2008 Author Share Posted July 4, 2008 Ok, thanks! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.