Multiple Table Posts based on Date - Explanation inside

TpupAZ

Here's a question. I've tried googling this and I've tried researching problems similar to this, and have been unable to find anything up to this point.

Based off my peers, I've always learned that you research before you ask, because not using the search function can get you a quick smack in the head heh.

I have a db with 7 tables, each table is for each corresponding day of the week.

So on Monday, I would want the query to work for database.table1 and on Tuesday, it would work with database.table2 and so on.

table1 -- table2 -- table3 -- table4 -- table5 -- table6 -- table7

| |
|-------------------------------|----------------------------------------|
|

I know the queries I want to write and can get that part of the code to work, as I'll be doing totals from the queries, row totals, sum totals, and also some queries based off sorts of the data.

My question is, if anyone knows, is how I can get the queries to dynamically work , based on the day of the week.

My first guess would be is that some sort of conditional loop that would work based off the idea.

if (day = Mon){

$tablevariable = datablase.table1

}

etc etc etc.

Anyone have an idea to get me going? Thanks!!!

devinemke

you can use the [man]date[/man] function to return the current day of the week. is there a particular reason that you are using 7 separate tables and not just 1 with a DATE field?

TpupAZ

Actually what I did was similar, I made a conditional statement to check the day of the week using getdate(), and then set the variable of the db table name based off that.

The reason why I'm using 7 tables is because within 3 weeks, all 7 tables will have 18,000,000 each records and need to be dumped. If we had it all in one table, we'd have to do a dump almost every day or two.

Consider RESOLVED.

Thanks much. I hope to start GIVING some help here, and stop asking lol.

🙂

devinemke

TpupAZ wrote:
The reason why I'm using 7 tables is because within 3 weeks, all 7 tables will have 18,000,000 each records and need to be dumped. If we had it all in one table, we'd have to do a dump almost every day or two.

you are still dumping the same number of rows whether they are in 1 table or spread accross 7. seems like 1 table would be easier to maintain.