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;
}
$returnedDate = getDate(1);
echo $returnedDate['date'];

Not even sure why you are returning an array, since you are querying just a single value.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.