Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B5E98475BD7 for ; Fri, 29 Nov 2002 07:12:14 -0500 (EST) Received: from nplex.globo.com (email.globo.com [200.208.9.53]) by postgresql.org (Postfix) with ESMTP id 34B54475AFF for ; Fri, 29 Nov 2002 07:12:14 -0500 (EST) Received: from [200.219.69.252] by nplex.globo.com with HTTP; Fri, 29 Nov 2002 10:11:45 -0200 Date: Fri, 29 Nov 2002 09:11:45 -0300 Message-ID: <3DCBFE2200096F30@riosf06.globoi.com> From: angelo.rigo@globo.com Subject: Simple query To: pgsql-php@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-15" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/91 X-Sequence-Number: 1673 I am having this problem: i have a calendar wich i order by day and the time i do display like this format: 10h30min. this is my query: $query =3D "SELECT city, state, location, day, month, time, event FROM agsh= ow where ((mes=3D11)) ORDER BY dia ASC"; So when i have two presentations on the same day the 15h30min presentation wad listed after the 21h presentation Wich query can i write to organize properly? and the time format is ok? or i have to change it to be readed properly? thank?s =C2ngelo Rigo ________________________________________ A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com= .br.