Re: [PHP-DB] mysql to postgres migration blues...

2004-09-23 Thread Antoine
On Thu, 23 Sep 2004 12:23:32 -0700, Andrew Kreps <[EMAIL PROTECTED]> wrote: > On Thu, 23 Sep 2004 20:51:52 +0200, Antoine <[EMAIL PROTECTED]> wrote: > > declaring it as global didn't seem to work - > > > > global $link; > > /* Connect to database */ > > $link = pg_connect("dbname=movies hos

Re: [PHP-DB] mysql to postgres migration blues...

2004-09-23 Thread Andrew Kreps
On Thu, 23 Sep 2004 20:51:52 +0200, Antoine <[EMAIL PROTECTED]> wrote: > declaring it as global didn't seem to work - > > global $link; > /* Connect to database */ > $link = pg_connect("dbname=movies host=localhost user=anton > password=password") The global keyword works a little bit dif

Re: [PHP-DB] mysql to postgres migration blues...

2004-09-23 Thread Antoine
On Thu, 23 Sep 2004 22:27:38 +0400, M Saleh EG <[EMAIL PROTECTED]> wrote: > define the connection object as a global var in ur function > > function ( params) > { > global $ur_connection_obj; > ... > ... > Damn you guys are quick! I like this list... declaring it as global didn't seem to work -

Re: [PHP-DB] mysql to postgres migration blues...

2004-09-23 Thread M Saleh EG
define the connection object as a global var in ur function function ( params) { global $ur_connection_obj; ... ... } On Thu, 23 Sep 2004 14:56:10 -0300, Eduardo Sampaio <[EMAIL PROTECTED]> wrote: > Its because the function cannot access your connection object... > Try passing it to the functi

Re: [PHP-DB] mysql to postgres migration blues...

2004-09-23 Thread Eduardo Sampaio
Its because the function cannot access your connection object... Try passing it to the function.. function makelistboxentries($link, $title, $mytable, $mycolumn, $othertable, $wherestring) On Thu, 23 Sep 2004 19:44:51 +0200, Antoine <[EMAIL PROTECTED]> wrote: > Hi, > I am trying to get skilled u

RE: [PHP-DB] mysql to postgres migration blues...

2004-09-23 Thread Bastien Koert
Could be a scope problem. The connection is declared outside the function and the attempt to run a query is inside the function...Maybe add the global command to the connection. Or declare the connection inside the function... Bastien From: Antoine <[EMAIL PROTECTED]> Reply-To: Antoine <[EMAIL P