PunBB Forums - DB lookup question

Re: DB lookup question

dummy@example.com (MattF) — Mon, 31 Dec 2007 14:55:23 +0000

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

dummy@example.com (elbekko) — Mon, 31 Dec 2007 14:44:28 +0000

Whoops, I gave you the MySQLi one

For regular MySQL it would be:

mysql_data_seek($result, 0);

Re: DB lookup question

dummy@example.com (MattF) — Mon, 31 Dec 2007 02:03:12 +0000

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

dummy@example.com (elbekko) — Sun, 30 Dec 2007 19:50:19 +0000

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

Re: DB lookup question

dummy@example.com (MattF) — Sun, 30 Dec 2007 18:46:23 +0000

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

Thanks again,

Matt

Re: DB lookup question

dummy@example.com (elbekko) — Sun, 30 Dec 2007 18:43:05 +0000

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

dummy@example.com (MattF) — Sun, 30 Dec 2007 16:47:58 +0000

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