Hi<BR><BR>Could someone be kind enough to let me know how i can go about doing the following:<BR><BR>I already know how to get pictures from an sql database to be displayed in my asp pages, but i want to do the following:<BR><BR>I want to display one picture from the database then have a link below the picture saying previous and next. How would i then get the id of the next and previous images ? If any of them are clicked(previous or next), then the next or previous picture is displayed.<BR><BR>Also let me know how do i display one picture from the database without looping thru the database ?<BR><BR>I need to have an answer ASaP.<BR><BR>Thanks<BR><BR>Manesh