mavtech
Posts: 133
|
| Posted: 11/29/2004, 3:02 PM |
|
I have a radiobutton with dates in it. It is a part of a grid list. And I have had to use the prepare to filter out the dates that are associated with the product.
Grid is based on Products but dates are not in that table.
Looks like:
Product Name o date1 o date2 o date 3 price
I can filter dates based on only future dates but what I want is future dates but I want the number of radiobuttons to only handle the first 6 dates in list thus making the list look symetrical.
how do I count the radiobutton entries and then set it so only the first 6 display.
Paul
|
 |
 |
Damian Hupfeld
|
| Posted: 11/29/2004, 8:58 PM |
|
How do you filter your dates to show only future dates?
Damian http://www.itng.com.au/services.php
|
|
|
 |
mavtech
Posts: 133
|
| Posted: 12/09/2004, 12:37 PM |
|
Sorry for delay.
$Products1->dates->ds->Where = " dates.product_id=" . $Products1->Products_ID->GetValue() . " AND SUBDATE(CURRENT_DATE(), INTERVAL 1 DAY) < dates" . " AND SUBDATE(CURRENT_DATE(), INTERVAL -120 DAY) > dates";
$Products1->dates->Prepare();
It seems to work but I want to just put a max of 5 dates
|
 |
 |
|