ResultSet Problem??

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Locked
Sully
Forum Newbie
Posts: 2
Joined: Fri Feb 07, 2003 3:08 pm
Location: Ireland

ResultSet Problem??

Post 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
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Could we see a bit more of your code - I'm a little confused by what you're trying to do.

Mac
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
Locked