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

2003-01-03 Thread Mark Newnham
[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

RE: [PHP-DB] Database Connection

2002-02-05 Thread Mark Newnham
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] Performance problems in NC

2001-10-29 Thread Mark Newnham
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 performance while

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

2001-10-02 Thread Mark Newnham
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: '[EMAIL PROTECTED]' Subject

[PHP-DB] Windows DLL extension for DB2 needed

2001-10-01 Thread Mark Newnham
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

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

2001-10-01 Thread Mark Newnham
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] DB2 Performance issue

2001-10-01 Thread Mark Newnham
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

[PHP-DB] Storing code in a mysql database

2001-09-19 Thread Mark Newnham
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] Storing code in a mysql database

2001-09-19 Thread Mark Newnham
=$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]' Subject: [PHP-DB] Storing code in a mysql database I'm trying

RE: [PHP-DB] PHP x Progress

2001-07-23 Thread Mark Newnham
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:

[PHP-DB] using ADODB db class

2001-07-10 Thread Mark Newnham
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

[PHP-DB] odbc_tableprivileges help required

2001-05-02 Thread Mark Newnham
/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 # Mark Newnham Application

RE: [PHP-DB] File Optimisation

2001-03-14 Thread Mark Newnham
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

[PHP-DB] Problem with odbc_field_type?

2001-03-05 Thread Mark Newnham
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

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

2001-02-22 Thread Mark Newnham
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 previous

RE: [PHP-DB] Redirect command?

2001-02-22 Thread Mark Newnham
if ( $x==true) { print "script language='javascript'\n"; print "window.open('b.php','_self');\n"; print "/script\n"; die; } -Original Message- From: Julio Cuz, Jr. [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 3:23 PM To: [EMAIL PROTECTED] Subject:

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

2001-02-19 Thread Mark Newnham
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] Help with loop

2001-01-25 Thread Mark Newnham
$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"]; ####

RE: [PHP-DB] query error

2001-01-25 Thread Mark Newnham
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