i have store database table name in $rt which is get from user,,,,,, but when i am using this variable in my query it shows a sql error that is ( 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 '' )
Code: Select all
$un=$_POST['uname'];
$e=$_POST['eid'];
if(isset($_POST[but]))
{
$sql="insert into ' ".$rt." ' values (' ".$un." ',' ".$e." ')";
if(mysql_query($sql,$con) or die("error in insertion".mysql_error()))
echo "Successfully Added";
}