[PHP-DB] multiple tables and amounts

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 success...

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

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 y

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

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,

[PHP-DB] Unexpected Session Behavior on Mozilla

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 n

[PHP-DB] Re: test

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] Wonder Program Question

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 looki

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

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: > Problem is when the text data contains a space ie "Look > here". Then only the > first w

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

Need some quotes Output will look like Instead of \ Which it probably looks like now. - Paul -Original Message- From: Georg Herland [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 28, 2004 12:05 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Inserting querydata as default value in f

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

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: Problem is when the text data contains a space ie "Look here". Then only the first word show. To display both words i have to update the data to "Lo

Re: [PHP-DB] test

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 Habeg

Re: [PHP-DB] test

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 PROTECTED

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

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 /op

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

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 /op

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

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 /op

[PHP-DB] test

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)

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 /op

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

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 /op

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

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_pconnec

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

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

Re: [PHP-DB] TIME CALCULATION IN PHP

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 nev