Re: Does not MySql support "Order By" in Select Statement?

The problem is that you cannot have an ORDER BY clause without GROUP BY. -Brian Neal >Date: Fri, 9 Jun 2000 06:52:08 -0400 (EDT) >From: burk@pobox.com >To: Edward Wong <wyuanzheng@21cn.com> >Cc: PHP Database <php-db@lists.php.net> >MIME-Version: 1.0 >Subject: Re: [PHP-DB] Does not MySql support "Order By" in Select Statement? > >On Fri, 9 Jun 2000, Edward Wong wrote: > >> I installed a MySql 3.2 Alpha on Windows 2000, and connected to it within PHP3, but every time I want to select from a table with "order by" suffix, mySql always crashs.(eg: "select * from myTable1 order by Age"), Does not mySql support order by? If then, what's the use of mySql? Or does it own to PHP? >> >> Edward Wong >> >> > >Ordered by is supported. Or at least it works fine on Unix. What error >messages are you getting? > >-burk > > >-- >burk@pobox.com >Linux File Managers: http://www.pobox.com/~burk/linuxfile.html