[PHP-DB] Call to undefined function: mysql_pconnect()

2001-04-09 Thread Bruno
Hello, I am getting this error when I run a program that tries to access a mySQL DB trough PHP4. I've read that this error appears when the module for mySQL isn't present. I have this module here : /usr/lib/php4/extensions/mysql.so And on my /etc/php4/apache/php.ini, I have the following : ext

Re: [PHP-DB] Call to undefined function: mysql_pconnect()

2001-04-09 Thread B. van Ouwerkerk
>I am getting this error when I run a program that tries to access a mySQL DB >trough PHP4. I've read that this error appears when the module for mySQL >isn't present. A bit of code could help.. if it's caused by the wrong .so, you could try what happens if you compily PHP with the .so from the

[PHP-DB] overrun??

2001-04-09 Thread Russ Michell
Hi all: I use PHP4pl1 with MySQL 3.22.32 Whenever I go onto my php website, specifically onto a page with a DB connection requesting something from it, there is what can only be described as overrun. By this I mean the page displays in seconds but the hourglass icon continues to to rotate for

RE: [PHP-DB] overrun??

2001-04-09 Thread Ben Cairns
Closing a MySQL connection is a good habit to get into, However, what you describe, doesn't sound like a PHP error, it may just be one of the many errors with msie rearing its head. -- Ben Cairns - Head Of Technical Operations intasept.COM Tel: 01332 365333 Fax: 01332 346010 E-Mail: [EMAIL PRO

Re: RE: [PHP-DB] overrun??

2001-04-09 Thread Russ Michell
Cheers Ben. However if I close a connection, how is it possible to reconnect if the connection needs to be reused, i.e if further DB data is requested? Is it just a matter if refreshing the page and it all resets?? Russ #---#

Re: [PHP-DB] overrun??

2001-04-09 Thread B. van Ouwerkerk
>I use PHP4pl1 with MySQL 3.22.32 That's OLD. 3.23.36 is current. Does other connects run without a problem? like with other databases?? If not, try what happens if you upgrade mysql to current and recompile PHP.. please, use the right API version.. I always prefer to use the one that comes

[PHP-DB] Limiting Return from DB

2001-04-09 Thread Jonathan Underfoot
I'm working on a project where articles are stored in a text / blob in a MySql DB. I need to truncate a certain amount of data from those articles for sort of a "preview." (First Paragraph... all data untill the first (second etc) line break) Any ideas? Theres probably some PHP command I'm

[PHP-DB] overrun?

2001-04-09 Thread Russ Michell
Whoa there!! It's no *BIG* deal! It all works fine I just wondered why the connecton seemed to linger a little longer than it should! I'll go with Ben's idea and close off the connectons at the bottom of my script. As for using a new version of MySQL - what's the point? It works fine. I can in

[PHP-DB] Eval statement

2001-04-09 Thread Bartek Pawlik
Hi, Sorry, but it's no connected with PHP+DB, but I can't find answer enywhere Supouse I have $number=123; what i want is eval ("$kg"+$number) and print it. PS. $number takes different values; Thanks in advance Bartek Pawlik Poland --

Re: [PHP-DB] Eval statement

2001-04-09 Thread John
Hello, Eval must be a statement, not an expression. eval("\$result=$number1+$number2;"); print $result; John ""Bartek Pawlik"" <[EMAIL PROTECTED]> wrote in message 003101c0c0d6$48546a40$539f4dd5@administrator">news:003101c0c0d6$48546a40$539f4dd5@administrator... Hi, Sorry, but it's no

Re: [PHP-DB] overrun?

2001-04-09 Thread B. van Ouwerkerk
>WHy on earth >would I want to upgrade to a new version which would prob take me all >day, maybe crash the server on which several important websites sit on, >and is generally more hassle than it's worth. Reasons for upgrading: new features, security issues, bugfixes, want to have ;) It

Re: [PHP-DB] Re: PostgreSQL versus MySQL

