[PHP-DB] rtrim a string with MySQL's function

2007-12-04 Thread Shelley Shyan
Hi all, It's really frustrating, I got a problem to trim a string using MySQL's function. The fact is that I want to rtrim a number from a string, that is: if the string is abc2321413412, I want the function to return 2321413412; c123,

Re: [PHP-DB] I am a bloody idiot

2007-12-04 Thread Chris
julian wrote: Dee Ayy wrote: no worries I give up. It is really weird I know Hope some day I will get enlighted. In one file, any method within a class is happy with the global $db...on a different (same file !!!) class no method is happy with accessing $db via global... So you conf

[PHP-DB] Re: Subject: Ordering a varchar field in mysql

2007-12-04 Thread Neil Smith [MVP, Digital media]
At 09:44 04/12/2007, you wrote: Message-ID: <[EMAIL PROTECTED]> Date: Tue, 4 Dec 2007 11:12:40 +0530 From: "Vaibhav Informatics" <[EMAIL PROTECTED]> *Questions on PHP* On PHP, OK sure In one of our tables, one of the field is acc_no, we had given the data type as varchar, since it could

[PHP-DB] I am a bloody idiot

2007-12-04 Thread julian
Dee Ayy wrote: no worries I give up. It is really weird I know Hope some day I will get enlighted. In one file, any method within a class is happy with the global $db...on a different (same file !!!) class no method is happy with accessing $db via global... So you confirmed that you

Re: [PHP-DB] passing a mysqli object via globals

2007-12-04 Thread julian
Chris wrote: julian wrote: warn: already posted in general with no response... maybe is too basic.. but I RTFM and still is not clear to me what I am doing wrong I want to open a database connection at program initialization and use that very same connection via globals initilizati

Re: [PHP-DB] Re: passing a mysqli object via globals

2007-12-04 Thread julian
Dee Ayy wrote: no worries I give up. It is really weird I know Hope some day I will get enlighted. In one file, any method within a class is happy with the global $db...on a different (same file !!!) class no method is happy with accessing $db via global... So you confirmed that you