Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Grey: "We're a two-person company, it's just me an my wife. I'm the technical guru, and she handles the business operations. I have to know a lot about MySQL, but that's much too technical for her. I have frequently had to setup CGI scripts (I code in Perl) so she can manage some of our tables (suppliers, manufacturers, etc).

I discovered PHP Generator a couple of days ago, tried the free version,and within a few hours I had purchased the Pro version (as well as SQL Maestro for MySQL).

Today I am completing the conversion of the last of my custom table managers to PHP Generator. This is eliminating several thousand lines of code that I don't have to support any more!

Thanks for this fantastic product".

Mike Little: "Great product, thank you for your great work and sharing".


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