PHP form submission from results of a report

[j.smith1981]

I have quite a heafty problem here.

 

I am trying to develop a system here, thats quite flawed at the moment.

 

We print off a picksheet from a Browser, it has Order ID's, of course displayed in the picksheets.

 

When we print them out we set orders as completed.

 

Using a hidden form it sets them as completed through pressing a button and submitting an SQL query that basically says:

 

Complete all orders from orders table where current status is equal to P (P for processed).

 

But, the problem is, if any orders do come through from printing them out to setting them as completed, we could miss an infinate number of orders.

 

Can I get the order id's displayed to set as an SQL query to make the complete all (displayed) orders only complete the orders in the web browser window?

 

This would be the most effective way of doing this I would have thought.

 

Kind regards and I look forward to anyones reply in advance,

Jeremy.

[j.smith1981]

I have worked out the theory now.

 

When your presented with a results page of orderid's is there any means of saving all the retrieved order id's.

 

Say we have 2 orders yea?

 

Order id 1 which presents the user with the values they want for the order to be processed.

 

Same with orderid.

 

But they wait 30minutes before completing it (before submitting the order on the database).

 

Yet another order comes in orderid3.

 

At the moment, the user would click the button complete all and would end up missing off orderid3, is there any means (as we are using smarty part of X Cart 4.11), by making PHP somehow cache these results or save them somewhere to just process those orders, ie orderid1 and orderid2?

 

I am a bit stuck with this, I think this clears any confusion people might have been having.

 

Just cant get my head around how to achieve this, any help please?

 

Regards,

Jeremy.