[PHP-DB] SQL Join problem (Firebird)

2003-09-02 Thread Evan Morris
Hi all Say you have two tables, TABLE1 and TABLE2. Each table contains (amongst others) a field called SOMEVALUE Now, in TABLE1 SOMEVALUE contains "string1", but in TABLE2 SOMEVALUE contains "string2". Now you join these tables (on SOMEOTHERVALUE) and you loop through the results set: while ($r

RE: [PHP-DB] include_path problem

2003-09-02 Thread Bruce Levick
Well yes I have restarted my webserver, and the php.ini file is under the "windows directory" (shown in phpinfo page) and I am definatelty editing it. The current value for my include_path is ".;c:\php\includes" which is different to whats showing up on the phpinfo page and also the error that is

[PHP-DB] sqlite question

2003-09-02 Thread andu
I use the following to delete a column from a table: $columns= "'col1','col2','col3','col4','col5'"; $columns=str_replace(','."'col3'",'',$columns); $this->open_db(); //get the resource number($this->c_id) $r=sqlite_query($this->c_id,"BEGIN"); $r=sqlite_query($this->c_id,"CREATE TEMPORARY TABLE 'b

Re: [PHP-DB] PHP, MySQL and Apache 2 ?

2003-09-02 Thread Martin Marques
El Mar 02 Sep 2003 16:11, David Haines escribió: > This is maybe a bit Off-topic, and yet I could think of no better place to > ask: > > How many of you are using PHP with MySQL and Apache 2 ? > > I know there _were_ some problems, but do the current (stable) PHP and > MySQL work fine with Apache 2

[PHP-DB] PHP, MySQL and Apache 2 ?

2003-09-02 Thread David Haines
This is maybe a bit Off-topic, and yet I could think of no better place to ask: How many of you are using PHP with MySQL and Apache 2 ? I know there _were_ some problems, but do the current (stable) PHP and MySQL work fine with Apache 2 ? Have a client machine with Redhat 9, and Apache 2 gets in

[PHP-DB] Re: PHP, MySQL and Apache 2 ?

2003-09-02 Thread Shadow
I have it running under Windows NT 4.0..no problems... Shadow -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Create table

2003-09-02 Thread Larry Sandwick
I am trying to use PHP to create a table ( 5 wide by X long ) , with pictures in a directory, and have not been able to find this information. There are about 33 picture in a specific directory, and I would like to just read them in and create a table when the link is click. Can someone p

Re: [PHP-DB] What are your DB driven/template strategies?

2003-09-02 Thread Colbey
On Mon, 1 Sep 2003, Colin Kettenacker wrote: > The only alternative I came up with is to use .htaccess to redirect to my > single initialization PHP file, but I am not sure if this is a good > technique and of course it will only work on Apache. What about using php.ini's setting for prepend_fil

RE: [PHP-DB] To slash or not to slash....

2003-09-02 Thread Ford, Mike [LSS]
On 02 September 2003 16:45, Craig Cameron wrote: > Ok simple problem I hope. > > > Have the following code, used to store the location and a few > details about meeting minutes. > > > $connection = mssql_connect("server","user","password"); > mssql_select_db("Docume

Re: [PHP-DB] Call to undefined function: pg_connect()

2003-09-02 Thread Tyler Lane
run phpinfo() and verify that postgresql support is indeed there. Is the version of php-pgsql you installed been compiled for 7.3.4? If it was compiled for postgresql 7.2 then it won't work with 7.3.x libraries. HTH On Tue, 2003-09-02 at 07:31, Jennifer Liu wrote: > Hi, >

[PHP-DB] PHP, MySQL and Apache 2 ?

2003-09-02 Thread David Haines
This is maybe a bit Off-topic, and yet I could think of no better place to ask: How many of you are using PHP with MySQL and Apache 2 ? I know there _were_ some problems, but do the current (stable) PHP and MySQL work fine with Apache 2 ? Have a client machine with Redhat 9, and Apache 2 gets in

Re: [PHP-DB] MSSQL2000 and PHP

2003-09-02 Thread Robert Twitty
Yes You cannot read varchar(>255) data fields. You cannot easily read ntext and nvarchar (UNICODE) fields. No direct support for stored procedures. -- bob On Mon, 1 Sep 2003, Arnaud L wrote: > Hi, > > We have migrate our SQL server to MSSQL2000. > Since this migration, we can't connect to MSS

[PHP-DB] To slash or not to slash....

2003-09-02 Thread Craig Cameron
Ok simple problem I hope. Have the following code, used to store the location and a few details about meeting minutes. $connection = mssql_connect("server","user","password"); mssql_select_db("DocumentManager",$connection); $AlteredMinu

[PHP-DB] Call to undefined function: pg_connect()

2003-09-02 Thread Jennifer Liu
Hi, I'm writing my first script in php to connect to a postgresql database on a Linux box with apache web server. - httpd-2.0.40-21.3.i386.rpm - php-4.2.2-17.2.i386.rpm and php-pgsql-

Re: [PHP-DB] How to get data from excell file?

2003-09-02 Thread ramki
Hi To my knowledge, there isnt any function. you could try setting a dsn for xl file and use it through odbc in php. -ramki Spychała Wojciech wrote: I want to get data from excell file. Is there in php some function making it possible? For example something like functions reading from dbf's. T

Re: [PHP-DB] Heop someone can help with this.. involves sessions.

2003-09-02 Thread CPT John W. Holmes
From: "Aaron Wolski" <[EMAIL PROTECTED]> > I really hope you don't mind the OT post but I've looked everywhere and > can't seem to find a solution to my problem. > > I am passing a var in a session (not in the URL) to my secure checkout > area and it's not capturing the variable. > > I know there

[PHP-DB] How to get data from excell file?

2003-09-02 Thread Spychała Wojciech
I want to get data from excell file. Is there in php some function making it possible? For example something like functions reading from dbf's. Thanks Wojtek -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Call to undefined function: pg_connect()

2003-09-02 Thread Jennifer Liu
Hi, I'm writing my first script in php to connect to a postgresql database on a Linux box with apache web server. - httpd-2.0.40-21.3.i386.rpm - php-4.2.2-17.2.i386.rpm and php-pgsql-4.2.2-17.2.i386.rpm - postgresql-7.3.4.tar.gz When I try to load the page, I get the error: Fatal error: Call

Re: [PHP-DB] Problem in executing linux command from PHP

2003-09-02 Thread David Smith
Gnanavel wrote: I have problem in executing linux command $output=exec("ls -a"); echo "$output"; the above coding works, but $output=exec("cp file1 file2"); echo "$output"; does not works. can any one help me out of this problem When I was executing the "cp" command it doesn't return anything.

[PHP-DB] Set autocommit to off/on from PHP

2003-09-02 Thread Joanna Owczarzak
PHP 4.1.2, postgreSQL 7.1.3. How to change autcommit property of postgreSQL database from php script? Thanks in advance Joanna -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Problem in executing linux command from PHP

2003-09-02 Thread Gnanavel
I have problem in executing linux command $output=exec("ls -a"); echo "$output"; the above coding works, but $output=exec("cp file1 file2"); echo "$output"; does not works. can any one help me out of this problem When I was executing the "cp" command it doesn't return anything. But it returne

Re: [PHP-DB] What are your DB driven/template strategies?

2003-09-02 Thread Alexey Trunyov
Colin Kettenacker wrote: I, like many here, have created a database driven/template systems using PHP and the database engine of your choice. However, I am still stuck with having to create directories on the server for every page on the website with the same initialization PHP file that kicks off

[PHP-DB] What are your DB driven/template strategies?

2003-09-02 Thread Colin Kettenacker
I, like many here, have created a database driven/template systems using PHP and the database engine of your choice. However, I am still stuck with having to create directories on the server for every page on the website with the same initialization PHP file that kicks off the whole process. I'm g

RE: [PHP-DB] include_path problem

2003-09-02 Thread Ford, Mike [LSS]
On 02 September 2003 08:00, Bruce Levick wrote: > Hi guys, > I am re-developing the look and feel of a site and trying to set it up > localy. Its all setup and ready to go but I am getting a > pear.php include > failure. > > Warning: main(/PEAR.php): failed to open stream: No such file > or direc

RE: [PHP-DB] What are your DB driven/template strategies?

2003-09-02 Thread Griffiths, Daniel
You can use a custom 404 error page to redirect everything through your initialization file, set this up in the apache conf files (exaclty which one depends on your distro), just search for 404 in them and you'll find the right location, not sure about IIS. links are then given names as you woul

[PHP-DB] mySQL Binaries for Linux

2003-09-02 Thread John Ryan
I downloaded what I thought was Linux mySQL binaries, and the INSTALL file said there should be a bin directory when I untar, but there isnt! Just a BUILD folder and loads of make files. Did I download the wrong one? I downloaded mysql-standard-4.0.14-pc-linux-i686.tar.gz -- PHP Database Mailing

Re: [PHP-DB] Problem in executing linux command from PHP

2003-09-02 Thread Sean Burlington
Gnanavel wrote: I have problem in executing linux command $output=exec("ls -a"); echo "$output"; the above coding works, but $output=exec("cp file1 file2"); echo "$output"; does not works. can any one help me out of this problem When I was executing the "cp" command it doesn't return anything.

[PHP-DB] include_path problem

2003-09-02 Thread Bruce Levick
Hi guys, I am re-developing the look and feel of a site and trying to set it up localy. Its all setup and ready to go but I am getting a pear.php include failure. Warning: main(/PEAR.php): failed to open stream: No such file or directory in G:\Inetpub\wwwroot\DB.php on line 25 Fatal error: main()