[PHP-DB] cant insert into specific column in specific row...help?

2004-03-18 Thread AJ Seelund
im trying to insert, or more or less, add to the number in a column called (comNum) in one a specific row in one table(dm_blog), and add other values to another table(comments). i have the comments table working fine, everything insert correctly, but im trying to add to the count (comNum) in dm

Re: [PHP-DB] Oracle/PHP & Instant-Client ( remote connection )

2004-03-18 Thread Christopher Jones
Comments below. Jim Morrison wrote: Hello all, Hope this isn't an FAQ - have trawled google, otn.oracle, php.net etc - not sure I can find the answer.. I've been using php&mySql for a while now and getting on great - however I'm now tasked with getting my php to talk to a _remote_ ( right next t

Re: [PHP-DB] Re: SQL Server Query Failed

2004-03-18 Thread Frank M. Kromann
Hi David, You problem might be a thread safty issue. the MSSQL extension is not thread safe (caused by the Microsoft Library used to create the extension). Use CGI or FastCGI to avoid this problem. - Frank P.S. I don't have the full thread of this discussion so I might miss some important inform

[PHP-DB] Re: SQL Server Query Failed

2004-03-18 Thread david
Bruno: I did that. I had to wait a bit until it failed again, whcih it did a few moments ago. Alas, there is not one thing out of the ordinary in the log. Any other suggestions? THANK YOU! david "Bruno Ferreira" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > david wrote: > > >Hel

Re: [PHP-DB] Processing a fetched external page

2004-03-18 Thread Justin Patrin
Donovan Hutchinson wrote: Thanks for the fast replies. I understand about stripping tags and identifying areas using regular expressions, however my intention is to display the page intact, with only the content changed. An example being http://www.pootpoot.com/poot/pootify/ Thanks, Don If you'r

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread W. D.
At 09:20 3/18/2004, Adam Voigt wrote: >I don't understand, your ready to hack the MySQL extension, rather then >just use one of the free text editors, that let you mass replace all >your pages at once (which takes roughly 10 seconds)? Adam is right. Make backups of all the files, then do the edit

Re: [PHP-DB] Processing a fetched external page

2004-03-18 Thread Donovan Hutchinson
Thanks for the fast replies. I understand about stripping tags and identifying areas using regular expressions, however my intention is to display the page intact, with only the content changed. An example being http://www.pootpoot.com/poot/pootify/ Thanks, Don -- PHP Database Mailing List (ht

Re: [PHP-DB] Processing a fetched external page

2004-03-18 Thread jeffrey_n_Dyke
I'm working on a project that takes the content of a URL and does stuff with the content. I've managed to extract the target url's html, and am using str_replace to fix links, stylesheets etc. However, i'm stumped when it comes to processing the text content. Would anyone know how to isolate dis

Re: [PHP-DB] Processing a fetched external page

2004-03-18 Thread Bruno Ferreira
Donovan Hutchinson wrote: I'm working on a project that takes the content of a URL and does stuff with the content. I've managed to extract the target url's html, and am using str_replace to fix links, stylesheets etc. However, i'm stumped when it comes to processing the text content. Would anyon

[PHP-DB] Re: Processing a fetched external page

2004-03-18 Thread Justin Patrin
Donovan Hutchinson wrote: Hi, I'm working on a project that takes the content of a URL and does stuff with the content. I've managed to extract the target url's html, and am using str_replace to fix links, stylesheets etc. However, i'm stumped when it comes to processing the text content. Would

[PHP-DB] Processing a fetched external page

2004-03-18 Thread Donovan Hutchinson
Hi, I'm working on a project that takes the content of a URL and does stuff with the content. I've managed to extract the target url's html, and am using str_replace to fix links, stylesheets etc. However, i'm stumped when it comes to processing the text content. Would anyone know how to isola

Re: [PHP-DB] OK, ahí voy...

