Re: [PHP-DB] mysql_pconnect cannot create two permanent connections to the same machine ?

2006-01-18 Thread Aarno Syvänen
The code worked perfectly when databases 'bebbicell' and 'asterisk' were in the separate machines. It stopped working, when i copied the website to my machine. Aarno On 17 Jan 2006, at 18:48, Micah Stevens wrote: On Tuesday 17 January 2006 7:57 am, Aarno Syvänen wrote: Hi List, I do not

[PHP-DB] Problem with creating parallel connections with mysql_connect

2006-01-18 Thread Aarno Syvänen
Hi List, decided to try non-permanent connections for now. So now I have: $accid=mysql_connect($db_account_server,$db_account_user, $db_account_pass, $allow_multiple); //error_reporting ( $level); mysql_select_db($db_account_db, $accid); ?> Still I have same error: Warning: mysql_query(): s

Re: [PHP-DB] Refreshing text question!

2006-01-18 Thread Julien Bonastre
Sorry I had misinterpreted your question Jerry.. I thought you were trying to refresh the page, missed that keyword :-) Therefore in context the page refresh would be quite annoying, I was only introducing its concept in order to reload the page at a different location. Again, my apologies

Re: [PHP-DB] Refreshing text question!

2006-01-18 Thread Julien Bonastre
And in response, i was sort of heading there with my response.. Checkout my sexy 'quotes' engine on www.operation-scifi.com At bottom of page, there's a link "HOVER ON THIS LINK (Click to change quote)" click it to see the wowness effect Implementing this with a timeout function of JS is qu

Re: [PHP-DB] Problem with creating parallel connections with mysql_connect

2006-01-18 Thread David Robley
On Wed, 18 Jan 2006 19:51, Aarno Syvänen wrote: > Hi List, > > decided to try non-permanent connections for now. So now I have: > > > /* db.php */ > $db_server="127.0.0.1"; > $db_user = "asterisk"; > $db_pass = "bozzo984"; > $db_db = "bebbicell"; > > $db_account_server="127.0.0.1"; > $db_account_

Re: [PHP-DB] Refreshing text question!

2006-01-18 Thread Jeffrey
Well, somebody's got to say it: that question has nothing to do with PHP and MySQL, which are server side. I suggest you Google "free javascript" and you will find dozens of sites offering free java scripts. Many of them will have text/text banner offerings that do what you want to do. Good

Re: [PHP-DB] Refreshing text question!

2006-01-18 Thread JeRRy
Hi, No, no that is not what i am after, I know how to do that but it's not what I want. I wrote some code a year or so ago with words, they refreshed every 5 or so seconds WITHOUT REFRESHING THE PAGE. It was written in JavaScript as i can remember. But I can't find where I did it.

Re: [PHP-DB] Refreshing text question!

2006-01-18 Thread Bastien Koert
google 'rotating banner ad'...basically you hide stuff in divs/layers and show and hide the layers on a set timeout function with js bastien From: JeRRy <[EMAIL PROTECTED]> To: Julien Bonastre <[EMAIL PROTECTED]>, php-db@lists.php.net Subject: Re: [PHP-DB] Refreshing text question! Date: Wed,

Re: [PHP-DB] Problem with creating parallel connections with mysql_connect

2006-01-18 Thread Aarno Syvänen
I go following debug: got error <> when doing first connection resource id was Resource id #3 got error <> when selecting first database got error <> when doing second connection resource id was Resource id #4 got error <> when selecting second database the code was: $bid=mysql_connect($db_serv

Re: [PHP-DB] Refreshing text question!

2006-01-18 Thread tg-php
Two ways I can think of to update part of a page without doing a full refresh: 1. Use an IFRAME so you're technically updating a page, but it's the page within the frame (not my favorite but works ok) 2. Or you can use asynchronous javascript (AJAX) to update just that one section of the page w

Re: [PHP-DB] Problem with creating parallel connections with mysql_connect

2006-01-18 Thread Bastien Koert
If no connection is made, there is no mysql error. You would need some custom error message output when the mysql_connect fails... Bastien From: Aarno Syvänen <[EMAIL PROTECTED]> To: David Robley <[EMAIL PROTECTED]> CC: php-db@lists.php.net Subject: Re: [PHP-DB] Problem with creating parallel

