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

2004-09-23 Thread Antoine
connection string used on line 82 (where it calls pg_query in makelistboxentries) is invalid... but the same string/connection works just great in another script... any pointers appreciated. Cheers Antoine Search by: ID: Name: TII; makelistboxentries("Audio Language", &qu

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

2004-09-23 Thread Antoine
e function did. I'll get there, but I pretty much copied and pasted all the php up until now so I have a little way to go... Cheers Antoine -- G System, The Evolving GUniverse - http://www.g-system.at -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

Re: [PHP-DB] [Newbie] switch, if, or something to choose queries and echo formatting--PLEASE help

2004-09-25 Thread Antoine
but I don't think this is the way to go. The above extract should be enough to see what I mean... "Only when a case statement is found with a value that matches the value of the switch expression does PHP begin to execute the statements." You don't have one so... it won't ever start! Cheers Antoine -- G System, The Evolving GUniverse - http://www.g-system.at -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: switch, if, or something to choose queries and echo formatting--PLEASE help

2004-09-26 Thread Antoine
but not if left as ?. Cheers Antoine -- G System, The Evolving GUniverse - http://www.g-system.at -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: switch, if, or something to choose queries and echo formatting--PLEASE help

2004-09-29 Thread Antoine
did that fix it? On Sun, 26 Sep 2004 18:56:59 +0200, Antoine <[EMAIL PROTECTED]> wrote: > > image > > > > I have just been testing and looking on a few fora (I know very little > about php and html still) but you have two ?'s in that url. I believe > the

Re: [PHP-DB] which DB to use?

2004-10-01 Thread Antoine
n abstraction layer, I saw some nasty stats for pear db and postgres/mysql), don't dismiss oracle off-hand... I don't know what your price range is but my understanding is that their prices have dropped considerably in the last wee while. Otherwise use postgres, it has everything but a

[PHP-DB] somewhat OT - firebird vs postgres, and php support

2004-10-01 Thread Antoine
but a lot of things seem to be for interbase - are they always going to be compatible? I see pear db has support for interbase, does that mean firebird too, or just the latest interbase? Cheers Antoine -- G System, The Evolving GUniverse - http://www.g-system.at -- PHP Database Mailing List

Re: [PHP-DB] Dynamic pull down menus with PHP/Mysql

2004-10-08 Thread Antoine
doesn't work well when dealing with large amounts of data. If > > you're running into this, use javascript's window.opener feature. It allows > > you to spawn a second window that retrieves data and sends it to the first > > window. Cripes! People are a bit slow today.

[PHP-DB] Re: [PEAR] Pear installation error

2004-10-08 Thread Antoine
ause usually the installation of these three packages is done with about 5 clicks, and gets configured pretty much by itself (of course, if you want security and stuff, you have to change the config, but I am sure that is not different to IIS...). Just a suggestion. Cheers Antoine -- G System, The Evolving GUniverse - http://www.g-system.at -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] INNO tables - will I have problems?

2004-10-17 Thread Antoine
ISAM, but to create an INNODB table, one > must specify it in the CREATE TABLE syntax... You can convert very easily afterwards also. Just a matter of a couple of lines of sql. You will have to add all the extra constraints and functionality after too... Cheers Antoine -- G System, The Evolving GUniverse - http://www.g-system.at -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] how many databases should I create

2004-10-18 Thread Antoine
urity or lax in responsibility. shouldn't a good rdbms take care of that though (with reasonable security measures)? can't you get fine grained user privs, at least with a proper db? postgres? Cheers Antoine -- G System, The Evolving GUniverse - http://www.g-system.at -- PHP D

[PHP-DB] updating several rows with a single form

2002-05-04 Thread Antoine Panier
ld be much appreciated Antoine -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php