PunBB Forums - DB lookup question

Re: DB lookup question

2007-12-31T14:55:23Z

Thanks again. Just cross referenced that one to the pgsql variant:

pg_result_seek($result, 0);

and it works an absolute treat.

Re: DB lookup question

2007-12-31T14:44:28Z

Whoops, I gave you the MySQLi one

For regular MySQL it would be:

mysql_data_seek($result, 0);

Re: DB lookup question

2007-12-31T02:03:12Z

Just making sure I'm not missing the gist on that link. So effectively, calling:

$result->data_seek(0);

would reset the pointer back to zero so that a later fetch_assoc in a while loop would start from the beginning again?

Thanks again,

Matt

Re: DB lookup question

2007-12-30T19:50:19Z

http://be.php.net/manual/en/function.my … a-seek.php

Re: DB lookup question

2007-12-30T18:46:23Z

Cheers. Just one last question. How does one reset the pointer?

Thanks again,

Matt

Re: DB lookup question

2007-12-30T18:43:05Z

It'll get the current row and advance the internal resultset pointer by one. You can reset that pointer so you can use the thing again later on.

DB lookup question

2007-12-30T16:47:58Z

If one has a db query/lookup which will return multiple rows, would the following just return the required item from the first row of the result all or rows?

list($lastpost) = $db->fetch_row($result);

Result is a lookup which is ordered by last post, so the first row has the last post info I require, but I'm not quite sure if the above will work as I think/expect. Plus, running that command would still leave all the info in result as is, to be used in a while loop later on?

Thanks again,

Matt