I know how to get all the data from the database. Once I have all the data, I want to loop through the data and look for just the one I want? please help with code!
why loop through all the data if you only want something in perticular......just get the data you want and not all of it<BR><BR><BR><BR>try <BR><BR>select * from TableName where ColumnName = TheDataYouWant<BR><BR>
Because the data changes from date to date and I wanted the most recent records. Therefore getting all the data to the page, I can show the current date, the next current date and so on.<BR>
so let your where clause do that for you<BR><BR><BR>
how is it exactly, when the data in the database is changing, and I want the recent one, not the current one?
you want current data, whenn you run the statement with the where clause getting the latest data, YOU GET ONLY THE RECENT data<BR><BR><BR><BR>