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

2001-02-12 Thread Paul Gardiner
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

2001-02-12 Thread Bob Hall
>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 count(s

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

2001-02-12 Thread Richard Halford
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

2001-02-12 Thread Marios Moutzouris
>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

2001-02-12 Thread Udo Oehmig
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....

2001-02-12 Thread Marko Perich
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 /etc/p

Re: [PHP-DB] Positioning into a query

2001-02-12 Thread Stas Trefilov
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)

2001-02-12 Thread ajay arora
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)

2001-02-12 Thread Matt Williams
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 un

[PHP-DB] Oracle connectivity

2001-02-12 Thread Randall Barber
There was a post a few days ago here that indicated that PHP could only talk to Oracle databases if they resided on the same machine as the script because PHP could not deal with the TNS resolutions or something to that nature. I have an Oracle database that I need to connect to on another mach

[PHP-DB] newbie warning - how to get next seven days data from separate year, month, day fields

2001-02-12 Thread Timothy Wright
Hello all - I have a PHP/MySQL calendar application that, for some reason, stores the date in 3 separate fields: year, month, day. What I need to do now is create a dropdown menu that gets data for each of the next 7 days by day of the week. For example, if today is Monday, selecting Monday fro

AW: [PHP-DB] Oracle connectivity

2001-02-12 Thread Matthias Kopolt
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 connecti

[PHP-DB] php mysql

2001-02-12 Thread Ramiro Radjiman
I have the following code: $arr_aantal = explode (",", $aantal); $arr_str_men = explode (",", $str_men); $arr_recht = explode (",", $recht); $arr_rechtverstek = explode (",", $rechtverstek); $arr_verstekgelijk = explode (",", $verstekgelijk); $arr_verstekongelijk = explode (",", $verstekongelijk)

[PHP-DB] query help

2001-02-12 Thread Stinsman, Scott
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? \n"; $select.="ALL\n"; w

[PHP-DB] Virus alert

2001-02-12 Thread Alarion
Hey everyone, In case no one has caught it yet, I think I remember seeing a couple emails go through here this morning entitled "Here you have, ;o) " with an attachment "disguised" as a jpg of Anna Kournikova. I rememebr seeing the subject but I deleted it cause the subject didn't interest me. An

[PHP-DB] data from db

2001-02-12 Thread bryan
To smarter people than I: Umm, I have a search that is defined by several input fields. Question at hand (and I have no idea if this is possible), is there a way to highlight in my selection the word searched upon? For instance, if I had a response to a question, called $row['description'], an

[PHP-DB] data from db[2]

2001-02-12 Thread bryan
nevermind. i was having trouble with the str_replace (i saw where I said strstr, but I meant str_replace).. I thought it should do what it did, and I finally got it! $edited_user = str_replace ($seperated[0], "$seperated[0]", $row['topic']); thanks for your time! bryan Bryan Fitch Programme

[PHP-DB] help with PHP and mysql

2001-02-12 Thread Flaherty, James
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 d

Re: [PHP-DB] data from db

2001-02-12 Thread Jamie Alessio
> 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

[PHP-DB] Running a TCL script from PHP

2001-02-12 Thread Noodles Grizzly
G'day, I have a TCL script that reads one line from a file (generated by a php script), checks it against an authoritive nameserver, then returns a one line value into another file. On it's own, the script work perfectly. But I'm having trouble including it in php code so that it executes durin

Re: [PHP-DB] MySQL compacting

2001-02-12 Thread JJeffman
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

[PHP-DB] Problems with images in the db

2001-02-12 Thread Sunil Jagarlamudi
Hi, I have inserted small images into the db and I am trying to echo them back and when I do it, I keep getting the Header warnings. How do I overcome that ? When I try to just echo the image it works fine, but when I try to add a few more lines like echoing other rows which have firstname and la

[PHP-DB] Oracle Newbie

2001-02-12 Thread cfrostrun
Hello everyone, I was wondering if anybody would like to share real world experiences in development and deployment of oracle and php. I'm extremely new to oracle & am in the early process of starting to map out a redesign & conversion of a site from postgres to oracle. I am trying to get as

Re: [PHP-DB] Oracle Newbie

2001-02-12 Thread Andris Jancevskis
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 every

[PHP-DB] presentation to the list

2001-02-12 Thread alejandro . jose
Hello, I'm new to the list and I would like to present myself. My name is Alejandro and I'm a 25 years old engineer in computer science from Alicante (Spain). In my current job, in my city council, I'm programming (or trying to do so) an Intranet application under PHP+Apache+Informix. This is the

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

2001-02-12 Thread alejandro . jose
> 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 fr