Page 1 of 1

ResultSet Problem??

Posted: Fri Feb 07, 2003 3:09 pm
by Sully
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

Posted: Mon Feb 10, 2003 2:44 am
by twigletmac
Could we see a bit more of your code - I'm a little confused by what you're trying to do.

Mac

Posted: Mon Feb 10, 2003 3:04 am
by twigletmac
Please don't cross-post, there really is no need and it just ends up with people trying to help you who have no idea what others have already said.

Anyone wishing to help:
viewtopic.php?t=6305&view=next

Mac