Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
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".

More

Add your opinion

PHP Generator for MySQL online Help

Prev Return to chapter overview Next

Filter

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:

 

(channel.id > 0) AND channel.id IN 

(

  SELECT game.channel_id 

  FROM game

)



Prev Return to chapter overview Next