[RESOLVED] Return value based on key

[jefterwil]

Here is my coding:

$get_startpic_array=mysql_query("SELECT pic_name FROM gal_pics WHERE gallery_id = '".$gid."' ORDER BY pics_id ASC")or die(mysql_error());

There are twenty rows that will be returned. I want the 8th.

$s=mysql_fetch_array/COLOR;
$value=$s[7];
echo $value;

This returned a blank.

I finally figured out that all of the values were associated with key 0. How do I get the 8th row?

[cahva]

With mysql_fetch_array it will give you the current row(which in this case is 0) as an array. In this case you can use either $s['pic_name'] or $s[0].

You have to move the actual result pointer to eight row. Check out mysql_data_seek(). Thats what you are after..

BTW, $get_startpic_array is not an array. Its the result of mysql_query so your naming is a little misleading.

EDIT: oh I forgot. I have almost never had to use mysql_data_seek function. Usually if you want some particular row, you should refine your sql and give it more precise search parameters(ex. .. WHERE id=4). Usually theres some unique id for every row(if there isnt, then its badly designed database).

[liquorvicar]

Or if the picture IDs are not sequential you could use LIMIT, i.e.

SELECT pic_name FROM gal_pics WHERE gallery_id = '".$gid."' ORDER BY pics_id ASC LIMIT 8,1

[jefterwil]

I used the LIMIT clause and it worked!! Thanks for your help.

P.S. How do I mark this as resolved?

[jefterwil]

Found it.