Calling a Stored Procedure using PHP

-----Original Message-----
Subject: [GENERAL] Calling a Stored Procedure using PHP

I've written a simple stored procedure in postgres and I'm trying
to get PHP
to call the function and show the results. My problem is I can't
get PHP to
bring up my results. I'm using the PHP functions for postgres, such as
pg_exec and pg_fetch_array, but nothing is working. What do I need to do?
What am I missing? Can someone help me?

Any help would be very much appreciated.

Wendy

Are you doing it like this?

$dbh = pg_connect ($connect_string);
$result = pg_exec ($dbh, "SELECT yourstoredprocedure()");

You can't call it directly; you call it as part of a SELECT query.
Then pull the results like you would for any SELECT query.
Hope this helps.

Jason Priebe
Mi-Co
http://www.mi-corporation.com/