CodingForums.com

CodingForums.com (http://www.codingforums.com/index.php)
-   MySQL (http://www.codingforums.com/forumdisplay.php?f=7)
-   -   SQL Limit start from (http://www.codingforums.com/showthread.php?t=285168)

craig101 01-02-2013 09:28 PM

SQL Limit start from
 
I have this query

Code:

SELECT * FROM Posts WHERE User = 'admin' ORDER BY Number DESC limit 0,25
Which would would the following results

Code:

2hnsk6i2iqgoh0c6kdbyd        admin        coecxrj0vqkow46h6243v        17:28        2013/01/02        1357147682
2hnsk6i2iqgoh0c6kdbyd        admin        uvde2od4fffjyri2se3v6        17:28        2013/01/02        1357147682
2hnsk6i2iqgoh0c6kdbyd        admin        7nvk4tamdcmmqxc8xxzns        17:28        2013/01/02        1357147682
2hnsk6i2iqgoh0c6kdbyd        admin        46ibv785bpbcqin5csgqt        17:28        2013/01/02        1357147681
2hnsk6i2iqgoh0c6kdbyd        admin        nprsukm2v7adx62psizcn        17:28        2013/01/02        1357147681
2hnsk6i2iqgoh0c6kdbyd        admin        5jffjmcrywv28ypxf88m8        17:28        2013/01/02        1357147681
2hnsk6i2iqgoh0c6kdbyd        admin        i5ejx2hqf7m6m4ybc0b43        17:28        2013/01/02        1357147680
2hnsk6i2iqgoh0c6kdbyd        admin        m72qzizi0ru4z6e2vz6vq        17:28        2013/01/02        1357147680
2hnsk6i2iqgoh0c6kdbyd        admin        3mf83zzvow6wt2gfhb6ub        17:28        2013/01/02        1357147680
2hnsk6i2iqgoh0c6kdbyd        admin        ct2j2u8xx8ny8x3u27sjc        17:27        2013/01/02        1357147679
2hnsk6i2iqgoh0c6kdbyd        admin        sdbx6iyburbeg0ie0magt        17:27        2013/01/02        1357147679
2hnsk6i2iqgoh0c6kdbyd        admin        5hir63ok3kq06g3upqbhk        17:27        2013/01/02        1357147679
2hnsk6i2iqgoh0c6kdbyd        admin        4pvuwgqazd84yck7adoxa        17:27        2013/01/02        1357147678
2hnsk6i2iqgoh0c6kdbyd        admin        oiv6quuyrpwe8bgirjr4i        17:27        2013/01/02        1357147678
2hnsk6i2iqgoh0c6kdbyd        admin        xcutah6426zesq323gfwx        17:27        2013/01/02        1357147678
2hnsk6i2iqgoh0c6kdbyd        admin        hgfqab040h4k55bjedpkt        17:27        2013/01/02        1357147678
2hnsk6i2iqgoh0c6kdbyd        admin        oonp5r3np5knm5d4ohm55        17:27        2013/01/02        1357147677
2hnsk6i2iqgoh0c6kdbyd        admin        cbckqm8qi2oaimir2epzi        17:27        2013/01/02        1357147677
2hnsk6i2iqgoh0c6kdbyd        admin        vtsaqex6wfdmh8ioceuvn        17:27        2013/01/02        1357147677
2hnsk6i2iqgoh0c6kdbyd        admin        0ubs8ur2wo55ohfuipdo0        17:27        2013/01/02        1357147677
2hnsk6i2iqgoh0c6kdbyd        admin        8tvorn65epoaict0fp26z        17:27        2013/01/02        1357147676
2hnsk6i2iqgoh0c6kdbyd        admin        soctqr26i7aycza2u73pi        17:27        2013/01/02        1357147676
2hnsk6i2iqgoh0c6kdbyd        admin        8ukjwmao2qtt374g6p7ej        17:27        2013/01/02        1357147676
2hnsk6i2iqgoh0c6kdbyd        admin        4wyinun2ki45h6ww73qg6        17:27        2013/01/02        1357147675
2hnsk6i2iqgoh0c6kdbyd        admin        3dpsbg2t7s7fj2hbiyenk        17:27        2013/01/02        1357147675

That brings up forums posts in a topic, but say the user is looking through post history, and wants to use that to go to the topic, i want some code like

Code:

SELECT * FROM Posts WHERE User = 'admin' ORDER BY Number DESC limit (SELECT * FROM POSTS WHERE POST = 'soctqr26i7aycza2u73pi'),25.
That of course doesn't work, but i don't know if you could, and if so, how i would be able to get that piece of code to work

Old Pedant 01-02-2013 10:13 PM

Code:

SELECT * FROM Posts
WHERE User = 'admin'
AND Number >= ( SELECT Number FROM POSTS WHERE POST = 'soctqr26i7aycza2u73pi')
ORDER BY Number
LIMIT 25

???

It would have helped if you have shown the field names for each of those columns. And/or if you had used SELECT field1, field2, field3, ... instead of SELECT * (which you shouldn't use, if possible).

craig101 01-03-2013 01:15 AM

Thats brilliant, thank you


All times are GMT +1. The time now is 09:58 PM.

Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.