Re: [PHP-DB] csv without line feed

r in one panel >while scrolling thru the file. Compare this against the Excel printout and >you should find what code is being used for lf. > >Hoping that debug is still available from the C: prompt? > >George >----- Original Message - >From: "Sommai Fongnamthip&q

[PHP-DB] csv without line feed

example it attach file. Sommai Fongnamthip. 28-03-2002# #TR DEP##794,299.09#6,288,278.76#043 28-03-2002# #CASH DEP# #34,107.00#6,322,385.76#076 28-03-2002# #CASH DEP##341,410.84#6,663,796.60#005 28-03-2002#6779642 #TR WTD CHQ#62,332.81# #6,601,463.79#047 28-03-2002# #CASH

Re: [PHP-DB] Question about advanced SQL

Hi, I assumed that you was used MySQL for database. With MySQL you can used this SQL to find different row select tblcd.* from tblcd left join tblorder on tblcd.cdid=tblorder.cdid where tblorder.cdid is null sommai At 12:37 28/2/2002 +1000, Adam Royle wrote: >Hi. > >I need

[PHP-DB] slow result

Hi, When I select data from table with mysql prompt or mysql-front-end, it display result fast. But when I put this sql into php, it used more time to display the result. How could I fix this problem or track the problem? Sommai ---

[PHP-DB] query problem

Hi, I have problem with these mysql's query: select * from holder, management where holder.id=management.id or (holder.name=management.name and holder.surname=management.surname) order by holder.no It take a long time (more than 1 minute) with thousand record. I have

[PHP-DB] display text in screen

Hi, I have easy problem to ask someone. I wrote PHP to update data with many step and need to display comment or detail in each step. But I got all comment or detail display after it finished update all step. How could I display each step comment immediately?? Sommai Fongnamthip

[PHP-DB] load text file

Hi, I prefer to used load data infile command to insert text file (CSV format) to MySQL. I wonder that Could load data use with pure text file (no delimiter)? if not how to insert text file in to MySQL faster than read every line? SF -- PHP Database Mailing List (http://www.php.net

[PHP-DB] version conflict

Dear List, I was installed mysql-3.23.47 in my Linux box with PHP. I could shown version correctly with mysql command line or any windows client tools. It still shown in phpinfo with version 3.23.37 (old version before upgrade). What wrong? Did somone know about Zend Optimize

[PHP-DB] variable check in 1 file

Hi, I'd like to create query form and display in 1 file. Do anyone guide me for this? SF -- 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

[PHP-DB] pass variable

Hi, I was successful for use only 1 variable like www.hostname.com/path?variable=xx. How could pass more variable to other program? SF -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] T

Re: [PHP-DB] Unveilled Metabase OOP direct to driver object API

How to compare Metabase to ODBC or ADODB? SF At 06:20 24/12/2001 -0200, Manuel Lemos wrote: >Hello, > >If you are reading this and do not know what is Metabase, be aware that >it is PHP database abstraction package for developing truely portable >database independent functions. Metabase developm

[PHP-DB] search string in text file

Hi, How could search string (like full text search) in any text file (even know or not known filename)? SF -- 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

[PHP-DB] memory leak???

Hi, I have an error when try to query from 2 database (m$ sql). Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 29 bytes) when I check my server memory it have free for a lot total used free sharedbuffers cached Mem:1

[PHP-DB] retrieve data from more db

HI, I have data on more than 1 db to separate in year name like these: cust2000--> contain customer infomation in year 2000 cust2001--> contain customer infomation in year 2001 all db have the same field name. I have put db name and table na

[PHP-DB] select data from more database

Hi, I have data on more than 1 database with same schema. How could I use SQL statement in PHP code to retrieve it for display in 1 time? thanks SF -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PRO

[PHP-DB] multi row handle

Dear, I would like to make a program which can display data in multi row to maintain it with update value, delete row or add new row. How could I handle multi row of data record in web page? SF -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECT

[PHP-DB] create data array

Hi, If I need to use data array like this $data_array = array ( array("text",1,2,3), array("text",4,5,6), array("text",7,8,9) ); all array element are contain in my database. How could I write

[PHP-DB] attach file

Hi, How I retrieve data from DB and make it to mail attachment? I've been read PHP function about mailto but It did not contain any suggestion. SF -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROT

[PHP-DB] crosstab for MS SQL

Hi, MySQL has a method to write Crosstab method but It can't use with MS SQL. Did someone know how to write SQL statement for make cross tab with MS SQL 6.5 (both ODBC and TDS connection)? Thank you SF -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

[PHP-DB] cross tab with mssql

Hi, I was used MS Access to make cross tab query with MS SQL. How could I do this with PHP? I was used syntax of MySQL but It did not work. Thank you, SF This is an example data: Customer#Bill date Bill amount --- A12345

[PHP-DB] join 2 db

