![]() |
| ||
| A few things i dont understand OK im nealry done with my database but i am stumped on these two things: 1. a list of bookings every saturday to saturday, so u put in a date in a query and it shows all data within 1 week of that date 2. Monthly calculation on the -total money taken for occasional bookings -and the percentage usage, based upon data i have inputted, 21 slots how to work it out Many thxs :) |
| ||
| Re: A few things i dont understand That very much depends on how you have structured your database and you don't give that info. for #1 I'd recommend you pass MySQL (etc) the actual dates for the query rather than leave it to work it out. Only a few extra lines in your script and faster in the database. |
| All times are GMT -4. The time now is 7:51 am. |
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC