> -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
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
> -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 wr
> -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
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
thanks for this Ash...I didn't really understand but I do now!
unfortunately the fix didn't work, possibly bec the mysql data is in
binary format (default then becomes: case sensitive). I got a 'syntax
error' result
I'll find a mysql forum
Michael
This isn't a php question but a mysql one. Tak
This isn't 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 insens
7 matches
Mail list logo
