Re: More on functions

Abe wrote: > function DatabaseConnect() > { > global $connection; > $connection = pg_connect("dbname=abe port=5435") or die ("Couldn't > make a connection."); > } > > DatabaseConnect(); > $sql = "select firstname etc etc etc etc ...."; > $sql_result = pg_exec($connection,$sql); I can't see anything wrong (I never used pg_*(), by the way). However, this kind of handling variables is bad style and makes debugging difficult. You should do it this way: function DatabaseConnect() { $connection = pg_connect("dbname=abe port=5435") or die ("foobar"); return $connection; } $connection = DatabaseConnect(); $sql_query = "select firstname etc etc etc etc ...."; $sql_result = pg_exec($connection,$sql_query); For debugging, you could try to echo $connection. Wagner -- Sanity is calming, but madness is more interesting.