Need Help With Getting values From a PHP Function

[surprino]

Hi Guys 

 

I am a rookie here... I have a function which gets information from a postgres database. And returns an array. But how do I echo a single value from the array returned by the function. Please see function below:

 

function getDate($campid)

{

        global $conn,$agencies;

        $return=array(

'date'=>'',

);

 

        $sql = "SELECT tsc_date_completed FROM tasks_completed WHERE campid = '".$campid."' AND tsk_id = 10 ORDER BY id DESC LIMIT 1";

 

        $r = pg_query($conn,$sql);

        if ($r)

        {

                $d = pg_fetch_array($r);

                if (!empty($d))

{

$return['date'] = $d['tsc_date_completed'];

}

        }

        @pg_free_result($r);

 

        return $return;

}

Edited October 29, 2014 by surprino

[Barand]

$result = getDate($campid);

echo $result['date'];

If you only ever get a single date, why return an array?