am having problem with my apostrophe sign (') in my form field. whenever an apostrophe is inserted in my form (eg can't, don't etc) it will be sent or echoed or store in my database as can/'t or don/'t. what can i do to make it appear the normal way? regards,
Always use addslashes function of php before putting data into mysql. That is the way to ensure that texts are entered correct and retrieved correct. Moreover it resolves a security issue as well.
You should not use the addslashes function if you are sending it to mysql; you should use mysql_real_escape_string; quotes are not the only thing that can break a query.