2004-03-18 Thread Bruno Ferreira
Felipe Eduardo Ortiz López wrote: My first question: Has PHP some editor or IDE kinda HTML has? I'll be clear: for instance i can work with FrontPage, or text edito to generate the HTML files, it does exist something similar for PHP? Look, I'll be straight and blunt here... If you're asking

[PHP-DB] Re: OK, ahí voy...

2004-03-18 Thread user
Felipe eduardo ortiz lópez wrote: Mi primera pregunta: ¿PHP tiene algún editor o IDE tipo las que tiene HTML? Clarifico; por ejemplo puedo trabajar con FrontPage, o el editor de textos, para generar los archivos HTML, ¿existe algo así para PHP? My first question: Has PHP some editor or IDE kinda HT

[PHP-DB] OK, ahí voy...

2004-03-18 Thread Felipe Eduardo Ortiz López
Mi primera pregunta: ¿PHP tiene algún editor o IDE tipo las que tiene HTML? Clarifico; por ejemplo puedo trabajar con FrontPage, o el editor de textos, para generar los archivos HTML, ¿existe algo así para PHP? My first question: Has PHP some editor or IDE kinda HTML has? I'll be clear: for insta

[PHP-DB] RE: An old dog, with a new trick..

2004-03-18 Thread Rolf van de Krol
I can recommend this book: PHP4 Bible Tim Converse and Joyce Park http://www.amazon.com/exec/obidos/tg/detail/-/0764549553/qid=1079629430/sr=1 -3/ref=sr_1_3/104-4532765-3387128?v=glance&s=books I teached myself PHP with book. (Dutch edition) Rolf ///

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread Justin Patrin
Operator wrote: On 18 Mar 2004 at 14:24, Ricardo Lopes wrote: in your php.ini you have mysql.default_host, mysql.default_user and mysql.default_password which are used if: a) you are not in safe mode b) you supply no string for those parameters. But i guess this is not your case, i think this do

[PHP-DB] Re: An old dog, with a new trick..

2004-03-18 Thread Justin Patrin
If you're just starting out, this is a great time to learn PEAR DB as it can help you a lot in the future. In fact, PEAR is a great place to look for lots of code to do all sorts of things. http://pear.php.net http://pear.php.net/package/DB Felipe eduardo ortiz lópez wrote: Bueno, héme aquí, un

Re: [PHP-DB] MySQL Multi-DB Join

2004-03-18 Thread John W. Holmes
From: "Rod Strumbel" <[EMAIL PROTECTED]> > If you can select just one db, then what is that > select_db command really doing? All it's doing is issuing a "USE database" query so you can say SELECT * FROM table instead of SELECT * FROM database.table You want to use select_db() so that you don

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread John W. Holmes
From: "Operator" <[EMAIL PROTECTED]> > Probably I need to change this behaviour in > ext/mysql/libmysql/libmysql.c for my installation, but this is > my last hope (mostly because I'm not a C programist...) If some > of you could tell me if it's possible without breaking > something else, or point

RE: [PHP-DB] MySQL Multi-DB Join

2004-03-18 Thread Peter Lovatt
I think as you are specifying the db in the query you dont need to select it. If you do, mysql still uses DBs as specified in the query. Peter > -Original Message- > From: Rod Strumbel [mailto:[EMAIL PROTECTED] > Sent: 18 March 2004 15:14 > To: 'Peter Lovatt'; '[EMAIL PROTECTED]' > Subj

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread Adam Voigt
I don't understand, your ready to hack the MySQL extension, rather then just use one of the free text editors, that let you mass replace all your pages at once (which takes roughly 10 seconds)? On Thu, 2004-03-18 at 10:15, Operator wrote: > Probably I need to change this behaviour in > ext/mysql

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread Operator
On 18 Mar 2004 at 14:24, Ricardo Lopes wrote: > in your php.ini you have mysql.default_host, mysql.default_user and > mysql.default_password which are used if: > > a) you are not in safe mode > b) you supply no string for those parameters. > > But i guess this is not your case, i think this does

RE: [PHP-DB] MySQL Multi-DB Join

