Re: [PHP-DB] Keeps prompting to download php page???

2002-07-17 Thread Jason Wong
On Thursday 18 July 2002 03:28, NIPP, SCOTT V (SBCSI) wrote: > AddType application/x-httpd-php .htm The only Apache is going to render your php pages as php is if you tell it to. The above line only tells Apache to render .htm pages as php. > The AddType directive is exactly the same as

RE: [PHP-DB] SQL query prob

2002-07-17 Thread Cal Evans
It would unless you told it not to. Set a flag $lastContactType=''; Then on the first page you display something where then display it and then if ($lastContactType != $row['contactType']){ echo $row['contactType']; $lastContactType=$row['contactType']; } // if ($lastContactType !

[PHP-DB] Re: MS Access - default value in create table

2002-07-17 Thread Nuttzy
FYI, I'm sending this stuff through the odbc_exec command. Any MS Access experts out there? Thanks! -Nuttzy "Nuttzy" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I can create tables and perform alterations just fine. However, if I try to > specify a DEFAU

[PHP-DB] Re: Construct, Q+E, QBE

2002-07-17 Thread Adam Royle
This sounds very interesting. As far as I know, there are no automatic functions to do this, although i don't think it would be too hard to write the php function to do this. If end up finding a solution, please email it to me (and the list), or if you need a hand in writing it, I'd be happy to

Re: [PHP-DB] Re: PHP ldap_add() - null values in fields produce an "value #0 invalid per syntax" error on the ldap server

2002-07-17 Thread Ian Ball
On Thursday 18 July 2002 02:20, David Robley wrote: > > Perhaps if you were to test that the relevant values were not empty; only > add them to the ldap database if they have a value? empty or isset are the > functions to investigate. > > Cheers Unfortunately this is not an option, as it will mes

[PHP-DB] SQL query prob

2002-07-17 Thread Russ
I'll try that one again I have a query: $sql = "SELECT * FROM contacts ORDER BY ContactType"; There are two types of contacts: * Commissioners * Staff As they are ordered by the ContactType then 'Commissioners' are displayed first followed by 'Staff'. I'd like to be able to display a h

[PHP-DB] SQL Solution??

2002-07-17 Thread Russ
Hi all: I have a simple MySQL SELECT query: Mr Russ Michell Web Applications Developer Itomic.com Email: [EMAIL PROTECTED] Tel: +61 (0)8 9321 3844 Fax: +61 (0)8 6210 1364 Post: PO Box 228, Innaloo, WA 6918, Australia Street: Suite 24, 158 William St, Perth, WA 6000, Australia "No proo

[PHP-DB] Re: PHP ldap_add() - null values in fields produce an "value #0 invalid per syntax" error on the ldap server

2002-07-17 Thread David Robley
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > Hi, > > New to the list and hoping someone might be able to help me. > > I have been using PHP scripts that are to maintain a company address book > with a lot of data about contacts, both inside and outside the company. The > scripts

RE: [PHP-DB] Keeps prompting to download php page???

2002-07-17 Thread NIPP, SCOTT V (SBCSI)
Yes. I have the application type, and both the LoadModule and AddModule directives for PHP in the httpd.conf file. Here are those entries cut and pasted from my httpd.conf: # LoadModule foo_module libexec/mod_foo.so LoadModule frontpage_module libexec/mod_frontpage.so LoadModule php4_

[PHP-DB] PHP ldap_add() - null values in fields produce an "value #0 invalid per syntax" error on the ldap server

2002-07-17 Thread Ian_Ball
Hi, New to the list and hoping someone might be able to help me. I have been using PHP scripts that are to maintain a company address book with a lot of data about contacts, both inside and outside the company. The scripts, which are generating html pages and reading input values back in, have

[PHP-DB] Amazon PHP API

2002-07-17 Thread Calin Uioreanu
Hi all, As you probably know, Amazon.com released an API this morning to browse their huge ecommerce catalogs. You don't have to be a manager to realise the huge monetary potential here. Here is a Amazon PHP API implementation using only the XML support in PHP I wrote: http://www.php9.com/index

[PHP-DB] Construct, Q+E, QBE

2002-07-17 Thread Fernando Ortiz
I'm migrating my code from Informix 4GL to PHP, my problem now is how to give the users the ability to make a query with the facilities that the CONTRUCT verb gives in 4GL. Suppose a form field name 'price' where the users can type the search criteria If the user type ... I need to get

Re: [PHP-DB] TEXTAREA ...

2002-07-17 Thread Martin Clifford
Yup. So: $content = nl2br(htmlentities(stripslashes($content))); // Good for echo'ing HTML into the page $content = nl2br($content); // Good for showing $content with HTML formatting Martin Clifford Homepage: http://www.completesource.net Developer's Forums: http://www.completesource.net/forum

Re: [PHP-DB] TEXTAREA ...

2002-07-17 Thread Martin Adler
That's right but if the variable is initialised by the form and you want to write the variable in to your html-document it's better to write this $content = nl2br(htmlentities(stripslashes($content))); - Original Message - From: "Martin Clifford" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED

