[PHP] ? simple solution for error resulting from upgrade to php5

2011-07-19 Thread Dr Michael Daly
Hi is there a simple solution here, other than reverting to php4? An upgrade from php5 to php5 has resulted in an error msg in this line: if( strlen($db_res ) 0 ) { I understand this is bec. php5 is object orientated. It says an Object of class DB_result could not be converted to a string

Re: [PHP] ? simple solution for error resulting from upgrade to php5

2011-07-19 Thread Dr Michael Daly
Thanks Geert That has fixed it, with flying colours! Michael On 19.07.2011, at 10:05, Dr Michael Daly wrote: Hi is there a simple solution here, other than reverting to php4? An upgrade from php5 to php5 has resulted in an error msg in this line: if( strlen($db_res ) 0 ) { isn't

[PHP] RE: search is not case insensitive

2010-11-02 Thread Dr Michael Daly
betw the first two 'ANDS') It comes from PBCS online appointment software. Thanks Michael -Original Message- From: Dr Michael Daly [mailto:g...@holisticgp.com.au] Sent: Sunday, 31 October 2010 3:47 PM To: php-general@lists.php.net Subject: search is not case insensitive Hi Using

Re: [PHP] search is not case insensitive

2010-10-31 Thread Dr Michael Daly
. Take out the lower() part of the sql statement, as like is case insensitive by default. Thanks, Ash http://www.ashleysheridan.co.uk - Reply message - From: Dr Michael Daly g...@holisticgp.com.au Date: Sun, Oct 31, 2010 04:47 Subject: [PHP] search is not case insensitive To: php-general

[PHP] search is not case insensitive

2010-10-30 Thread Dr Michael Daly
Hi Using a php search form produces a nil return on any information that is capitalised within a mysql database; retrieval is fine for non-capitalised data. Could someone tweak this please? The relevant code I think is as follows: // Description is a BLOB in MySQL... we need to UPPER the blob