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;

        $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'];

        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.