Re: [PHP-DB] TIME CALCULATION IN PHP

2004-01-28 Thread W. D.
At 23:44 1/27/2004, Delz, wrote: Hi All, How do i calculate time in PHP lets say I have this example Input Time Started : 9:00 Input Time Ended : 13:00 Answer Total Time in Hours : 4 Total Time in Minutes : 240 What happens when they start at 23:59 and end at 01:30? This may never happen

[PHP-DB] PHP and PostgreSQL: Cannot create new link. Too many open links (0)

2004-01-28 Thread Johannes Alfänger
Hi All! After working with PHP and MySQL and Firebird quite a while I need to install PostgreSQL. After installation I made a new build of PHP to support PostgreSQL. I looked over the ini files and re-started Apache. With psql I can connect like: psql -h localhost But not any chancen seen

[PHP-DB] Re: PHP and PostgreSQL: Cannot create new link. Too many open links (0)

2004-01-28 Thread Johannes Alfaenger
Solved! Hi! I got the hint that the extension module (pgsql.so) should NOT be enabled in php.ini or php.d/pgsql.ini. Connection is successful now. Thanks! Johannes Alfänger [EMAIL PROTECTED] schrieb im Newsbeitrag news:[EMAIL PROTECTED] This is the error Message I get: Warning: pg_pconnect():

[PHP-DB] PHP with oci8 (on a sparc ultra-60 server with oracle 9i)

2004-01-28 Thread Florian Habegger
Hi, I'm trying to install PHP with oci8 on a sparc Ultra-60. Like this: ./configure --prefix=/usr/local/php/ --with-apxs2=/usr/local/apache/bin/apxs --with-pear -with-oci8=/opt/oracle/product/9.2.0/ The ./configure part was successful. But when I run make I get this error: ld: fatal: file

[PHP-DB] test

2004-01-28 Thread Florian Habegger
test -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PHP with oci8 (on a sparc ultra-60 server with oracle 9i)

2004-01-28 Thread Florian Habegger
Hi, I'm trying to install PHP with oci8 on a sparc Ultra-60. Like this: ./configure --prefix=/usr/local/php/ --with-apxs2=/usr/local/apache/bin/apxs --with-pear -with-oci8=/opt/oracle/product/9.2.0/ The ./configure part was successful. But when I run make I get this error: ld: fatal: file

[PHP-DB] PHP with oci8 (on a sparc ultra-60 server with oracle 9i)

2004-01-28 Thread Florian Habegger
Hi, I'm trying to install PHP with oci8 on a sparc Ultra-60. Like this: ./configure --prefix=/usr/local/php/ --with-apxs2=/usr/local/apache/bin/apxs --with-pear -with-oci8=/opt/oracle/product/9.2.0/ The ./configure part was successful. But when I run make I get this error: ld: fatal: file

Re: [PHP-DB] test

2004-01-28 Thread David T-G
Florian -- ...and then Florian Habegger said... % % test Please don't post tests here. We got this and your THREE copies of your oci8 question (for which I can only wish you good luck). HAND :-D -- David T-G * There is too much animal courage in (play) [EMAIL

Re: [PHP-DB] test

2004-01-28 Thread Viorel Dragomir
Please do NOT open attachments files without having an Antivirus installed. Like this guys did. Sending emails with attachments to a list is not a common behaviour. Thanks - Original Message - From: David T-G [EMAIL PROTECTED] To: PHP DB list [EMAIL PROTECTED] Cc: Florian Habegger

[PHP-DB] Inserting querydata as default value in form

2004-01-28 Thread Georg Herland
Hi! I hav made a simle page to insert update and delete data in MYSQL. I try to put existing data into a standard form field to make editing easyer: input name=link TYPE=TEXT cols=40 value=$query_data[4] Problem is when the text data contains a space ie Look here. Then only the first word show.

RE: [PHP-DB] Inserting querydata as default value in form

2004-01-28 Thread Paul Miller
Need some quotes input name=link TYPE=TEXT cols=40 value=\.$query_data[4].\ Output will look like input name=link TYPE=TEXT cols=40 value=Look Here Instead of input name=link TYPE=TEXT cols=40 value=Look Here\ Which it probably looks like now. - Paul -Original Message- From: Georg

RE: [PHP-DB] Inserting querydata as default value in form

2004-01-28 Thread Ford, Mike [LSS]
On 28 January 2004 18:05, Georg Herland wrote: Hi! I hav made a simle page to insert update and delete data in MYSQL. I try to put existing data into a standard form field to make editing easyer: input name=link TYPE=TEXT cols=40 value=$query_data[4] Problem is when the text data contains

[PHP-DB] Wonder Program Question

2004-01-28 Thread Paul Miller
Hi All, Got a question for everyone. Does anyone know of a Red Hat (Fedora would be even better) package that does the following: - Load Balancing - Proxying - Host Name Redirects - Server Heartbeat monitoring I know IP Tables can do it with some help from some other programs, but I am

[PHP-DB] Re: test

2004-01-28 Thread Michelle Konzack
Am 2004-01-28 16:32:39, schrieb Viorel Dragomir: Please do NOT open attachments files without having an Antivirus installed. Like this guys did. Sending emails with attachments to a list is not a common behaviour. Thanks Which attachments ? It was only a pgp signature ! And, why install a

[PHP-DB] Unexpected Session Behavior on Mozilla

2004-01-28 Thread dpgirago
Hello PHP-DB listers, I've a PHP, MySQL Web Page script that branches according to browser (e.g., MSIE, or Mozilla ) and which uses a small number of session variables. I've noticed that when connecting through Explorer, for each browser / page instance opened on the same machine, there is a

[PHP-DB] Re: Inserting querydata as default value in form

2004-01-28 Thread Neil Smth
When will people learn that attributes in HTML ,and *especially* in forms MUST BE QUOTED ! This will really really screw you up if you ever have to make an xhtml page (and you'll be back here again). Please please get into this practice, it will save you a lot of headaches even short term. So,

Re: [PHP-DB] Re: Inserting querydata as default value in form

2004-01-28 Thread John W. Holmes
From: Neil Smth [EMAIL PROTECTED] When will people learn that attributes in HTML ,and *especially* in forms MUST BE QUOTED ! This will really really screw you up if you ever have to make an xhtml page (and you'll be back here again). Please please get into this practice, it will save you a

[PHP-DB] multiple tables and amounts

2004-01-28 Thread ma
hi! i have a weired problem: there are 3 tables: photos (id, img) comments (id, phid, text) ratings (id, phid, text) now i tried to create a query returning the amount of ratings and the amount of comments for all images in the photo-table. i tried it with multiple joins, but without