is a result pointer an object?

Codewalkers Forums Sponsor:

You eat, breathe and sleep innovation. Build your mobile intelligence with BlackBerry® experts this July. Register Today!

May 8th, 2003, 07:49 AM

Smoker

Join Date: Apr 2007

Posts: 14

Time spent in forums: < 1 sec
Reputation Power: 0

is a result pointer an object?

I want to set back the internal result pointer from a mysql_query by one. I looked at the code behind mysql_data_seek and it seems that when you do a select in a mysql_query it returns a linked list of some sort. when you call mysql_data_seek it traverses the linked list x times where x is the specified offset. Does anyone know how this is set up. I just want to move the pointer backwards one.
The code i tried was
$result = mysql_query('SELECT * ...');
mysql_fetch_row($result);
$result->data_cursor = $result_array->data->data->prev;
$result_array->current_row = 0;

This doesnt work but, this is similar to how mysql_data_seek works.

---Moved From PHP To Database help by Postalcow---

May 8th, 2003, 01:05 PM

xs0

Join Date: Apr 2007

Location: Ljubljana, Slovenia

Posts: 760

Time spent in forums: < 1 sec
Reputation Power: 2

RE: is a result pointer an object?

I don't think you can go back in PHP. But why not store the data in an array, and then you can access it in whatever way you want?

php Code:

Original - php Code
$result=mysql_query("SELECT ..."); $resultset=array(); while ($line=mysql_fetch_array($result)) $resultset[]=$line; echo $resultset[5]["somefield"]."<br>"; echo $resultset[2]["someotherfield"]."<br>"; echo "There are ".sizeof($resultset)." rows";

 
$result=mysql_query("SELECT ...");
$resultset=array();
while ($line=mysql_fetch_array($result))
    $resultset[]=$line;
 
echo $resultset[5]["somefield"]."<br>";
echo $resultset[2]["someotherfield"]."<br>";
echo "There are ".sizeof($resultset)." rows";

Viewing: Codewalkers Forums > Other Technologies > Database Help > is a result pointer an object?

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump