[PHP-DB] Re: PostgreSQL connections within classes & collisions.

2001-08-26 Thread Yasuo Ohgaki
I have very smilar code and they are working for me. I'm using - PHP4.0.6 and PHP4.0.7RC1 - PostgreSQL 7.1.3 They are built from source. Your PHP might be linked against older libpq(?) than your PostgreSQL? -- Yasuo Ohgaki Justin Buist wrote: > I recently did a re-install of PostgreSQL and

[PHP-DB] Re: PostgreSQL connections within classes & collisions.

2001-08-26 Thread Yasuo Ohgaki
I have very smilar code and they are working for me. I'm using - PHP4.0.6 and PHP4.0.7RC1 - PostgreSQL 7.1.3 They are built from source. Your PHP might be linked against older libpq(?) than your PostgreSQL? -- Yasuo Ohgaki Justin Buist wrote: > I recently did a re-install of PostgreSQL and

Re: Re: [PHP-DB] Error with in_use() from Beginning PHP4 book.

2001-08-26 Thread John Lim
See http://php.weblogs.com/adodb_csv You create a proxy on Windows server and query access via the Windows server. "Vijay Anand" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... how to access MS Access database using adodb in unix -- PHP Database Mailin

[PHP-DB] Getting SQL queries from existing DB

2001-08-26 Thread Adriana Matiaskova
Does anyone have some scripts/program for creating SQL queries from existing MySQL database? I mean, it will create queries like CREATE TALBES... to be able to make Database with the same structure. Thanks. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROT

[PHP-DB] go to another URL

2001-08-26 Thread Andrius Jakutis
Hello, What is the command in PHP coding, to order go to another URL? Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] help me with DBA

2001-08-26 Thread Donald FEI
When i execute the following codes: an error occurs: Warning: no such handler: db2 in D:\Inetpub\WebSite/dba_test.php on line 2 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the li

[PHP-DB] Re: help me with DBA

2001-08-26 Thread Alexandre Santos
Donald Fei wrote: > > When i execute the following codes: > $db=dba_open("database.db","c","db2"); > ?> > an error occurs: > Warning: no such handler: db2 in D:\Inetpub\WebSite/dba_test.php on line 2 Have you compiled PHP with support for that? I don't think so... Alex -- PHP Database Mail

[PHP-DB] for what?

2001-08-26 Thread Donald FEI
"Alexandre Santos" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Donald Fei wrote: > > > > When i execute the following codes: > > > $db=dba_open("database.db","c","db2"); > > ?> > > an error occurs: > > Warning: no such handler: db2 in D:\Inetpub\WebSite

[PHP-DB] Re: go to another URL

2001-08-26 Thread Hugh Bothwell
"Andrius Jakutis" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hello, > > What is the command in PHP coding, to order go to another URL? header("Location: newurl"); Note that this must be sent before any of the message body. -- PHP Database Mailing Lis

[PHP-DB] Re: oracle 9i + apache

2001-08-26 Thread Premysl Dedic
Maybe some problems with libraries ... Add Oracle libs to /etc/ld.so.conf and run ldconfig ... (RedHat distribution, I do not know where is the config file on Suse ...) [EMAIL PROTECTED] >>> "TDuquette" <[EMAIL PROTECTED]> 24.8.01 19:23 >>> Hi As anyone sucesfully compiled php4 with OCI sup

[PHP-DB] mysql select where problem

2001-08-26 Thread Matt Nigh
hello again, i'm stuck with this mysql query and can't seem to get it right // start code $result = mysql_query("select * from shows WHERE date >= '" . $year . "-" . $month . "-" . ("00") ."' AND where date <= '" . $year . "-" . $month . "-" . ("31") ."'"); // end code and yes, $year and $mo

Re: [PHP-DB] mysql select where problem

2001-08-26 Thread Dreamvale
select * from shows where date >= '$year-$month-01' and date <= '$year-$month-$lastdayofthemonth' - Original Message - From: "Matt Nigh" <[EMAIL PROTECTED]> To: "php-db" <[EMAIL PROTECTED]> Sent: Monday, August 27, 2001 7:09 AM Subject: [PHP-DB] mysql select where problem hello again,

[PHP-DB] DISTINCT in SQL query

2001-08-26 Thread Scott Mebberson
Hi Guys, I am retriving information based across three tables, here is the SQL statement SELECT DISTINCT title, filelocation, filename, ranking, summary FROM pdf, words, searchwords WHERE words.id = searchwords.word_id AND pdf.id = searchwords.pdf_id AND LCASE(words.word) LIKE LCASE('%$searchstr

Re: [PHP-DB] Getting SQL queries from existing DB

2001-08-26 Thread Andrey Hristov
Get and install phpMyAdmin. It can dump to you, the stucture, the data or both. Then save them from the browser(better with lynx because you can get the source of a page piped). And pipe it to another "mysql", or use it in another phpMyAdmin. Andrey Hristov IcyGEN Corporation http://www.icygen.