Php mysql query syntax error (Unknown field)

Question

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'

score 3 · Answer 1 · edited Jul 27 '15 at 11:31

3

You need to change the SQL statement in this:

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

Strings needs to be encapsulated with a single quote. :)

edited Jul 27 '15 at 11:31

Muhammad Hassaan

7,296
6
30
50

answered Jul 27 '15 at 11:26

Stefan Herijgens

386
1
8

Muhammad Hassaan · Accepted Answer · 2015-07-27T11:34:51.457

0

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."')";

edited Jul 27 '15 at 11:34

answered Jul 27 '15 at 11:26

Muhammad Hassaan

7,296
6
30
50

thank you man problem solved :) – Batuhan GÜNGÖR Jul 27 '15 at 11:28
@BatuhanGÜNGÖR please accept my answer if you found it useful. – Muhammad Hassaan Jul 27 '15 at 11:29
I will... 8 min later :) this is a proc – Batuhan GÜNGÖR Jul 27 '15 at 11:31
@BatuhanGÜNGÖR sure :) – Muhammad Hassaan Jul 27 '15 at 11:38

Php mysql query syntax error (Unknown field)

2 Answers2