[SOLVED] apostrophe

[DarkPrince2005]

I have a web form that needs to save to a database but when there is any apostrophe in the field that needs to be saved it doesn't save at all.

 

is it maybe because the insert statement looks like:

 

                  insert into dis values('$_POST[comment]');

 

that the single quotations for $_POST is clashing with the apostrophe?

[rajivgonsalves]

you can look at the php command addslashes()

 

http://php.net/addslashes

[DarkPrince2005]

ok it seems that it'll work, but how would that look in a mysql statement

[rajivgonsalves]

it will be something like the following

 

fieldname = 'value\''

 

something like the above