0

HI, in my project, i have a table 'Orders' with orders submitted, where some have already completed and others are pending,,,
The status of the order is denoted by a status ('completed' / 'pending')

My problem is this,, I need to display the orders separately in two different sections in my form,,, first i retrieved the completed orders and displayed them using a 'while loop'.

Secondly when i tried to display the pending ones, it still displays the completed ones.
I tried to close the DB connection after the while loop and again reconnect and fetch, but still the problem remains.

Then i tried another DB conn with diff variable names, still it displays the older values.(i.e. the completed orders)

Can somebody help me out with this ?

Or else is there a way to clear the existing values in the variable and re-fill them with a new data set ?

2
Contributors
1
Reply
2
Views
6 Years
Discussion Span
Last Post by ﻼim
0

HI, in my project, i have a table 'Orders' with orders submitted, where some have already completed and others are pending,,,
The status of the order is denoted by a status ('completed' / 'pending')

My problem is this,, I need to display the orders separately in two different sections in my form,,, first i retrieved the completed orders and displayed them using a 'while loop'.

Secondly when i tried to display the pending ones, it still displays the completed ones.
I tried to close the DB connection after the while loop and again reconnect and fetch, but still the problem remains.

Then i tried another DB conn with diff variable names, still it displays the older values.(i.e. the completed orders)

Can somebody help me out with this ?

Or else is there a way to clear the existing values in the variable and re-fill them with a new data set ?

would you mind to display here your code that concerns with this problem?
it'll be easier to debug if so. Ϋ

Edited by ﻼim: wrong mark.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.