Re: [PHP-DB] Refreshing text question!

2006-01-18 Thread tg-php
Ooops... here's the real link: http://rajshekhar.net/blog/archives/85-Rasmus-30-second-AJAX-Tutorial.html = = = Original message = = = Two ways I can think of to update part of a page without doing a full refresh: 1. Use an IFRAME so you're technically updating a page, but it's the page with

Re: [PHP-DB] Refreshing text question!

2006-01-18 Thread Bastien Koert
js rotating banner system http://www.dyn-web.com/dhtml/banners/ bastien From: <[EMAIL PROTECTED]> To: CC: <[EMAIL PROTECTED]> Subject: Re: [PHP-DB] Refreshing text question! Date: Wed, 18 Jan 2006 11:26:15 -0500 Ooops... here's the real link: http://rajshekhar.net/blog/archives/85-Rasmus-3

[PHP-DB] How can I solve this?

2006-01-18 Thread Chris Payne
Hi everyone, I am using PHP_SELF in order to get the current path on a dynamically created webpage. This gives me the following: /my_website/index.php My problem is, ALL I NEED is the directory name - no / or no index.php, how can I strip these out to leave JUST the folder name the fil

Re: [PHP-DB] How can I solve this?

2006-01-18 Thread Cal Evans
try $x =pathinfo($_SERVER['PHP_SELF']); echo $x['dirname']; =C= | | Cal Evans | http://blog.calevans.com | | Chris Payne wrote: Hi everyone, I am using PHP_SELF in order to get the current path on a dynamically created webpage. This gives me the following: /my_website/index.php

RE: [PHP-DB] How can I solve this?

2006-01-18 Thread Chris Payne
Wonderful thank you, it displays a single / before the dir name but I can remove that without too much trouble :-) Thank you. Chris try $x =pathinfo($_SERVER['PHP_SELF']); echo $x['dirname']; =C= | | Cal Evans | http://blog.calevans.com | | Chris Payne wrote: > Hi everyone, > > > > I am u

Re: [PHP-DB] How can I solve this?

2006-01-18 Thread Julien Bonastre
Two alternatives.. dirname(); returns basically just the path, same string as using pathinfo["dirname"] but saves that array step.. or back to the love of my life [well, the non-human one]: preg_replace("/^\/?(.*)\/[\w]+\.php$/","$1",$PHP_SELF) that strips that leading forward slash too ;-)

[PHP-DB] Re: is this possible in one query?

2006-01-18 Thread Christoph Kunze
Sjef Janssen schrieb: Hi there, I have a table that keeps names for different language codes. In a short example: nameId name languageCode 31 House EN 31 Wohnung DE 32 Piece En 32 Stuck De 33 Car EN 33 PKW DE What I would like is to have a query that returns for example: nameId = 31 Names = Hous

[PHP-DB] FTPing within PHP

2006-01-18 Thread Ron Piggott (PHP)
I am wondering if I may delete a file by FTPing within PHP. I found the followed on the PHP web site: fopen("ftp://user:[EMAIL PROTECTED]/somefile.txt", "w"); Is there a way for me to delete somefile.txt ? The FTP program on my computer gives the command DELE /path/somefile.txt Is there a way

Re: [PHP-DB] FTPing within PHP

2006-01-18 Thread David Robley
On Thu, 19 Jan 2006 14:38, Ron Piggott (PHP) wrote: > I am wondering if I may delete a file by FTPing within PHP. > > I found the followed on the PHP web site: > > fopen("ftp://user:[EMAIL PROTECTED]/somefile.txt", "w"); > > Is there a way for me to delete somefile.txt ? > > The FTP program on my c

[PHP-DB] Re: Refreshing text question!

2006-01-18 Thread JeRRy
Hi, Thanks for people that have commented and responsed. One stated my question had nothing to do with PHP and MySQL. Hang on to your horses, 90% oif the people that responded responded in an incorrect method I needed. Hence the appologies soon blooded in but thanks for the meta refresh

[PHP-DB] Re: Refreshing text question!

2006-01-18 Thread David Robley
JeRRy wrote: > Hi, > > Thanks for people that have commented and responsed. One stated my > question had nothing to do with PHP and MySQL. Hang on to your horses, > 90% oif the people that responded responded in an incorrect method I > needed. Hence the appologies soon blooded in bu