Hello, I have been use PHP connect to mssql 6.5 with FreeTDS. I'd like to select data from 2 table with separate in 2 database name. How could I do this? here is some example. DB#1 DB#2 |--> Table#1-in-DB#1 |--

[PHP-DB] db's war

hi I'd like to survey php commnunity about how do you think about merge between informix and ibm? Did there remain only 2 major dbms (oracle and db2)? do you think MySQL will be the leader with next version 4? SF -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-

[PHP-DB] text area handle

Hi, I know this group for PHP-DB, but I could not find any help from PHP-Manual about Text Area Handle. I'd like to accept input with multi-line text box (use textarea quote). How could I get each row value in text area. If someone have better idea to input multiple row in one time

[PHP-DB] join 2 db

Hi, I'd like to retrieve data which contain in 2 db. How could I do? db1->table-in-db1->field-in-table-in-db1 db2->table-in-db2->field-in-table-in-db2 I'd not extract data to new table because I'd like to retrieve data only. thanks SF -- PHP Database Mailing L

[PHP-DB] convert char to numeric in sql

Hi, I have MS SQL 2 column which type is CHAR (in reason of contain more digit of value). How could I write SQL statement to add or convert these 2 column value. Thanks Sommai Fongnamthip -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

[PHP-DB] successful connect to MS SQL

$ SQL.) - M$ SQL 6.2 on NT 4.0 Best Regards, Sommai Fongnamthip -- 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]

[PHP-DB] odbc.ini

Hi, Could someone tell me how to write odbc.ini in Linux and related library to connect MS SQL on NT? Thanks Sommai Fongnamthip -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact

[PHP-DB] best way connect MS SQL

Hi, I wonder which the best way to connect PHP from Linux to MS SQL on NT? - freeTDS - ODBC (iODBC, unixODBC, MyODBC) I was still can not connect with anyone! Regards, Sommai Fongnamthip -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail

[PHP-DB] get local file

Hi, If I'd like to get Linux local filename (eg. filename.bmp, filename.txt) to display in Web with PHP. These filename.* was fill in MySQL column. I have to maintain these local file because I got them from another source. How could I do this? Sommai Fongnamthip -- PHP Dat

[PHP-DB] MS SQL connect by ODBC

Hi, Did someone ever connect PHP (on Linux box) to MS SQL (on NT box) via ODBC (iODBC or unixODBC)? How to config and writing code in PHP? thanks SF -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PRO

[PHP-DB] MS SQL 6.5 connection

tcp tds4.2 203.144.255.71 1443 Regards, Sommai Fongnamthip -- 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]

[PHP-DB] ms sql connect

0.0.1 1433 php code \n"); ?> Regards, Sommai Fongnamthip

RE: [PHP-DB] PHP and Informix installation

Halo, How could I set up Informix driver in my Linux Server? SF At 13:26 27/7/2001 -0500, Muciño Zúñiga Marco Antonio wrote: >OK, I set my LIBS environment variable to my esql -libs result and the >confire shell is OK now, but now I get the next error when running the make >command: > >#

RE: [PHP-DB] report style printing

: [EMAIL PROTECTED] >// [mailto:[EMAIL PROTECTED]] >// Sent: Thursday, 26 July 2001 9:53 PM >// To: Sommai Fongnamthip; [EMAIL PROTECTED] >// Subject: Re: [PHP-DB] report style printing >// >// >// >// I'm confused - what do you mean? When you use the terms >//

Re: [PHP-DB] PATCH for 9i support (was Re: [PHP-DB] Re: Oracle 9i Support)

Hi, I have oracle 8i in Linux server. How could I connect it with PHP (on other server)? SF At 16:57 26/7/2001 -0500, Lee Whatley (System Admin) wrote: >Here is a patch that will allow configure to properly detect oracle 9i >If your mail server filters out attachments you can download

[PHP-DB] report style printing

Hi, When I retrieve data to display on web with PHP, it can print out from web in Browser Stlye. How could we have some PHP code to retrieve current display data into PC and print it with some Custom Report Style? Sommai Fongnamthip -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Re: new data detect

Why PHP cannot do background check with the same of Java Script? At 22:28 25/7/2001 -0400, Hugh Bothwell wrote: >"Sommai Fongnamthip" <[EMAIL PROTECTED]> wrote in message >[EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Hi, > > I decide to make r

[PHP-DB] new data detect

Hi, I decide to make real time application (like stock market or online news). How could I know when new data arrive to table and retrieve them to display or update in web page? Sommai Fongnamthip -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

[PHP-DB] oracle and informix interface

Hi, I've been known that PHP could connect to oracle or informix. But when I try to configure PHP, it tell me that there are some library required. How could I find oracle or informix support library for PHP? Sommai Fongnamthip -- PHP Database Mailing List (http://www.php.net

[PHP-DB] draw graph

Dear, How could I draw graph with gd by using PHP code with custom log scale? Sommai Fongnamthip -- 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