reset() an array

dast

I want to reset an array, but this following code isnt working!


		   while($row = pg_fetch_array($result)) {
    		extract($row);
    		echo "<option value=$user_id>$fullname</option>";
			reset($row);
    		}

tasistro

By reset you mean clear the contents of the variable? If so try

unset($row);

Weedpacket

...Not that it would be necessary, because
(a) the $row would be replaced by the next row from the result a moment later any way,
(b) There's no traversing the contents of the $row array anyway.

So what does "code isn't working" mean? It's marching up and down outside the front gate waving placards?

dast

Yeah its sorta gone on strike. I have two dropdowns using the same array, one wont work without the other one being reset, but everything i try i have no luck 🙂

wisskid

I don't think you need to reset $row. It will be overwritten nicely when it is tested again in the while condition.

However, you may need to reset the pointer in the $results array, or indicate a specific row to fetch:

This will return values from 2 rows:

$arr = pg_fetch_array ($result, 0);
echo $arr[0];

$arr = pg_fetch_array ($result, 1);
echo $arr[0];

While this will return values from 1 row:
$arr = pg_fetch_array ($result, 0);
echo $arr[0];

$arr = pg_fetch_array ($result, 0);
echo $arr[0];

Haven't tested it though...
😕

Weedpacket

Originally posted by dast
Yeah its sorta gone on strike. I have two dropdowns using the same array, one wont work without the other one being reset, but everything i try i have no luck 🙂

Oh, so it's the result set you want reset. Gee, I dunno; if I ever find I'm going to use a result set twice I put the whole result set into a single array and then use the array both times (actually, I often do that even if I'm only going to be using it once). Let's toddle over to the manual and see if there's anything mentioned there...

Dee dee dee...

Hm. Bit brief, but [man]pg_result_seek[/man] sounds promising. With an offset of 0.