Posted by Kim Andrι Akerψ on 03/13/06 15:03
Stefan Mueller wrote:
> I've a web page with several input boxes. After the user clicks
> 'submit' I insert these data into my MySQL database. This worked for
> several months perfect. But today a user entered the street name
> Route d'Yverdon 59
>
> unfortunately the data has not been inserted into my MySQL database
> because of the apostroph (') in the name of the street.
>
> I've no idea how to deal with this problem.
> Is there any possibility to avoid that my PHP & Java scripts don't
> interpret apostrophs (') and semicolons (")?
In addition to what Erlend wrote:
apostrophe (or "single quote") = '
semicolon = ;
(double) quote = "
--
Kim AndrΓ© AkerΓΈ
- kimandre@NOSPAMbetadome.com
(remove NOSPAM to contact me directly)
Navigation:
[Reply to this message]
|