abz
Gold Member
Am using MySql and i need to get a loop to list categories from an array (done that), retrieve data from a table based on the day rather than the date (done that), but somehow need to get it to display all the days within a date range, with the correct dates next to the weekday and within the correct categories...
hang on...
For i = LBound(ArrayCat) to UBound(ArrayCat)
Response.Write ArrayCat(i) & "<br>"
For j = LBound(ArrayWeek) to UBound(ArrayWeek)
response.write "<br>" & ArrayWeek(j) & "<br>"
that is my current loop where ArrayCat is the category array and i started with the weekdays in arrayWeek. but i need to replace those as every monday in the date range is being displayed in the same place instead of many weeks in date order... does that make any sense at all??
hang on...
For i = LBound(ArrayCat) to UBound(ArrayCat)
Response.Write ArrayCat(i) & "<br>"
For j = LBound(ArrayWeek) to UBound(ArrayWeek)
response.write "<br>" & ArrayWeek(j) & "<br>"
that is my current loop where ArrayCat is the category array and i started with the weekdays in arrayWeek. but i need to replace those as every monday in the date range is being displayed in the same place instead of many weeks in date order... does that make any sense at all??