Hey,
How do you manipulate the data in a database so you can, say, call only the latest 5 entries. I want to do something similiar to what phpbuilder has done with their forum listings on the first page.
Also- I have a database table for a calendar program, and I want to be able to list the 5 events that the next up and coming. The calendar supports day-spanning, so there is a start date column (in yyyy-mm-dd format) and an end date column (same format). How do you evaluate the DB data to determine if there is an event that day and the next 5 events, according to the dates? Also- this set up would have to evaluate based on days&date not on number of rows to call, because there could be, say, 6 events on one day, and I don't want to limit the events shown in the preview to 5.
Thanks,
Jeof
How do you manipulate the data in a database so you can, say, call only the latest 5 entries. I want to do something similiar to what phpbuilder has done with their forum listings on the first page.
Also- I have a database table for a calendar program, and I want to be able to list the 5 events that the next up and coming. The calendar supports day-spanning, so there is a start date column (in yyyy-mm-dd format) and an end date column (same format). How do you evaluate the DB data to determine if there is an event that day and the next 5 events, according to the dates? Also- this set up would have to evaluate based on days&date not on number of rows to call, because there could be, say, 6 events on one day, and I don't want to limit the events shown in the preview to 5.
Thanks,
Jeof