Re: [PHP-DB] TEXTAREA ...

2002-07-17 Thread Martin Clifford
$content = nl2br($content); That will convert all newline characters into tags. HTH Martin Clifford Homepage: http://www.completesource.net Developer's Forums: http://www.completesource.net/forums/ >>> José Moreira <[EMAIL PROTECTED]> 07/17/02 09:15AM >>> hello ... im sorry to bother with a

[PHP-DB] TEXTAREA ...

2002-07-17 Thread José Moreira
hello ... im sorry to bother with a non-db question but i searched for this and got 0 record :P its all about the wrappig in textareas: how can i convert the end of line/ line breaks ['enter' keys] that the user hits while filling a textarea so that when i display the record content the text doe

[PHP-DB] odbc and primary key

2002-07-17 Thread j.a.z.
How can i get the information if a field on a database (in my case Access2000) is primary key via a php-odbc-function? or does i have to use sql for that? thanx j.a.z. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Fw: mysql multiple query

2002-07-17 Thread ditzi
> hello.. > i have a pretty wired query to do with php/mysql . > i don't manage to do > > mysql_query($qry,$connection); . > (query bellow) > > so i found a quick and dirty solution.see bellow . > but it's no realy elegant . > > any ideea how can i do multiple queries at once with mysql_query()

[PHP-DB] mysql multiple query

2002-07-17 Thread cristian ditoiu
hello.. i have a pretty wired query to do with php/mysql . i don't manage to do mysql_query($qry,$connection); . (query bellow) so i found a quick and dirty solution.see bellow . but it's no realy elegant . any ideea how can i do multiple queries at once with mysql_query() ? function copy_ques

RE: [PHP-DB] Warnings and Error messages

2002-07-17 Thread Russ
Stick a '@' in front of the function/statement generating the error: @unlink("$filname"); for example... Russ -Original Message- From: Gabor Niederlaender [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 5:54 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Warnings and Error message

[PHP-DB] Warnings and Error messages

2002-07-17 Thread Gabor Niederlaender
Hi all! How can I prevent the warnings end errors to be written on the screen? I would like to prevent the warnings end errors to be written on the screen because I want to handle the errors with the odbc_errormsg() function. How do I do that? Is there a better way? Best regards, Gabor -- P

Re: [PHP-DB] DAO implementations

2002-07-17 Thread Ulf Wendel
Pierre-Alain Joye wrote: >On Wed, 17 Jul 2002 10:06:11 +0200 >Ulf Wendel <[EMAIL PROTECTED]> wrote: > > > >>Hi, >> >>are there some DAO pattern implementations available for PHP to query >>MySQL, Postgres and/or DB2? Which one do you preferr? >> >> >> > >What mean DAO ? It can be confused

[PHP-DB] unixODBC

2002-07-17 Thread Marten Lehmann
Hello, isn't anybody using unixODBC with php out there? I still hope to get help to solve my unixODBC problem as described in my last mail. Regards Marten -- Variomedia IT-Service GmbH | Benzstrasse 22 | 14482 Potsdam http://www.variomedia.de | Hotline: 0800-5588550 | Fax: 0331-7404043

Re: [PHP-DB] DAO implementations

2002-07-17 Thread Pierre-Alain Joye
Update your vacation message, we are the 17th :) pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] DAO implementations

2002-07-17 Thread Pierre-Alain Joye
On Wed, 17 Jul 2002 10:06:11 +0200 Ulf Wendel <[EMAIL PROTECTED]> wrote: > Hi, > > are there some DAO pattern implementations available for PHP to query > MySQL, Postgres and/or DB2? Which one do you preferr? > What mean DAO ? It can be confused (dao, ado, ...). Did you try PEAR::DB_DataObj

[PHP-DB] Re: change data before its sent to db?

2002-07-17 Thread Tomator
You will laugh. When you quote month, you don't sort date by month field. You sort by "month" - text constant being always equal. In fact you son't sort it at all! > The sort code --- > > if ($orderby == 'month_num'): > $sql = "select * from releases order

RE: [PHP-DB] Select a subset?

2002-07-17 Thread joakim . andersson
> From: Clive Bruton [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 16, 2002 10:24 PM > > Joakim, thanks, that sorted it. Just one note, "numrows" in > the sql query > should be "num_rows"? That's how I got it to work anyway. Yes, that's totally correct. Just a typo. Joakim -- PHP Database

[PHP-DB] DAO implementations

2002-07-17 Thread Ulf Wendel
Hi, are there some DAO pattern implementations available for PHP to query MySQL, Postgres and/or DB2? Which one do you preferr? Thanks for advice, Ulf -- WWE e-commerce IT GmbH, http://wwe.biz Eiffestrasse 462, D-20537 Hamburg Tel: 040 / 25 30 65 9-0, Fax: 040 / 25 30 65 950 -- PHP Datab