I have got a problem in using Insert Query.
Here is Insert SQL query
<?php
$st="GOPINATH'S';
$sql="Insert into emp_tab values(12,$st)";
..
..
..
?>
In the above program, String itself contains Single quote ('). If i try to execute
the above query, I got the error message stating that 'String not properly terminated'
How to use single quote in SQL Query?
I got the same proble in Select query as well.
Give the solution to the above mentioned problems.
Thanks in advance.
Gopi