Re: [PHP-DB] php client -- informix-se

Hello Luigi, I'm afraid before you're able to use the informix database it will have to be upgraded to at least version 7.x. We have SCO Openserver 5.0.4 running the Informix SE 7.2 with PHP4 and Apache and all works well. We too have an NT server but would not even entertain the idea of running

Re: [PHP-DB] rewriting this query to remove IN

Hi Guys, I understand that as of version 3.24, MySQL will support subselects. But untill then (because 3.23 is the latest stable release) I need to convert this SQL satement into something that can be used with v3.2? - the version just before the latest release. $search = "SELECT

[PHP-DB]Question on select..for update

Hi, just started on the list, and the didn't seem to get through the first time, so I'll give it another whirl. I'm trying the following code based on a modded db_oci8.inc (the mod is so that the call to OCIExecute always passes OCI_DEFAULT rater than OCI_COMMIT_ON_SUCCESS. This is a snippet of

Re: [PHP-DB] db2

Will my db2 connection (using odbc_connect and the CLI driver) close when the script ends, or should I always call odbc_close? It should. otherwise if something goes wrong in the script, then connection still open. One of the disadvantages of pconnect. Ended up DOS'ing the AS400 ;-) marios

[PHP-DB] informix: inserting long chars via php3

hi, we work with php 3.0.14 and try to insert texts into char(500) fields in an informix 7.2 database. but, there is always the following error: "Warning: Prepare fails (E [SQLSTATE=IX 000 SQLCODE=-280]) in db.inc.php3 on line 21" that error code -280 means: "A qouted string exceeds 256 bytes"

RE: [PHP-DB] Linux+PHP+Infomix....

Hi. Here is how I did it. 1.- Download and untar apache and php sources. I use apache_1.3.12.tar.gz and php_4.0.2.tar.gz 2.- Download informix client (esdk240uc1_linux.rpm) from informix.com (write down S/N and ACT. KEY) 3.- Uninstall apache 4.- Create informix user, group informix. 5.- in

Re: [PHP-DB] Positioning into a query

Hello, "Francesco Rossi"! You wrote: Hi, After i have traverse a queryhow i can repositioning my cursor to the first record of the query ? While traversinq, put records in array, then work with it. -- Piloteers do it on the road -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] Here you have, ;o)

Hi: Check This! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] Here you have, ;o)

fantastic I never knew how to unsubscribe. M@ -Original Message- From: ajay arora [mailto:[EMAIL PROTECTED]] Sent: 12 February 2001 17:21 To: php db Subject: [PHP-DB] Here you have, ;o) Hi: Check This! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

AW: [PHP-DB] Oracle connectivity

http://www.php.net/manual/en/function.ocilogon.php tells you int OCILogon (string username, string password [, string db]) so i assume that TEST is your User, web the password and pwd the TNS-Identifier ? I have a 8.1.6 DB (i guess thats what you have too), i#m using OCI8 libaries and

[PHP-DB] query help

can anyone figure out why the following code works fine when both select variables = "ALL" and also when only 1 of the 2 ="ALL" but NOT when BOTH select variables equal something other than "ALL"? here is the code: What area of the city would you like to dine in? ?php

[PHP-DB] help with PHP and mysql

I have redhat 7.0 with mysql loaded on my box I use myphpadmin and I get this response Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in db.php on line 60 Warning: MySQL: A link to the server could not be established in

Re: [PHP-DB] data from db

For instance, if I had a response to a question, called $row['description'], and I searched for "%bryan%", the word 'bryan' would be a different color within the field $row['description']? One way to do this: Instead of directly outputting data to the browser using something like echo or

Re: [PHP-DB] MySQL compacting

I'm afraid there is no articles on this matter. You are facing a database design matter. Auto-increment primary keys must haven't any meaning other than just be the primary key and relate one table to another, if you had a function to "update" the auto-increment field to eliminate the holes that

Re: [PHP-DB] Oracle Newbie

Nothing best Oracle documentation CD, if You have experience in ANSI SQL ... I'm working as system analyst with Oracle product having MS SQL SERVER 6.5 experience. Some statement tuning and dba course will get some extra. Andris Tuesday, February 13, 2001, 9:07:47 AM, you wrote: c Hello

[PHP-DB] RV: Warning in ifx_connect() with PHP and Informix

Hello, I'm working in an intranet application with PHP and Informix. My problem comes when I obtain a WARNING from PHP like that: Warning: E [SQLSTATE=IX 000 SQLCODE=-439] in ../funcionesBD.inc on line 64 The line shown above (64) includes an ifx_connect() statement from a