Re: displaying a rowset in php...same column names

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



On Wed, 2004-01-07 at 05:09, Michael Hanna wrote:
> This query: SELECT login, firstname, lastname, date_part('epoch',  
> lastlogin), date_part('epoch', regdate) FROM admin ORDER BY login
> results in:
> 
>     login   |    firstname     |    lastname     |    date_part     |     
> date_part

SELECT foo as bar,bar as foo from footable

notice the "as" thingie. It would help.
-- 
 __________
|          |
|          |  Enver ALTIN (a.k.a. skyblue)
|          |  Software developer, IT consultant
|    FRONT |
|==========|  FrontSITE Bilgi Teknolojisi A.Ş.
|_____SITE_|  http://www.frontsite.com.tr/

Attachment: signature.asc
Description: This is a digitally signed message part


[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux