need hlp selecting everything from database.

runelore

Hi, i have multiple databases and i need to be able to quickly check if there is any data stored in any of the tables within each database, How do i do this? You can't just do a
"SELECT FROM "
and that is what i need to do, please help... thanks..

stolzyboy

how many tables are we talking about?

runelore

Hi, I am working on a databased event calenday and every day withing the month has 18 slots (more like an hourly diary) so basically when the calendar loads up i wanna be able to check if any events have been added to a certain date and shade the date a different color but I need to be able to do likea search on all 31 tables (the days of the month) within the database (the particular month). my database structure is as follows..

datebase (the month., eg.. jan.. feb..)

runelore

add to post above.....

tables (the day of the month)
fields (all teh events divided into times..) i hope you understand this.. thanks for replying....

Lars_Berg

Scratch that design and restart. It is not tenable.

Use one table for storing events.

runelore

Ok thank.s I was jus trying to simplyfiy things too much, thanks for you opinion. I will do just that..