Problem in search when value contents single quote (') in ..

Hello Everyone,

I m facing a issue, in search condition in where clause to be very
specific.

I have a table events which has title column with varchar(255) data
type.
When user enters single quote (') in it there is no issue with insert
or update but when i search for that specific record, i m getting no
resulted row.

version Details:
PHP 4.4.0
MySQL 4.3
Apache 1.3

I have tried mysql_escape_string also but no luck.

Sample Entry of the record is: babal's First event (same value i have
in the database).

thanks & Regards
Babal

On Aug 27, 7:58 am, babal wrote:
> Hello Everyone,
>
> I m facing a issue, in search condition in where clause to be very
> specific.
>
> I have a table events which has title column with varchar(255) data
> type.
> When user enters single quote (') in it there is no issue with insert
> or update but when i search for that specific record, i m getting no
> resulted row.
>
> version Details:
> PHP 4.4.0
> MySQL 4.3
> Apache 1.3
>
> I have tried mysql_escape_string also but no luck.
>
> Sample Entry of the record is: babal's First event (same value i have
> in the database).
>

Try:

babal''s First event

/Lennart