Lorenz
|
| Posted: 05/20/2002, 8:45 AM |
|
Hello,
I have a grid that extract value in a field named 'Year'.
Any 'Year' has the same value in many records.
So, for example, the grid display 7 rows with 1998 , 11 rows with 1999 and so on.
I want to use that grid as a menu where any 'Year' appear only once, so, I can go to another grid displaying records associated.
I use PHP 4.0
Thanks in advance (sorry for my english :) )
|
|
|
 |
Tom
|
| Posted: 05/20/2002, 12:36 PM |
|
Try using a sql statement for the grid instead
SELECT DISTINCT YEAR from mytable
or you may be able to use a group by function
Select count(*), year from mytable group by year
|
|
|
|
Nicole
|
| Posted: 05/21/2002, 2:15 AM |
|
Lorenz,
try to split grid into two forms. The one should list years (use one of custom queries proposed above for Year Menu form) in one grid form. Add year as output parameter to Year url field and specify Year as Input parameter in second grid.
|
|
|
|
|
