unknown column error in insert mysql query in php?

Question

Despite reading quite many posts i cannot solve this error- Unknown column 'alt.atheism1111' in 'field list' the fields filename,category may have . in the middle of numbers or words, im using phpmyadmin for database

function insert_rec($cat,$file,$wordid,$synsetid,$seqno)
{
    $cat=mysql_real_escape_string($cat);
    $file=mysql_real_escape_string($file);
    $wordid=mysql_real_escape_string($wordid);
    $synsetid=mysql_real_escape_string($synsetid);
    $seqno=mysql_real_escape_string($seqno);
    echo $cat."  ". $file ."  ". $wordid."  " . $synsetid."  " . $seqno;
     $sql="INSERT  INTO `wordnet50`.`table`  (`category`,`filename`,`wordid`,`synsetid`,`seqno`) VALUES (`" . $cat . "`,`" . $file. "`,`" . $wordid. " `,`" . $synsetid . "`,`" .$seqno . "`)";
     $result=mysql_query($sql);

    if(!$result)
    {
    die(mysql_error()); 
    }
}

Please stop writing new code with the ancient mysql_* functions. They are no longer maintained and community has begun the deprecation process . Instead you should learn about prepared statements and use either PDO or MySQLi. — Bono
– Bono, Commented May 30, 2012 at 12:01

O. Jones · Accepted Answer · 2012-05-30 12:14:20Z

2

$sql="INSERT  INTO `wordnet50`.`table`  (`category`,`filename`,`wordid`,`synsetid`,`seqno`) VALUES (`" . $cat . "`,`" . $file. "`,`" . $wordid. " `,`" . $synsetid . "`,`" .$seqno . "`)";

You need to remove "`" from the above query in the values only and replace it with " ' " (single quote)

edited May 30, 2012 at 12:14

O. Jones

109k17 gold badges134 silver badges187 bronze badges

answered May 30, 2012 at 11:54

Arfeen

2,6235 gold badges30 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

flowfree · Accepted Answer · 2012-05-30 11:55:37Z

1

Use backticks for field names and single quotes for the values.

$sql = "INSERT INTO `wordnet50`.`table` (`category`,`filename`,`wordid`,`synsetid`,`seqno`)
        VALUES ('$cat', '$file', '$wordid', '$synsetid', '$seqno')";

answered May 30, 2012 at 11:55

flowfree

16.5k12 gold badges55 silver badges79 bronze badges

Comments

John Woo · Accepted Answer · 2012-05-30 11:57:01Z

0

It should be wrapped with single quotes not with back tick.

$sql = "INSERT  INTO `wordnet50`.`table`  (`category`,`filename`,`wordid`,`synsetid`,`seqno`) VALUES ('" . $cat . "','" . $file. "','" . $wordid. "','" . $synsetid . "','" .$seqno . "')";

BackTick escapes MYSQL Reserved WORDS.

answered May 30, 2012 at 11:57

John Woo

265k70 gold badges509 silver badges500 bronze badges

Comments

Aditya Kumar · Accepted Answer · 2012-05-30 12:01:26Z

-2

if u can post ur db schema than it will be easy to check, as of now it look like u have a field as alt.atheism1111 which can be the show stopper

or use this:

 $sql = "INSERT INTO `wordnet50`.`table` (`category`,`filename`,`wordid`,`synsetid`,`seqno`)
    VALUES ('$cat', '$file', '$wordid', '$synsetid', '$seqno')";

answered May 30, 2012 at 12:01

Aditya Kumar

7931 gold badge8 silver badges14 bronze badges

1 Comment

stack Over a year ago

yes ur right,i too figured this out,though its strange because i did try single quotes but it didnt work.the combination of putting the column names within ` and values within single quotes made it work! hope this helps other people with similar problems

Collectives™ on Stack Overflow

unknown column error in insert mysql query in php?

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related