what will be my outcome in this situation?
Posted: Sun Nov 05, 2006 3:07 pm
lets say:
i know exactly how to make the events that occur at 10:20AM and 10:21 happen. no problem.
but, at 10:22AM, when user-A wants his alphabetic sort of his 10:20AM query, i need to know what my options are.. will:
- the 10:20AM query persist in "memory" of SQL... then my PHP script can somehow be programmed to access the 10:20 results (saved in SQL "memory"), sort them accordingly, and then return the results to be printed out on some web page
OR is it more like:
- in order to have any more access to the results of the 10:20AM query, you have to save the results into something (an array for instance), and then *somehow* pass the array from current PHP page to the next PHP page that will do the sorting. all this because SQL (when being talked to from PHP) can only be referenced in "instances", and not as a "session"
... this is as well as i can put my question. please help!
So......example wrote:@ 10:20AM DATABASE_1 has TABLE_1 with five records:
(format: "record number" = "value")
1=one
2=two
3=three
4=four
5=five
6=six
7=seven
8=eight
9=nine
10=ten
@ 10:21AM DATABASE_1 updates TABLE_1:
1-one
2-two
3-three
4-four
5-five
6-unos
7-dos
8-tres
9-quatro
10-cinco
@ 10:22AM, USER-A wants to sort the results of his 10:20AM query of TABLE_1 alphabetically.
i know exactly how to make the events that occur at 10:20AM and 10:21 happen. no problem.
but, at 10:22AM, when user-A wants his alphabetic sort of his 10:20AM query, i need to know what my options are.. will:
- the 10:20AM query persist in "memory" of SQL... then my PHP script can somehow be programmed to access the 10:20 results (saved in SQL "memory"), sort them accordingly, and then return the results to be printed out on some web page
OR is it more like:
- in order to have any more access to the results of the 10:20AM query, you have to save the results into something (an array for instance), and then *somehow* pass the array from current PHP page to the next PHP page that will do the sorting. all this because SQL (when being talked to from PHP) can only be referenced in "instances", and not as a "session"
... this is as well as i can put my question. please help!