Using column alias with PostgreSQL within PHP

Question

When a column alias was used like below to get data from PostgreSQL, the PHP code doesn't run. However, when I don't use column alias, then the PHP code works so I know that my PHP code is correct. Is there a way to make column alias works from PostgreSQL and within PHP framework?

$SQL1 = "
SELECT count(distinct emcas_gbo_gs.w_customer_d.cust_id) as "CNT"
FROM emcas_gbo_gs.w_customer_d 
";

$dataQuery1 = pg_query($mycon, $SQL1) or die('Query failed: ' . pg_last_error());
$dataCnt1   = pg_fetch_result($dataQuery1,0,'CNT');

Filipe Silva · Accepted Answer · 2013-12-05 00:36:35Z

1

If you look at the code in your question and the way Stackoverflow formatted it you can see that CNT is not inside the string.

You should simply remove the doublequotes around CNT:

$SQL1 = "
SELECT count(distinct emcas_gbo_gs.w_customer_d.cust_id) as CNT
FROM emcas_gbo_gs.w_customer_d 
";

answered Dec 5, 2013 at 0:36

Filipe Silva

21.7k6 gold badges56 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3068093 Over a year ago

Double quotes were removed and the PHP code works. Thank you for the solution!

Collectives™ on Stack Overflow

Using column alias with PostgreSQL within PHP

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related