Re: Warning: Supplied argument is not a valid PostgreSQL link resource

Hi,

>      function sql_execute($query)
>      {
>  $resultat = pg_exec($conn, $query);
>
>           if(!$resultat) {
>       echo "Kunne ikke udføre: <em>$query</em>";
>       return;
>    }
>      }

You are missing the global $conn in the function. You either need to feed it in as a parameter or reference it as a
globalvariable. 

function sql_execute($conn, $query)
{
    $resultat = pg_exec($conn, $query);
    if(!$resultat)
    {
        echo "Kunne ikke udføre: <em>$query</em>";
        return;
    }
}

OR

function sql_execute($query)
{
    global $conn;

    $resultat = pg_exec($conn, $query);
    if(!$resultat)
    {
        echo "Kunne ikke udføre: <em>$query</em>";
        return;
    }
}

This is the same for the sql_execute_receive, conn_close and any other function that references $conn. PHP does not
automaticallyinclude global variables in the functions scope. 

I currently set $conn to be a global variable (i.e. declared outside the function) and use the global $conn method to
getit into scope with the function. 

Hope that's a little clearer.

Nick Barr