2004-03-18 Thread Rod Strumbel
?!? And just use the normal old db selection command for it? Which of the DBs would you select, or does it matter? mysql_select_db($databasename,$dbhandle); Think that is what has been confusing me. If you can select just one db, then what is that select_db command really doing? Is it just est

RE: [PHP-DB] MySQL Multi-DB Join

2004-03-18 Thread Peter Lovatt
assuming the dtaabases are on the same server $query = " select db1.table1.field from db1.table1, db2.table2 where db1.table1.field1 = db2.table2.field2 " $result = mysql_query($query,$conection) HTH Peter > -Original Message- > From: Rod Strumbel [mailto:[EMAIL PROTECTED] > Sent: 1

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread Operator
On 18 Mar 2004 at 9:22, Peter Beckman wrote: > Change, in the /etc/hosts file, this: > > localhost 209.10.33.12# new db server > > Hopefully this will work. Haven't tested, just a suggestion. Probably > breaks a few other things, but at least mysql will work. Tested before, doesn't

[PHP-DB] MySQL Multi-DB Join

2004-03-18 Thread Rod Strumbel
Is there a way through the php mysql commands to join tables between databases? Is simple enough at MySQL command line, but can't for the life of me figure out how to do it in PHP. Thanks all, R

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread Ricardo Lopes
in your php.ini you have mysql.default_host, mysql.default_user and mysql.default_password which are used if: a) you are not in safe mode b) you supply no string for those parameters. But i guess this is not your case, i think this doesnt help, but i had an ideia, you could set your server (http)

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread Peter Beckman
Change, in the /etc/hosts file, this: localhost 209.10.33.12# new db server Hopefully this will work. Haven't tested, just a suggestion. Probably breaks a few other things, but at least mysql will work. Beckman On Thu, 18 Mar 2004, Operator wrote: > Hi everyone, > > I need to put m

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread Operator
On 18 Mar 2004 at 11:15, Ricardo Lopes wrote: > What is the problem in changig localhost in houndreds of scripts, ou can do > that with a script or a good text editor that has the function Replace in > Files... can do the trick. Changing scripts is not a main factor here (but it's not as simple a

RE: [PHP-DB] An old dog, with a new trick..

2004-03-18 Thread Galbreath, Mark A
You bet! http://www.catb.org/~esr/faqs/smart-questions.html Mark -Original Message- From: Felipe Eduardo Ortiz López [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 17, 2004 11:06 PM To: lPHP and Databases; [EMAIL PROTECTED]; lPHP For Windows; lPHP Para Todos Subject: [PHP-DB] An old do

[PHP-DB] Oracle/PHP & Instant-Client ( remote connection )

2004-03-18 Thread Jim Morrison
Hello all, Hope this isn't an FAQ - have trawled google, otn.oracle, php.net etc - not sure I can find the answer.. I've been using php&mySql for a while now and getting on great - however I'm now tasked with getting my php to talk to a _remote_ ( right next to me but separate ) Oracle server...

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread Ricardo Lopes
What is the problem in changig localhost in houndreds of scripts, ou can do that with a script or a good text editor that has the function Replace in Files... can do the trick. I dont think that editing the host file to make localhost point to the other machine is a good practice. :) - Origin

Re: [PHP-DB] An old dog, with a new trick..

2004-03-18 Thread Ricardo Lopes
So you want to learn php with mysql, good for you, well if you don't know this is a mailing-list for questions to doubts and in your post you have none. If you want to learn php a good place to start is the PHPManual and another good place is google.com search for "php tutorials" you will get some

[PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread Operator
Hi everyone, I need to put my database server on the another machine - how can I configure system(Debian Linux)/php/mysql etc. to make it work without changing all 'localhost' in a hundreds of customer's scripts? The problem is, when localhost is specified as a host the connection is made using

[PHP-DB] Internal server error

2004-03-18 Thread ..: GamCo :.. Gawie Marais
Hi, Whenever I try and run this .php file I get:- Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [EMAIL PROTECTED] and inform them of the time the error occurred, and anythi