Walking through a mysql_array

[chops]

I know this can be done I'm just not sure how...I have a database with paths to different images. I write a popup window when someone views an image that displays a next and previous button for the next and previous image in that folder.

I am having trouble getting my code to work...I basically need to walk through the array then figure out if the element im on is the image im looking at....if it is advance the array pointer and write a next button...then reverse the array pointer 2 to write the previos button. My problem is that im using mysql_fetch_assoc($result) and I can't seem to be able to walk through the array without calling mysql_fetch_assoc($result) to advance the pointer.

[mithril]

http://www.php.net/manual/en/function.mysql-data-seek.php

Aren't manuals grand?🙂

geoff

[chops]

isn't there a way to grab the entire array out so I can use the normal array functions (next, prev, each, etc..)

[mithril]

You could try something like this:

  //..... connection code

  $rs = @("SELECT field1,field2,field3 FROM my_table");

  while ($row = @mysql_fetch_array($rs)) {

    $result[] = $row;
  }

This will create a 2-dimensional array containing the entire result set. To access field2 in the 4th result row you'd use:

  $result[3]["field2"]

However, this method does have some performance issues. It introduces an additional loop to the script which must iterate as many times as there are rows retrieved from the database. It also must allocate additional server memory for the creation of the $result variable. The more rows in your result set, obviously the bigger the performance impact will be.

HTH.

geoff