Special characters in Query

[mirfan]

In simple method of data insertion and updation, i'm getting errors when i try to enter some special character in db..

like ;,'," etc etc....

please guide my.. how can i insert these characters in db.

Thanks

 

[sleipnir214]

What database system?

The mysql_* family of functions includes the handy function mysql_escape_string() which does that nicely for MySQL.

Other database systems are not as easy.


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[DRJ478]

Not enough information for a meaningful answer.
What database technology are you using?

 

[mirfan]

Thanks for the co-operation but the problem is still there.. i want to insert those special characters in db..

the function u tell me.. is removing those characters from string.. but i want to insert them in the db.

please guide me again

Thanks

 

[mirfan]

sorry the DB is MYSQL

 

[sleipnir214]

Once you have removed or escaped the offending characters, you must use the string in an INSERT or UPDATE query and the appropriate query function




Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[mirfan]

thanks again for the help.. please guide me with an example

 

[sleipnir214]

The PHP online manual has lots of code examples.


Want the best answers? Ask the best questions!

TANSTAAFL!!