mysqli data seek from set position

knowj

How would i use the row location from getproduct() within getimgnav() but still retriving the rows from query within getimgnav().

I'm sure its a simple solution but my brains drawing a blank atm

public function getproduct($code)
{
   if($result = $this->database->query("SELECT * FROM `products` WHERE code='$code'"))
   {
      return $result->fetch_array(MYSQLI_ASSOC);
   }
   return 0;
}

public function getimgnav($product, $num = 9)
{
   $product = $this->database->antisql($product);
   if($results = $this->database->query("SELECT * FROM `products` LIMIT $num"))
   {
      $results->data_seek($results->current_field - 4);
      while($row = $results->fetch_array(MYSQLI_ASSOC))
      {
         if($row['code'] == $product)
         {
            echo '<li><a href="/products/' . $row['code'] .
               '/" class="active"><img src="' . $row['image_thumb'] .
               '" alt="' . $row['name'] . '"/></a></li>' . "\n";
         }
         else
         {
            echo '<li><a href="/products/' . $row['code'] . '/"><img src="' .
               $row['image_thumb'] . '" alt="' . $row['name'] .
               '"/></a></li>' . "\n";
         }
      }
   }
}

Reformatted code to aid readability here -- NogDog

NogDog

There may be a simple answer, but I just can't figure out what the exact question is. 😉 Are you asking how to have the data_seek() in the second function go to the row that would be returned by the first function?

knowj

Yes. I need it to go to there but then be able to count back 4 rows. I can't use the same query because it only has one result. I just need to be able to say start at this row (from the first query) in the 2nd method.

This will allow me to display a navigation of 9 items with the currently selected item being centred.

btw don't ask me why "current_field" is there i was going through a burnout stage when i got to that point.

knowj

-duplicate post-

NogDog

I can't think of any clever, simple solution. The only thing that comes to mind is if there is some sort of auto-increment type field to key off of, then you could do something like getting that field value for the record with the desired "code" value, then to the 2nd query using a BETWEEN clause on that field, e.g.:

$query = "SELECT * FROM PRODUCTS WHERE key_field BETWEEN " . $key - 4 .
         " AND " . $key + 4 . " LIMIT 9";

knowj

Cheers Nogdog as always your a brilliant help.