PHPBuilder: SQL Theory & How-To | ServerWatch

PHPBuilder: SQL Theory & How-To

Jul 20, 2010
ServerWatch content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More



“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.

ServerWatch Logo

ServerWatch is a top resource on servers. Explore the latest news, reviews and guides for server administrators now.

Property of TechnologyAdvice. © 2026 TechnologyAdvice. All Rights Reserved

Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.