A few things i dont understand

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 391,548 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,566 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Database Design advertiser:

Thread Tools Display Modes

Views: 1009 | Replies: 1

•

Join Date: Mar 2006

Posts: 4

Reputation: ROB04050916 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

ROB04050916 ROB04050916 is offline

Offline

Newbie Poster

A few things i dont understand

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

•

Join Date: Apr 2005

Location: Auckland, New Zealand

Posts: 136

Reputation: sarahk is an unknown quantity at this point

Rep Power: 4

Solved Threads: 1

sarahk

Offline

Junior Poster

Re: A few things i dont understand

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.

Vote for DaniWeb
Sarah's SEO Blog