laek

Every time that a visitor loads a page, it would hit the database once to grab the content in one query. Right now I'm playing with UNION queries instead of JOINs, but i'm running into the problem with UNIONs in this situation is that the database does not allow me to have different amounts of columns like a JOIN does. Is there a way to run a query like: SELECT profileID, details1, details2, details3 FORM linkRel where profileID='0' UNION SELECT profileID, details1, details2 FROM metaTag where profileID='0' UNION SELECT profileID, details1 FROM pageTitle where profileID='0' ? I think I over-explained it before, if I can get this query down, i can get the rest. Thank you, -Lake

I have been banging my head against the wall for the last few days with this. My problem is that I am writing a PHP website that grabs content from a database (basically a content management system, or CMS) for my job. I want the database to be dynamic so if we have to add new types of content to the website, I don't have to recode a large chunk of the PHP to work with it. I also want the pages to load quickly, since dial-up users often visit the website, and I want to cater to them as well - and hey, who doesn't love a web page that loads quick? The best way I can think of to do this is to do two queries on the database, the first would send the page name to a 'landing table' then return a profileID for that specific of page. Then I want to query the database with something like Here is a few examples of tables of the database i am thinking about using: