[PHP-DB] ROWS

2004-08-19 Thread Remember14a
Dear Friends, Looking for php script, which can read number of rows in html file and display the same in browser, when contents of file are displayed Any guidance, please. Thank you

[PHP-DB] I have a CR-LF problem when pulling stuff out of my DB

2004-08-19 Thread Michael Cortes
This may not be exaxtly PHP-DB related but it is a result of screwing something up grin. I pulled a bunch of data from a DOS formatted tab seperated file and now I am dumping back out into a text file (on linux). So, as you can imagine, I ended up with a bunch of ^M throughout the file. I

RE: [PHP-DB] I have a CR-LF problem when pulling stuff out of my DB

2004-08-19 Thread Russell Johnson
Actually, an easier tool to use is dos2unix, which is available on most Linux boxes. Just type dos2unix [filename], and you should be all set. - Russ Johnson Sabadell Spain -Mensaje original- De: Michael Cortes [mailto:[EMAIL PROTECTED] Enviado el: Thursday, August 19, 2004 1:36 PM

Re: [PHP-DB] I have a CR-LF problem when pulling stuff out of my DB

2004-08-19 Thread Michael Cortes
That didn't work. Here's why. This is not a dos file. It is a unix file but when dumping the data from my db, some fields had a trailing CR and LF. So what I ended up with was a ^M showing in the middle of a line when I open the file in vim. And... the lines will also end where they

Re: [PHP-DB] I have a CR-LF problem when pulling stuff out of my DB

2004-08-19 Thread Michael Cortes
I found part of the answer.. when doing a search in vim you can hit ctrl-m as long as you hit ctrl-v first. ctrl-v tells vim to treat the following as a character, not to do the action i.e... carriage return. Now I need just one more piece, if anyone has the answer: ctrl-m is a carriage

[PHP-DB] IBM DB2

2004-08-19 Thread Robert Twitty
Hi Is anyone using PHP to connect to an IBM DB2 database? The reason why I am asking is becaouse I want to see if the odbtp extension can be used to successfully prepare and execute DB2 stored procedures. So far, ODBTP performs quite well with IBM DB2 in regards to regular queries. -- bob --

RE: [PHP-DB] I have a CR-LF problem when pulling stuff out of my DB

2004-08-19 Thread Ford, Mike [LSS]
On 19 August 2004 17:02, Michael Cortes wrote: ctrl-m is a carriage return. Does anyone know what ctrl seqence is line feed? ctrl-j (CR and LF are ASCII codes 13 and 10, so ctrl+ the 13th and 10th letters of the alphabet respectively!) Cheers! Mike

Re: [PHP-DB] I have a CR-LF problem when pulling stuff out of my DB

2004-08-19 Thread randy
Maybe I'm missing something...but why not do this with PHP (seeing as how this is a PHP list)? ereg_replace('(\r|\n)', ' ', $string) Just a thought On Thu, 19 Aug 2004 12:01:46 -0400, Michael Cortes [EMAIL PROTECTED] wrote: I found part of the answer.. when doing a search in vim you can

[PHP-DB] Postgresql Performance

2004-08-19 Thread Norma Ramirez
Hi all, I have a problem with a small software in Postresql, through the time the database become slower and slower so, quick solution: pg_dump, dropdb, createdb and pg_dump again but this software is becoming important and such procedure is not a very reliable way to improve the performance, I

Re: [PHP-DB] Postgresql Performance

2004-08-19 Thread Matt M.
On Thu, 19 Aug 2004 18:12:16 -0500, Norma Ramirez [EMAIL PROTECTED] wrote: Hi all, I have a problem with a small software in Postresql, through the time the database become slower and slower so, quick solution: pg_dump, dropdb, createdb and pg_dump again but this software is becoming important

Re: [PHP-DB] IBM DB2

2004-08-19 Thread Gerard Samuel
Robert Twitty wrote: Hi Is anyone using PHP to connect to an IBM DB2 database? The reason why I am asking is becaouse I want to see if the odbtp extension can be used to successfully prepare and execute DB2 stored procedures. So far, ODBTP performs quite well with IBM DB2 in regards to regular

[PHP-DB]different heading

2004-08-19 Thread balwantsingh
pls. help me. i have made one webpage where user for getting a report checks the checkbox as per his requirement and accordinly only that data is retrieved from mysql. i used array and loop for getting the data. now my problem is that by default column name (of mysql table) is displayed as

Re: [PHP-DB]different heading

2004-08-19 Thread Jason Wong
On Thursday 19 August 2004 18:28, balwantsingh wrote: now my problem is that by default column name (of mysql table) is displayed as heading You are in control of the HTML that goes into the webpage. You don't have to use the column names returned from the mysql query. So where's the problem?