[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

[PHP-DB] MySQL or Postgres

2003-03-24 Thread Ben Edwards
Could someone please point me in the correct direction for a decent comparison of the two in respect of:- Reliability Scalability Speed Functionality These are actually in order or importance to me (I know both are fairly fast). I am also interested in how easy it would be to migrate

RE: [PHP-DB] MySQL or Postgres

2003-03-24 Thread Snijders, Mark
of it, is prohibited and may be unlawful. -Original Message- From: Ben Edwards [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: maandag 24 maart 2003 12:03 To: [EMAIL PROTECTED] Subject: [PHP-DB] MySQL or Postgres Could someone please point me in the correct direction for a decent

RE: [PHP-DB] MySQL or Postgres

2003-03-24 Thread Snijders, Mark
sorry the url I gave was of a weird language.. this one is better: http://www.phpbuilder.com/columns/tim2705.php3 -Original Message- From: Ben Edwards [mailto:[EMAIL PROTECTED] Sent: maandag 24 maart 2003 12:03 To: [EMAIL PROTECTED] Subject: [PHP-DB] MySQL or Postgres Could

RE: [PHP-DB] MySQL or Postgres

2003-03-24 Thread Ben Edwards
- From: Ben Edwards [mailto:[EMAIL PROTECTED] Sent: maandag 24 maart 2003 12:03 To: [EMAIL PROTECTED] Subject: [PHP-DB] MySQL or Postgres Could someone please point me in the correct direction for a decent comparison of the two in respect of:- Reliability Scalability Speed Functionality

RE: [PHP-DB] MySQL or Postgres

2003-03-24 Thread May, Patrick
Ben, Subject: [PHP-DB] MySQL or Postgres Could someone please point me in the correct direction for a decent comparison of the two in respect of:- Reliability Scalability Speed Functionality These are actually in order or importance to me (I know both are fairly

Re: [PHP-DB] MySQL or Postgres

2003-03-24 Thread Lester Caine
There are other open-source databases besides MySQL and Postgres. My experience has pointed me towards firebird / interbase: http://firebird.sourceforge.net/ Same here - 24/7 operation and Windows or Linux servers -- Lester Caine - L.S.Caine Electronic Services --