A few things i dont understand

Reply

Join Date: Mar 2006
Posts: 4
Reputation: ROB04050916 is an unknown quantity at this point 
Solved Threads: 0
ROB04050916 ROB04050916 is offline Offline
Newbie Poster

A few things i dont understand

 
0
  #1
Apr 17th, 2006
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
Reply With Quote Quick reply to this message  
Join Date: Apr 2005
Posts: 138
Reputation: sarahk is an unknown quantity at this point 
Solved Threads: 1
sarahk's Avatar
sarahk sarahk is offline Offline
Junior Poster

Re: A few things i dont understand

 
0
  #2
Apr 17th, 2006
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.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the Database Design Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC