How to reset pointer to database?

  
$db = new clsDB<connection_name>();  
$db->query("SELECT article_id,article_title FROM articles");  
$articles = array();  
while ($db->next_record())  
{  
	$a = array();  
	$a["article_id"] = $db->f("article_id");  
	$a["article_title"] = $db->f("article_title");  
	$articles[] = $a;  
}  

Quote wkempees:

I have located the way this works.

$dbcon->seek(nn);

will reset the pointer to the rownumber indicated by 'nn'

$dbcon->next_record()

will fetch the row 'nn'+1

So
$dbcon->seek(15);
$dbcon->next_record()
will fetch row 16 and $dbcon->f('FieldName') will hold the result for row 16.

BUT:
If your while($dbcon->next_record()) loop processes all the rows, then the resultset will be freed, therefore seek() will not position to any row.
Two ways to make your requirement work:
1: break out of the loop BEFORE all rows are processed
2: in db_mysql.php find 'Auto_Free' and set that to 0, default = 1

Method 2 however might have bad implications for the rest of your application, you may have to do a $dbcon->free_result() yourself.
Method 1 is doable in your example

Walter

$dbcon->seek(15);  
$dbcon->next_record()  
//will fetch row 16 and $dbcon->f('FieldName') will hold the result for row 16.  

  
$counter = 0;  
while($dbcon->next_record())  
{  
...  
  
if($counter ==2) {  
$dbcon->seek(5);  
print $dbcon->f("FieldName");  
}  
$counter++;  
}  

  
...  
if($counter ==2) {  
$dbcon->seek(5);  
$dbcon->next_record();  
print $dbcon->f("FieldName");  
}  
...  

  
$counter = 0;  
while($dbcon->next_record())  
{  
...  
print $dbcon->("FieldName");  
...  
if($counter ==2) {  
$dbcon->seek(5);  
print $dbcon->f("FieldName");  
}  
$counter++;  
}