RE: [PHP] search is not case insensitive

2010-11-02 Thread tedd
At 10:23 PM -0700 11/1/10, Tommy Pham wrote: -Original Message- From: tedd [mailto:tedd.sperl...@gmail.com] Sent: Sunday, October 31, 2010 9:00 AM To: g...@holisticgp.com.au; php-general@lists.php.net Subject: Re: [PHP] search is not case insensitive At 3:47 PM +1100 10/31/10

RE: [PHP] search is not case insensitive

2010-11-02 Thread Tommy Pham
-Original Message- From: tedd [mailto:tedd.sperl...@gmail.com] Sent: Tuesday, November 02, 2010 8:09 AM To: Tommy Pham; g...@holisticgp.com.au; php-general@lists.php.net Subject: RE: [PHP] search is not case insensitive At 10:23 PM -0700 11/1/10, Tommy Pham wrote: -Original

RE: [PHP] search is not case insensitive

2010-11-01 Thread Tommy Pham
-Original Message- From: a...@ashleysheridan.co.uk [mailto:a...@ashleysheridan.co.uk] Sent: Sunday, October 31, 2010 2:10 AM To: Dr Michael Daly; php-general@lists.php.net Subject: Re: [PHP] search is not case insensitive This isn't a php question but a mysql one. Take out

RE: [PHP] search is not case insensitive

2010-11-01 Thread Tommy Pham
-Original Message- From: tedd [mailto:tedd.sperl...@gmail.com] Sent: Sunday, October 31, 2010 9:00 AM To: g...@holisticgp.com.au; php-general@lists.php.net Subject: Re: [PHP] search is not case insensitive At 3:47 PM +1100 10/31/10, Dr Michael Daly wrote: Hi Using a php search

Re: [PHP] search is not case insensitive

2010-10-31 Thread a...@ashleysheridan.co.uk
] search is not case insensitive To: php-general@lists.php.net 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

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

Re: [PHP] search is not case insensitive

2010-10-31 Thread tedd
At 3:47 PM +1100 10/31/10, Dr Michael Daly wrote: 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

[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