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

2006-01-17 Thread Aarno Syvänen
Hi List, I do not claim that this is bug, but it is not a nice feature either. I do have following: $accid=mysql_pconnect($db_account_server,$db_account_user, $db_account_pass); //error_reporting ( $level); mysql_select_db($db_account_db, $accid); ?> Note that databases here are totally unre

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

2006-01-17 Thread Philip Hallstrom
Hi List, I do not claim that this is bug, but it is not a nice feature either. I do have following: Note that databases here are totally unrelated. They are on the same machine only because i am developing. I want later to move 'asterisk' to a separate machine, but when i do this, i want ju

[PHP-DB] MySQL date casting..

2006-01-17 Thread tg-php
Forgive me that this isn't really PHP related, but solely MySQL.. but the MySQL mailing lists drive me nuts and figured someone here would have a quick answer. I'm trying to sort by a date and time field(s) (two separate fields). It's a dumb system but until we do the next revision, it's going

Re: [PHP-DB] MySQL date casting..

2006-01-17 Thread Philip Hallstrom
Forgive me that this isn't really PHP related, but solely MySQL.. but the MySQL mailing lists drive me nuts and figured someone here would have a quick answer. I'm trying to sort by a date and time field(s) (two separate fields). It's a dumb system but until we do the next revision, it's going

RE: [PHP-DB] MySQL date casting..

2006-01-17 Thread tg-php
Unfortunately, no. The dates and times are stored as text. So here's what I get: 2006-01-10 07:00 PM 2006-01-10 08:00 PM 2006-01-10 09:00 AM 2006-01-10 09:00 PM (notice the "AM" out of order) For anyone interested, here's the big ugly version.. if anyone knows of a function that I can use i

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

2006-01-17 Thread Micah Stevens
On Tuesday 17 January 2006 7:57 am, Aarno Syvänen wrote: > Hi List, > > I do not claim that this is bug, but it is not a nice feature either. > > I do have following: > > /* db.php */ > $db_server="127.0.0.1"; > $db_user = ** > $db_pass = ** > $db_db = "bebbicell"; > > $db_account_server="

Re: [PHP-DB] MySQL date casting..

2006-01-17 Thread tg-php
Ahh! Thank you Philip! That's what I was looking for! I see what I did wrong now. I was using the date format strings wrong. I was using it like I'd use it for DATE_FORMAT() instead of as an input filter. This is what I was trying to do: select STR_TO_DATE('2003-11-05 06:00 PM', '%Y-%m-%d %H

Re: [PHP-DB] MySQL date casting..

2006-01-17 Thread Bastien Koert
Youcould also try CASTing (http://dev.mysql.com/doc/refman/5.0/en/cast-functions.html) the data Bastien From: <[EMAIL PROTECTED]> To: CC: <[EMAIL PROTECTED]> Subject: Re: [PHP-DB] MySQL date casting.. Date: Tue, 17 Jan 2006 12:51:44 -0500 Ahh! Thank you Philip! That's what I was looking f

[PHP-DB] Refreshing text question!

2006-01-17 Thread JeRRy
Hi, I did a little bit of script that refreshes a text slogan every 5 or so seconds with a new slogans and wraps to each slogan, I had about 5, and loops over and over again. This was done WITHOUT the need of refreshing the page. I think I used JavaScript but not 100% sure of this. Has

Re: [PHP-DB] Refreshing text question!

2006-01-17 Thread Julien Bonastre
Yes I can help you there.. There is a technique you can use which is actually more "browser" friendly then the Javascript alternative you mentioned.. You can use the META tags in your page as such: will refresh page in 10 seconds CONTENT="10;url=http://www.operation-scifi.com";> will r

Re: [PHP-DB] Refreshing text question!

2006-01-17 Thread Aaron Koning
I think that refreshing the web page with META Refresh every 5 or 10 seconds would surly P.O. anyone actually trying to read your web pages. Anyways: http://www.webreference.com/js/column3/ Or try googling the topic... Aaron On 1/17/06, Julien Bonastre <[EMAIL PROTECTED]> wrote: > > Yes I