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
-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
-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
-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
] 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
. 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
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
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
8 matches
Mail list logo