[PHP-DB] PHP = 4.2.0 and IBM DB2

Hello, we are running php based applications on Gentoo Linux with apache and IBM DB2 (running on another server). Under apache 1.3.28 and php 4.1.2 everything works fine, but when we switch to php 4.2.0 (or higher, I have tried 4.2.3 and 4.3.3, too) nothing works. I wrote a very simple test

[PHP-DB] php and MySQL and PostgresSQL at the same time

Is it possible to use PHP under one Apache WEB application in order to access MySQL and at the same time PostgreSQL? different databases ? Yours Sincerely Morten Gulbrandsen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] php and MySQL and PostgresSQL at the same time

I use Apache with PHP using MSSQL and MySQL at the same time... You'd just need to connect to different databases, the platform should not matter. hth Jeff

Re: [PHP-DB] numeric in plpgsql function

El Mié 01 Oct 2003 22:45, Gezeala 'Eyah' Bacuño II escribió: Saw this in the Postgresql manual : Chapter 8. Data Types Some of the operators and functions (e.g., addition and multiplication) do not perform run-time error-checking in the interests of improving execution speed. On some

Re: [PHP-DB] php and MySQL and PostgresSQL at the same time

El Jue 02 Oct 2003 08:22, Morten Gulbrandsen escribió: Is it possible to use PHP under one Apache WEB application in order to access MySQL and at the same time PostgreSQL? different databases ? Depends on how the question was made. Yes you can access diferent database engines from the

[PHP-DB] pconnect doesn't appear to work properly

Gang: We have noticed some considerable performance hits on our server recently, and after some investigation, we found over 100 mysql connections open and sleeping. The process belonged, for the most part, to only 2 web sites, both of which use mysql_pconnect quite extensively. After watching

RE: [PHP-DB] pconnect doesn't appear to work properly

Let me start off by qualifying my remarks by saying I don't use persistent connections, but I have researched them enough to know that I only need to use a standard mysql_connect() to fulfill my requirements. That said, I apologize for any unintended inaccuracies in my response. From the PHP

[PHP-DB] query problem

I'm having a problem with a specific query. SELECT DISTINCT(contents_.company_id), companies.* FROM contents_, companies WHERE contents_.Products LIKE '%heating%' OR contents_.Manufacturer LIKE '%heating%' AND contents_.company_id = companies.id The query works fine without the OR segment, for

AW: [PHP-DB] query problem

I'm not sure if you mean that, but try: SELECT DISTINCT(contents_.company_id), companies.* FROM contents_, companies WHERE (contents_.Products LIKE '%heating%' OR contents_.Manufacturer LIKE '%heating%') AND contents_.company_id = companies.id Lars -Ursprüngliche Nachricht- Von: Doug

[PHP-DB] Re: numeric in plpgsql function

I've already changed the declaration from float4 to numeric.. It is working now..Thanks to you! ;) However, the salvage value in my table is float4/real... Do i have to change it also to numeric?? The salvage value I'm referring to is actually a percentage value like user will input 10%,

[PHP-DB] Getting ODBC openlink 37000 in odbc_do($conn,$sql) but odbc_tables($conn) works? Help!

I am using iodbc from openlink on OS X and everything seems fine and I can get the database tables with $results = odbc_tables($conn) or die(P.odbc_errormsg()); And print them to the screen with odbc_result_all($results) or die(pprinting result error); But when I try $sql=select * form

Re: [PHP-DB] Getting ODBC openlink 37000 in odbc_do($conn,$sql) butodbc_tables($conn) works? Help!

But when I try $sql=select * form tblJobStatus; $results = odbc_do($conn,$sql) or die(p captured .odbc_errormsg()); I get Warning : odbc_do(): SQL error: [OpenLink][ODBC][Driver]Syntax error or access, SQL state 37000 in SQLExecDirect in /Library/WebServer/Documents/tests/odbc.php