[PHP-DB] Re: php and db/c

[EMAIL PROTECTED] wrote: Hello everyone, We are running an old database system called db/c and attempting to access the information via php. We have managed to make an odbc connection to the databases, and can successfully retrieve the field names, and field counts. However, php insists the

RE: [PHP-DB] Database Connection

You need to specify some env variables before you connect: heres what I do. # putenv("LD_LIBRARY_PATH=/home/db2inst1/sqllib/lib"); putenv("DB2INSTANCE=db2inst1"); #

RE: [PHP-DB] Can't unserialize array from mysql

Either 1. Don't addslashes before you serialize it 2. use stripslashes before you unserialize it > -Original Message- > From: Jim Doolittle [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 03, 2001 9:07 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Can't unserialize array from mysql

RE: [PHP-DB] Variables in a loop

http://www.php.net/manual/en/language.variables.variable.php > -Original Message- > From: LeTortorec, Jean-Louis [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 29, 2001 2:04 PM > To: '[EMAIL PROTECTED]' > Subject: [PHP-DB] Variables in a loop > > > I'm trying to write a loop to read

RE: [PHP-DB] Performance problems in NC

This could be due to missing tags such as /body and /html > -Original Message- > From: Andy [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 29, 2001 6:41 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Performance problems in NC > > > Hi there, > > I have problems with the performanc

RE: [PHP-DB] DB2 Performance issue - More Info

ger uses the ODBC cursor library. So I guess this means the message below was related to using a 3rd party odbc driver. Shucks.. Regards Mark > -Original Message- > From: Mark Newnham [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 01, 2001 3:33 PM > To: &#

[PHP-DB] DB2 Performance issue

This was posted on the newsgroup a couple of months ago: Christian Szardenings wrote: > > Hi Andrew, > > thanks a lot for your help. Today we discovered what > our real problem was: > > After "playing" a little bit with the php-scripts that try > to connect to the IBM DB2, we set the optional

RE: [PHP-DB] Re: PHP vs. 2 database softwares

When i was switching back and forth between those 2 environments, I had to remove the config.cache file before doing a 'configure' in order to make it compile correctly. > -Original Message- > From: Scott Fletcher [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 01, 2001 1:50 PM > To: [

[PHP-DB] Windows DLL extension for DB2 needed

Does anyone have a dll extension to enable access to DB2 from PHP 4? I don't have access to a Windows compiler. TIA Mark -- 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 administ

RE: [PHP-DB] Storing code in a mysql database

select * from vehicle where company=$company_code' and not 'select * from vehicle where company=1' Any clues? TIA Mark > -Original Message- > From: Mark Newnham [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 19, 2001 2:54 PM > To: '[EMAIL PROTECTED

[PHP-DB] Storing code in a mysql database

I'm trying to store SQL code in a blob field in a mysql database, but i'm having a problem. The code looks like this "$sql='select * from vehicle where company=$company_code';"; After I retrieve it from the db i eval() it to get the result. I can make this work if i store the code in a variable

RE: [PHP-DB] Proper Case Conversion

ucfirst(strtolower($field)); > -Original Message- > From: Keith Spiller [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 16, 2001 12:41 PM > To: Php-db > Cc: MySQL > Subject: [PHP-DB] Proper Case Conversion > > > Hello, > > I'm reading data from a mysql table that is entirely in >

RE: [PHP-DB] PHP x Progress

Yes, ODBC - If you are using unix, i recommend the openlink MT drivers (www.openlinksw.com) There is no native mode interface available for PROGRESS. > -Original Message- > From: André [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 23, 2001 11:42 AM > To: [EMAIL PROTECTED] > Subject: [PH

[PHP-DB] using ADODB db class

Not sure if this is really the right list to ask on, so please excuse me. I am trying to use the adodb db class with php4/mysql. On problem i have hit is that if i retrieve 2 tables with a join and the 2 tables both have a field of the same name, the command $result->fields("fieldname") always

RE: [PHP-DB] Problems with PHP / Progress / ODBC

Progress databases prefer the odbc_prepare, odbc_execute sequence over the odbc_exec functions ( I don't know why ) > -Original Message- > From: indrek siitan [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 08, 2001 11:38 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: [PHP-DB] P

[PHP-DB] odbc_tableprivileges help required

Warning: SQL error: , SQL state 0 in SQLTablePrivileges in /opt/apache/lib/htdocs/poinv/test.php on line 9 Warning: Supplied argument is not a valid ODBC result resource in /opt/apache/lib/htdocs/poinv/test.php on line 11 So my understanding of this is obviously incorrect Thanks Mark ##

RE: [PHP-DB] File Optimisation

The first thing I would look at ( having had the same issue ) is whats actually in the document. I managed to reduce the size of data delivered by 60% by 2 methods. 1. Ruthless use of css in table formatting. 2. Creating javascript functions for even the smallest inline feature such as mouseover

[PHP-DB] Problem with odbc_field_type?

Is there a problem with odbc_field_type? I always receive a null back. I dont have a problem with odbc_field_len. Is it perhaps that some db types don't respond correctly. Thanks Mark -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional co

RE: [PHP-DB] Redirect command?

if ( $x==true) { print "\n"; print "window.open('b.php','_self');\n"; print "\n"; die; } > -Original Message- > From: Julio Cuz, Jr. [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 22, 2001 3:23 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Redirect command? > >

RE: [PHP-DB] SELECT problem (2)

You probably want this.options[this.selectedIndex].value > -Original Message- > From: Julio Cuz, Jr. [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 22, 2001 2:36 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] SELECT problem (2) > > > Hi-- > > Sorry, I forgot to finish the pr

RE: [PHP-DB] Windows 2000 follow up

> Also i hear > that running a server on windows 2000 is just as good if not > better then unix.. Oh god, let's not get started on that.. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To con

RE: [PHP-DB] runing a query and a another task at the same time

I may be mistaken, but I believe that something as simple as calling a javascript window.open function effectively starts a parallel process, i.e. it is a non-blocking operation in a browser heres the sample code i used to test it. 1. A frameset with 2 frames, A and B. frame A has src=test1.php

RE: [PHP-DB] PHP and PROGRESS

suggest you subscribe to the webspeed/servers/sql92 (depending on your progress version) list at www.peg.com, which is where the progress/php discussions/arguments are voiced... > -Original Message- > From: Hector Banda [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 29, 2001 4:55 PM >

[PHP-DB] SQL/ODBC query returns two variables of same name

I have a complex sql query with a self-join that returns 2 variables of the same name. using the variable name in odbc_result() always returns the first instance. Is there any way that I can retrieve the second instance? Thanks Mark -- PHP Database Mailing List (http://www.php.net/) To u

RE: [PHP-DB] query error

Looks fine, now retrieve the rows from the query. > -Original Message- > From: Randy Johnson [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 25, 2001 12:46 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] query error > > > When I run any kind of query this is the value of result

RE: [PHP-DB] Help with loop

$res = mysql_query("SELECT * FROM ecomm where ID ='$sid'",$db)) if(!$res){echo("error preforming query: " . mysql_error());exit();} //error trap while( $row=mysql_fetch_array($res)){ $pno=$row["part"]; ######

[PHP-DB] Problem upgrading to 4.0.4

Platform: HPUX 10.20 Configuration: PHP4.0.1pl2 --with-iodbc --without-mysql --with-pdflib=/usr/local --without-gd --with-apache=../apache_1.3.14 Using Openlink MT ODBC driver against a PROGRESS database. Everything in the above configuration is working fine, but I have just attempted to