X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 9A8C0D1B47F for ; Wed, 7 Jan 2004 11:15:22 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 83512-09 for ; Wed, 7 Jan 2004 07:14:34 -0400 (AST) Received: from skyblue.office.frontsite.com.tr (unknown [195.174.8.176]) by svr1.postgresql.org (Postfix) with ESMTP id D8F84D1B450 for ; Wed, 7 Jan 2004 07:14:27 -0400 (AST) Received: by skyblue.office.frontsite.com.tr (Postfix, from userid 1000) id 0E3FB63095; Wed, 7 Jan 2004 13:14:34 +0200 (EET) Subject: Re: displaying a rowset in php...same column names From: Enver ALTIN To: Michael Hanna Cc: pgsql-php@postgresql.org In-Reply-To: References: <71B8A8BEC516CF46835CA629156CF21163F6EE@bedford.idacorp.local> <200312291402.35789.scrawford@pinpointresearch.com> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-m9xbbsBhuKPbDv0RqSZJ" Organization: FrontSITE Bilgi Teknolojisi A.S. Message-Id: <1073474074.31454.3.camel@skyblue.office.frontsite.com.tr> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Wed, 07 Jan 2004 13:14:34 +0200 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/3 X-Sequence-Number: 2519 --=-m9xbbsBhuKPbDv0RqSZJ Content-Type: text/plain; charset=iso-8859-9 Content-Transfer-Encoding: quoted-printable On Wed, 2004-01-07 at 05:09, Michael Hanna wrote: > This query: SELECT login, firstname, lastname, date_part('epoch',=20=20 > lastlogin), date_part('epoch', regdate) FROM admin ORDER BY login > results in: >=20 > login | firstname | lastname | date_part |=20= =20=20=20=20 > date_part SELECT foo as bar,bar as foo from footable notice the "as" thingie. It would help. --=20 __________ | | | | Enver ALTIN (a.k.a. skyblue) | | Software developer, IT consultant | FRONT | |=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D| FrontSITE Bilgi Teknolojisi A.=DE. |_____SITE_| http://www.frontsite.com.tr/ --=-m9xbbsBhuKPbDv0RqSZJ Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQA/++oaZCB2FZvqK0sRAu2BAJ49w67SpDyd71AydY93cMTaD/NRFQCfaSFY e5UvLvwS52P0tsKB6fHYPng= =ScyY -----END PGP SIGNATURE----- --=-m9xbbsBhuKPbDv0RqSZJ--