ResultSet Problem??
Posted: Fri Feb 07, 2003 3:08 pm
Hello All,
I am having alot of trouble trying to append a result set using a loop. I am taking a number from options from a select option list in a form and for each of these i want to execute the statement.
for($y=0; $y<$totaltown; $y++) {
$result=select statement
}
and then out put the info using a while loop.
My problem is the result set keeps overwriting itself until it produces 0 results.
I have tried using $result+=$result but it is then no longer a ersult set. The code i have works fine when i only want to produce all hte results on one page but i am paging the results which is where my problem lies ie LIMIT.
I would appreciate any help as i have hit the wall with it.
Many Thanks
Sully
I am having alot of trouble trying to append a result set using a loop. I am taking a number from options from a select option list in a form and for each of these i want to execute the statement.
for($y=0; $y<$totaltown; $y++) {
$result=select statement
}
and then out put the info using a while loop.
My problem is the result set keeps overwriting itself until it produces 0 results.
I have tried using $result+=$result but it is then no longer a ersult set. The code i have works fine when i only want to produce all hte results on one page but i am paging the results which is where my problem lies ie LIMIT.
I would appreciate any help as i have hit the wall with it.
Many Thanks
Sully