News from the Editor

MySQL 5.0.12 JOIN's changes in syntax.

Posted by Administrator (admin) on May 04 2007
News from the Editor >> Program

From version 5.0.12, MySQL has made some changes in their JOIN's. This is related to multiple tables. We have found a free alternative demo site with MySQL 5.0.38. You can now try the script in this environment together with PHP 5.2.2RC3.

As this is a free Webhost,, we have to live with a commercial banner below each pages.

You can, of course, too create a free account at this Webhost. If you don't want the banner below each pages, you can pay for a year, $12. Not much, but we prefer the free one.

This is what you get if you sign up with them:

----- from their heading -----

Our professional Web Hosting plans include all the features you are looking for at the best possible price - Absolutely Free

200 Mb Web Space
Hosting Control Panel
Fantastico Type Installer
File Manager
Fast Clustered Web Servers
Unlimited Data Transfer
PHP and  MySQL Enabled
Free Sub-Domain Address
Free FTP Access
Free MySQL Databases
Instant Activation
No Maximum File Size
No File Type Restrictions


------end of heading-------

The php_info() reports among other this info:

  • Apache 2.0
  • PHP 5.2.2RC3-dev
  • MySQL 5.0.38
  • GD 2.0.34
  • GetText enabled
  • LibXML active (we need that in the future. Most webhosts have this active)

The only drawback, that we saw, was that the email feature of documents didn't work, but this should work in the paid version. We can live with that. We know it is working under normal circumstances..

We will now try to find a free Windows host, to test the script in. This seems to be quite difficult .


Last changed: May 04 2007 at 8:56 am


Support This Project