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 :)
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.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.