Parser produces errors on query parse about php-sql-parser HOT 5 CLOSED

Try current version on

https://www.phosco.info/publicsvn/php-sql-parser/tags/20120301

This version doesn't generate an error, but the output is not valid, because of 
a keyword "view", which you use as alias. I will look into the code as soon as 
possible.

Thanks for the quick response! This version looks to have quite a few changes 
from the one I had before...
As you said, the new one does not error out, but it still produces a notice:
PHP Notice:  Uninitialized string offset: 0 in 
/media/sf_test/php-sql-parser.php on line 879
When I change the view/click aliases to views/clicks, no notice.

Oh, this is because the alias "view" is not available as alias (it is 
recognized as keyword). It is an aftereffect.

I have fixed that specific problem. The parser will check now the previous 
tokens, if the token VIEW occurs. There must be ALTER, CREATE or DROP just 
before VIEW. If you use other keywords, some other problems will occur. The 
only way to solve that more generic, is to develop a validating parser, which 
uses a grammar. This parser uses a brute force method to find keywords and 
split the statement, so every "wrong used" keyword breaks the parser. Check out 
the bleeding edge on

https://www.phosco.info/publicsvn/php-sql-parser/trunk

There is a test case for this issue (see current version on Google.Code).