Dynamic select statement

[mambolim]

Hi guys,

I need to find an answer to this as I am coding between PHP and Postgresql.

$vara=(a string value selected by user);

Now I want to do a select statement based on $vara, but

$sqlc=pg_query("SELECT '$vara' FROM table1 WHERE empid='$empid'");
$sqlarr=pg_fetch_array($sqlc);

This query will return only 1 row and I only need the value of the column $vara specified by the user. However this doesnt work at all and I do not know how to extract the value of the resulting array, how do I do that?

[mrhappiness]

if $vara holds the column's name try

$sqlc=pg_query('SELECT '.$vara.' FROM table1 WHERE empid='.$empid);

[mambolim]

Thanks a lot! I found a way too.

$vara=(user selected column);
$count=0;
$sqlc=pg_query("SELECT * FROM table1 WHERE empid='$empid'");

$varb=pg_fetch_object($sqlc,$count);

$colval=$varb->$vara;

That was how I got the value of a certain column selected by the user at row 0. If you wish to get that column for more rows, a loop should do the job 😃