Please support our Database Design advertiser: Programming Forums
Views: 1100 | Replies: 1
 |
•
•
Join Date: Mar 2006
Posts: 4
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
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
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
•
•
Join Date: Apr 2005
Location: Auckland, New Zealand
Posts: 136
Reputation:
Rep Power: 4
Solved Threads: 1
Junior Poster
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.
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.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