2001-04-09 Thread Bob Hall
>On Sun, 8 Apr 2001, Bob Hall wrote: > > > Doug, > > > > You've posted your usual good sense, combined with one statement I > > strongly disagree with. > > > > >One of > > >these products is a relational database management system. The other is a > > >quasi-SQL-like-front-end-to-systems-o

Re: [PHP-DB] Re: PostgreSQL versus MySQL

2001-04-09 Thread The Hermit Hacker
On Mon, 9 Apr 2001, Bob Hall wrote: > > MySQL is providing an SQL frontend to a > >bunch of tables and indices, that is it ... it is up to the programmer to > >handle the "managing of data" part where it revolves around being > >relational ... > > I've developed database apps in which the data w

[PHP-DB] Separating paragraphs in mySQL?

2001-04-09 Thread sam
Hello, I have this field filled up from within a text area. Something the same as that on message boards but something that has more characters in it. I have it set to get up to 1500 characters. My main problem is that although I tried inserting separate paragraphs (by pressing the return/enter

RE: [PHP-DB] Separating paragraphs in mySQL?

2001-04-09 Thread Ben Cairns
have a look at the wordwrap() functions in the PHP manual -- Ben Cairns - Head Of Technical Operations intasept.COM Tel: 01332 365333 Fax: 01332 346010 E-Mail: [EMAIL PROTECTED] Web: http://www.intasept.com "MAKING sense of the INFORMATION TECHNOLOGY age @ WORK.." -- PHP Database Mailing

Re: [PHP-DB] Images donot appear

2001-04-09 Thread Sharmad Naik
On Mon, Apr 09, 2001 at 08:08:47AM +0100, Corin Rathbone wrote: > If you are using windows, > Uncomment (un ;) the following line in php.ini > extension=php_gd.dll > I m using Linux.What to do then .I looked at the ini file .There r gd options for only Windoze.What do i do now or do i require a

Re: [PHP-DB] Separating paragraphs in mySQL?

2001-04-09 Thread Doug Semig
nl2br() is useful in such cases. http://www.php.net/manual/en/html/function.nl2br.html Doug At 11:32 AM 4/9/01 +0800, sam wrote: >Hello, > >I have this field filled up from within a text area. Something the same as >that on message boards but something that has more characters in it. I have >it

Odp: [PHP-DB] Re: PostgreSQL versus MySQL

2001-04-09 Thread Jarek Zgoda
Od: "Bob Hall" <[EMAIL PROTECTED]> Temat: Re: [PHP-DB] Re: PostgreSQL versus MySQL > > > The implication is that MySQL is not an RDBMS. The only attempt I > > > know of to define an RDBMS was Codd's, and no DBMS has ever met the > > > criteria he published in a paper in the late 80s (1986?).

[PHP-DB] php/mysql error

2001-04-09 Thread Liz Bander
This is the error that I've gotten since I switched servers a week-ish ago. No idea why, doesn't make any sense to me. I'm running MySQL 3.23 and the latest versions of Apache and PHP. We used the nusphere install. Warning: Supplied argument is not a valid MySQL result resource in /usr/loca

Re: [PHP-DB] php/mysql error

2001-04-09 Thread Rasmus Lerdorf
Always check for errors on a mysql_query() call. Like so: $result = mysql_query($cd_qry); if(!$result) { echo mysql_errno().":".mysql_error(); } That should give you an idea. Usually this error happens when your query fails for some reason and thus it doesn't return any rows. When you the

[PHP-DB] Re: installation blues with oracle 8i

2001-04-09 Thread Brian.J.Mauter
On your configure script try this: ./configure --with-oci=/path/to/your/oracle/installation/home I think your PHP configure script still cannot find the Oracle home directory (have you set ORACLE_HOME in your environment?). Good luck, Brian Mauter [EMAIL PROTECTED] -- PHP Database Mailing

[PHP-DB] Help please

2001-04-09 Thread webmaster
Hi all, I have a website that I am trying to develop a "add news" page for. Basically people who have the authority to add news for the site can type in their username, password, the title of the article, and the article itself and submit it to the site (which then verifies the username and passw

Re: [PHP-DB] Help please

2001-04-09 Thread Indri
It's best if you can supply the full code. Code may not need to be attached, you can just put in a text file and send the link so that we all can read. Error in line 42 DOES NOT mean the error is in line 42, sometimes the error can be in the couple of lines before line 42. Best wishes, Indri --

[PHP-DB] 2-Table query

2001-04-09 Thread Randall Barber
I would like to update two tables at the same time. Currently I update each one separately, like so, $qryStr = "INSERT INTO table1 etc"; odbc_exec($dbConn, $qryStr); $qryStr = "INSERT INTO table2 etc"; odbc_exec($dbConn, $qryStr); Now, the problem there is if the first one passes, but

[PHP-DB] mysql.max_links

2001-04-09 Thread Leavell Digital Design
I am looking at a hosting provider that has mysql.max_links set to 15. Anyone have any experience on the amout of traffic that would handle. I want to move a client to that provider but am concerned this limitation would cripple a dynamic mysql based site. TIA, Kevin Leavell Leavell Digital Des

[PHP-DB] Back up database.....

2001-04-09 Thread E K L
Hi all, I'm having this problem in backuping my database which is in Mysql from one server to another server. The servers are in different location and having different ip address. So, can any one come to me and consult? Your help is much appreciate, thank you E K __

Re: [PHP-DB] Back up database.....

2001-04-09 Thread John Starkey
I'm on Linux and Unix and I just run a cron job each night to tar and gzip the datadirs. Then I use rsync tunneled thru ssh to sync the remote and local files. I couldn't tell you how to do it one Windoze though. Hope this helps. E K L wrote: > Hi all, > >I'm having this problem in backupi

[PHP-DB] Soap in php

2001-04-09 Thread Rob Wheeldon
Anyone here know of a good php soap tutorial? I have tried the one at gigatrends, but had no luck -- 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 P

[PHP-DB] Robust OO Shopping Cart 4 sale

2001-04-09 Thread Rob Wheeldon
Hello all, PHP\MySQL shopping cart for sale www.firegarden.com/cart/ still under development (good price if you buy now). Top notch OO coding garenteed. go to firegarden.com and click the email link for more info. Rob -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e

Re: [PHP-DB] Back up database.....

2001-04-09 Thread E K L
Ok, thanks for ur suggestion...But, can u explain in more detail on how those command works? thanks >From: John Starkey <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: E K L <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: [PHP-DB] Back up database. >Date: Mon, 09 Apr 2001

Re: [PHP-DB] Back up database.....

2001-04-09 Thread John Starkey
cron is a timing app for unix. man cron will tell you how to set it up, sorry but I'm kinda swamped. But basically you can set it up to run commands at certain intervals. tar originated as a tape archiving system and basically you use it before gzip to bundle everything together. rsync is a remo

Re: [PHP-DB] Back up database.....

2001-04-09 Thread E K L
HI John, Thanks for ur prompt reply.Actually, i'm facing the setting crontab problem as wellI posted the question to ask advice at the same time i asked u the backuping processBelow is the mail i have when the schedule failed: >your terminal lacks the ability to clear the screen

Re: [PHP-DB] Robust OO Shopping Cart 4 sale

2001-04-09 Thread B. van Ouwerkerk
>development (good price if you buy now). Top notch OO coding garenteed. go >to firegarden.com and click the email link for more info. Why are you spamming this list shoppingcart FOR SALE?? There are LOTS of very very good shoppingcarts for FREE.. anyone interested should take a look at so

Re: [PHP-DB] Call to undefined function: mysql_pconnect()

2001-04-09 Thread Bruno
Hello, Here's the code : if (DB_PCONNECT == true) { $connectfunc = "mysql_pconnect"; } else { $connectfunc = "mysql_connect";

Re: [PHP-DB] Robust OO Shopping Cart 4 sale

2001-04-09 Thread Rick St Jean
Where else should someone post something like this? I think that more appropriately if should be on the php-general list but this is php related. I would not be hearing you complain if he said that he was posting the code for free. BTW all the open source carts out there really suck. I guess