[Resolved] fetch a row without incrementing

Mucello

I'm working on a project that will query the database, get some data, and display it in a nice little html table. No problem... that's done. The way I do that is by mysql_fetch_assoc and loop through each row. no problem so far.

What I want to accomplish is read the FIRST row and the LAST row from the database before entering the loop that reads all rows.

I've tried using the mysql_fetch_row and a few other variations thereof, but they all seem to increment the internal pointer so that when I go into my loop, it's not starting from the beginning.

How can I accomplish this? Looping through them all is easy, no prob. But
I want to fetch the FIRST and LAST row from my query, and THEN proceed to loop through them all.

tbach2

A couple of thoughts:

put the values in an array, pull out $array[0] for first row, $array[sizeof($array)] for last row. Then iterate through the array when you want to print.
use a template such a phplib.

Mucello

Thanks for the quick response. Putting the data into an array is a good idea, but the array would be huge. I'm looking at the potential for thousands of rows of data so I don't want to use any more memory than I have to.

Is there a way to move the internal pointer of mysql_fetch_assoc back to the beginning, similar to that of reset() with arrays?

HalfaBee

Have a look at www.php.net/mysql_data_seek

HalfaBee

Mucello

mysql_data_seek is exactly what I needed🙂 Thanks🙂

Just for future reference, in case anyone ever has the same problem, this is what I did:

mysql_data_seek($result_data,0);   // move pointer to beginning
$startDate = mysql_fetch_array($result_data);  // get first row
mysql_data_seek($result_data,$number_results-1);  // move pointer to last row
$endDate = mysql_fetch_array($result_data);  // get last row
$startDate = $startDate['ob'];
$endDate = $endDate['ob'];
mysql_data_seek($result_data,0);  // move pointer back to beginning