error:when special characters are inserted

[queenc]

hi
i have an error when i try tio insert special characters '

insert into lydia(id,resume)values('$ids','$i')
idis int,resume is a varchar

ERROR3:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Degree
please do tell me how to allow user to insert special characters.

[vasioky]

you must set mysql encoding. Check mysql references

[queenc]

i cant get you.can you explain.i'm new to this.

[mwasif]

Use mysql_real_escape_string().

$query = "insert into lydia(id,resume) values('$ids','".mysql_real_escape_string($i)."')";

[queenc]

thank you for your reply .it's working..