Apostrophe problem

[SSG001]

Error: missing ; before statement
Source File: http://localhost/test.php?Line: 948, Column: 49
Source Code: select_opt[1] = 'abcd-50's{a101}';


i have created rows dynamically and trying to fill one of the select box with this value and i get this error



Thanks in advance

[acoder]

You either need to escape the single apostrophe or you need to use double quotes instead of single ones.

[SSG001]

You either need to escape the single apostrophe or you need to use double quotes instead of single ones.

but how do i do that?


Thanks in advance

[acoder]

//Either use double quotes:
select_opt[1] = "abcd-50's{a101}";
// or escape single quotes:
select_opt[1] = 'abcd-50\'s{a101}';

[SSG001]

//Either use double quotes:
select_opt[1] = "abcd-50's{a101}";
// or escape single quotes:
select_opt[1] = 'abcd-50\'s{a101}';

but i'm fetching data from table so at the time of fetching i want know if any of the value has single quotes or not

[acoder]

Show the code that causes the error.

[SSG001]

can i remove the symbols like \ ,* $ % ' " after posting the data
and before inserting it in the query so such problem would not arise

[acoder]

Yes, you can, but there's no need to. If you escape it when displaying, then there won't be a problem.