[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

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

2004-09-23 Thread Bastien Koert
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 the bulk

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 up

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

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 - global

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 differently

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 host=localhost