multi selections in one query, how?
I'm building up my home page right now with php and I have alot of information that I want it to be in my homepage. I've made all of the requirements and it's working fine now but I feel it's very have to be loaded because of the queries in the homepage. What I'm thinking of is how to make multi selections in one query?!! That is to say, can I select different columns from different tables in one query???? And how???
one more thing, doesn't that over load my server as many of users surfing in my site? And how many queries do you think are suitable to be in one page?
Alot of questions need to be answered from my best friends :)
Any help would be highly appreciated in advance