how can i get next and previous field id with php from mysql
<p>i am trying to develop php photo album...and i have picture_id and album_id field in mysql table...and table name is photos</p>

<p>now i want to get next and previous picture_id field in same album...rather it is in series or not...i.e</p>

<pre><code>picture_id = 3242
album_id = 23
</code></pre>

<p>next picture</p>

<pre><code>picture_id = 5249
album_id = 23
</code></pre>
