looping through table more than once.

lil_poop

Hi,

I'm new at PHP and i'm trying to loop through a table twice.

So initially i have the following code:

while($result=mysql_fetch_array($table)) {
....
}

now, i'd like to loop through the same table again, ie- use the same code again.

i know in ASP you can just do a table.MoveFirst to move back to the top, how do i do this in PHP?

thanks in advance!

bretticus

So you can't use:

while($result=mysql_fetch_array($table)) {
....
}

Also, I think you may have the wrong idea about the variables you are working with.

$table in your example would actually be closer to rs in the VBScript:

Set rs = dataconn.execute(sql)

It's actually a result resource and might be more properly labeled $result.

$resultin your example would actually be closer to rows in the VBScript:

rows = rs.GetRows()

Except that all the contents of the recordset are not accesible in this array, thus you use the while loop to create an associate array and use the values in each iteration of your loop.

$table in your example should store the results, so I would theorize you can just run the while loop twice, like above and cycle through twice.

lil_poop

actually, i figured out a way to reset the pointer by using this statement:

mysql_data_seek(cmd, 0);

where

cmd = mysql_query("SELECT * FROM table", db);

and it resets the pointer back to the first dataset.

thanks for your help!

bretticus

Okay, thanks for the heads-up...BUT where you not able to loop through the same result resource twice? I'd be interested to know.

lil_poop

the first time i tried it would not let me, b'c i'd already looped through it with the while loop, so once that was done it was pointing at the last data record. so that mysql_seek function helps to reset the pointer back to the top.