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 )

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

2011-07-19 Thread Dr Michael Daly
{ //do_log("query.log","$PHP_SELF - CACHED $q"); $short_query_cache[str_replace(" ","",$q)] = $db_res ; // print ""; } return $db_res; } Michael On Jul 19, 2011, at 3:05 AM, Dr

[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 Th

[PHP] RE: search is not case insensitive

2010-11-01 Thread Dr Michael Daly
t; $end_time ORDER BY C.start_time"; (the only bit that changes is the text 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

Re: [PHP] search is not case insensitive

2010-10-31 Thread Dr Michael Daly
a php question but a mysql one. 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" Date: Sun, Oct 31, 2010 04:47 Subject: [PHP] search is not case insensitive T

[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 //va