Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Dave Lantz: "I have to say that I simple love this product and its ease of use. I know that I have only tapped into about 20% of what it can do. In my business I come into a lot of contact with developers and I tell them all, that if they need an easy way to connect, report or work their databases they MUST check out your products".
Rickey Steinke: "Folks, I wanted to drop a line and give you a fanatic thank you. I have a project due for my computer application course and without PHP Generator I never would have gotten it done with the professional results your product produced. My sincerest gratitude to each and every team member who brought this program to light".


Add your opinion

PHP Generator for MySQL online Help

Prev Return to chapter overview Next


To reduce the number of records available at the page, specify the Filter condition. This condition corresponds to the WHERE clause of the query returned page data (you must not add the WHERE keyword to beginning of the condition).


Example 1

There is a table with test questions of a Web programming course. To display only questions of the 'Beginner' level (level_id = 2) concerning to PHP (statement_language_id = 1), set the filter condition as follows:




Example 2

You can use subqueries in the filter expression. For example, to display the list of channels that hosted even if a single game, specify the Filter condition as follows:


( > 0) AND IN 


  SELECT game.channel_id 

  FROM game


Prev Return to chapter overview Next