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
lt;[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: [PHP-DB] mysql to postgres migration blues... Date: Thu, 23 Sep 2004 19:44:51 +0200 Hi, I am trying to get skilled up on postgres and decided to port a little movie database I wrote for mysql with php to access it. I used an auto converter for

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

2004-09-23 Thread Antoine
Hi, I am trying to get skilled up on postgres and decided to port a little movie database I wrote for mysql with php to access it. I used an auto converter for the bulk and then tried to tweak. The following code does not work but the error message it gives me is strange. It tells me that the conne