php mysql查询语法错误（未知字段）[重复]

Question

This question already has an answer here:

• When to use single quotes, double quotes, and backticks in MySQL 12 answers

include("db_connector.php");
    $soru = "asdasds";
    $tip = 1;
    $soruId = 0;

        $sql = "insert into sor (anketId,soruMetni,tip) values (".$_SESSION['anket'].",".$soru.",".$tip.")";
        $islem = mysql_query($sql)or die(mysql_error());;
        if(isset($islem))
        {
            $soruId = mysql_insert_id();
        }else
        {
            header("refresh:2;sorular.php");
        }

this code give an error like this : Unknown column 'asdasds' in 'field list'

</div>

Answer 1

I just add ' before and after every variable in query. You cannot pass string to query without adding single quote '.

Change From:

$sql = "insert into sor (anketId,soruMetni,tip) values (".$_SESSION['anket'].",".$soru.",".$tip.")";

to :

$sql = "INSERT INTO `sor` (anketId,soruMetni,tip) 
        VALUES ('".$_SESSION['anket']."', '".$soru."', '".$tip."')";