how to get Record set starting form Perticular record

  • 12 years ago

    this is my Table structure and some records in it,
    Am trying to get a Record set to get all the records whose album Id is 40.  and that works fine and shows like this.



    Img_ID Instructor_id Img_thumb Img_big album_id
    29 13 NULL images/Test_Feb22/42670011.jpg 40
    30 13 NULL images/Test_Feb22/42680009.jpg 40
    31 13 NULL images/Test_Feb22/42680013.jpg 40
    32 13 NULL images/Test_Feb22/42690010.jpg 40
    33 13 NULL images/Test_Feb22/42690014.jpg 40
    34 13 NULL images/Test_Feb22/42690022.jpg 40
    38 13 NULL images/Test_Feb22/42670011.jpg 40
    43 13 NULL images/Test_Feb22/pg2_img1.jpg 40
    but I want to get a Record set that starts form particular Image_id. For example if I say Img_id=34, it should start form records in this order,

    Img_ID Instructor_id Img_thumb Img_big album_id
    34 13 NULL images/Test_Feb22/42670011.jpg 40
    38 13 NULL images/Test_Feb22/42680009.jpg 40
    43 13 NULL images/Test_Feb22/42680013.jpg 40
    29 13 NULL images/Test_Feb22/42690010.jpg 40
    30 13 NULL images/Test_Feb22/42690014.jpg 40
    31 13 NULL images/Test_Feb22/42690022.jpg 40
    32 13 NULL images/Test_Feb22/42670011.jpg 40
    33 13 NULL images/Test_Feb22/pg2_img1.jpg 40
     Can you please help me out in writing a query for this in MySQL?
    thank you .

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“An idiot with a computer is a faster, better idiot” - Rich Julius