DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/)
-   Database Design (http://www.daniweb.com/forums/forum142.html)
-   -   A few things i dont understand (http://www.daniweb.com/forums/thread43484.html)

ROB04050916 Apr 17th, 2006 6:46 am
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 :)

sarahk Apr 17th, 2006 10:15 pm
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