PHPBuilder: SQL Theory & How-To

“I try and wade through as many postings on PHP General as possible throughout
the day. Everything from “What does 20573var mean?” to “How to I redirect someone to
another page?” pop up. Two common problems pop up on the list frequently, one is
“How do I build complex queries on the fly?”, and the other is the problem of how to
fully utilize all those cool features in your DB.”

“So here is what I plan to tackle in this article:

1.) Creating complex, powerful, queries to take advantage of your table schemas

2.) Building those queries on the fly according to user input”
Two common problems pop up on the list frequently, one is ‘How do I build complex queries on the fly?’, and the other is the problem of how to
fully utilize all those cool features in your DB.