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

#1

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

#2

On Aug 27, 7:58*am, babal <lokeshjadw... (AT) gmail (DOT) com> wrote:

Quote:

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

#3

On Aug 27, 7:58*am, babal <lokeshjadw... (AT) gmail (DOT) com> wrote:

Quote:

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

#4

On Aug 27, 7:58*am, babal <lokeshjadw... (AT) gmail (DOT) com> wrote:

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

comp.databases comp.databases

Problem in search when value contents single quote (') in whereclause - 08-27-2008 , 12:58 AM

Re: Problem in search when value contents single quote (') in whereclause - 08-27-2008 , 10:55 AM

Re: Problem in search when value contents single quote (') in whereclause - 08-27-2008 , 10:55 AM

Re: Problem in search when value contents single quote (') in whereclause - 08-27-2008 , 10:55 AM