[PHP-DB] csv without line feed

the 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] csv without line feed

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 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 28

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] 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

[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

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 development

[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]

[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] 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:

[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

[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

[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

[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

[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

[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:

[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,

[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 List

[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] 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] 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

[PHP-DB] MS SQL 6.5 connection

= ; $dbc=mssql_connect($conn, $myuser, $mypass) or die (Unable to connect MS SQL); ? here is freetds config SQLSERVER query tcp tds4.2 203.144.255.71 1443 master tcp tds4.2 203.144.255.71 1443 Regards, Sommai Fongnamthip -- PHP Database Mailing List (http://www.php.net

[PHP-DB] ms sql connect

php code ? $host = myserver; $myuser = sa; $mypass = ; $numero=mssql_connect($host, $myuser, $mypass) or die (Unable to connect to database.); echo (ConnectID: $numerobr\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] 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] 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

[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] 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] 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