Unknown Column in Field List. PHP + Mysql

Question

I'm trying to add values to a table in phpmyadmin and I get the error: Unknown column '...' in 'field list'.

Here's my code:

    <?php   

    //preparing the patch to copy the uploaded file
    $target_path = "images/";

    //adding the name of the file, finishing the path
    $target_path = $target_path . basename( $_FILES['image']['name']); 

   //moving the file to the folder
   if(move_uploaded_file($_FILES['image']['tmp_name'], $target_path)) {
       echo "The file ".  basename( $_FILES['image']['name']). 
       " has been uploaded";
   } else{
      echo "There was an error uploading the file, please try again!";
   }

   //getting input from the form
   $name = $_POST['game'];
   $description = $_POST['beschrijving'];

   //preparing the query to insert the values
   $query = "INSERT INTO tblGames (name, description, image) VALUES ($name,       $description,". $target_path .")";

   //opening connection to db
   $link = mysql_connect('localhost', 'root', '');
if (!$link) {
       die('Could not connect: ' . mysql_error());
}

     //selecting a db
mysql_select_db("BouncingGiani", $link) or die(mysql_error());

//running the query
$result = mysql_query($query) or die (mysql_error());

//closing the connection
mysql_close($link);

?>

so when I enter fds as name in the form on the previous page I get : Unknown column 'fds' in 'field list'. This never happened to me before and I have no idea on what is going on.

Can you show an actual example query that you try to execute? I don;t seen anything that would cause an unknown column issue unless you don't have name, description, and image fields on your table. However you do not seem to be using single quotes around the values you are inserting, which is problematic as well. — Mike Brant
– Mike Brant, Commented Aug 21, 2013 at 21:37
Does this answer your question? How to include a PHP variable inside a MySQL statement — Dharman
– Dharman ♦, Commented Jun 28, 2020 at 21:50

Class · Accepted Answer · 2013-08-21 21:38:09Z

27

I think this

$query = "INSERT INTO tblGames (name, description, image) VALUES ($name, $description,". $target_path .")";

should be

$query = "INSERT INTO tblGames (name, description, image) VALUES ('$name', '$description', '". $target_path ."')";

answered Aug 21, 2013 at 21:38

Class

3,1503 gold badges25 silver badges31 bronze badges

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

2 Comments

Giani Noyez Over a year ago

Yes indeed, that solved the issue. Thanks for answering my question. :)

Ahadu Melesse Over a year ago

Hello, how could this work for you while the variable names are not named properly, like name instead of $name ??

dazed-and-confused · Accepted Answer · 2024-01-18 19:39:02Z

6

It looks like the values should be quoted in your $query statement, i.e. $name, $description, and $target_path.

$query = "INSERT INTO tblGames (name, description, image) 
          VALUES ('$name', '$description', '$target_path')";

edited Jan 18, 2024 at 19:39

answered Aug 21, 2013 at 21:33

dazed-and-confused

1,3332 gold badges12 silver badges21 bronze badges

2 Comments

Giani Noyez Over a year ago

Thank you, you solved the issue.. Silly me forgetting about quotations.

dazed-and-confused Over a year ago

It's always the little things...Good luck.

Collectives™ on Stack Overflow

Unknown Column in Field List. PHP + Mysql

2 Answers 2

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related