Проблем със upload_file

[ludasam]

кат искам да кача плугин ми изписва тази грешка

Warning: Wrong parameter count for mysql_query() in /home/cshaskov/public_html/upload_file.php on line 33

upload_file

<?php
include "configoration.php";
if(isset($_POST['submit']))
{
$name = htmlspecialchars($_POST['name']);
$author = htmlspecialchars($_POST['author']);
$uploader = htmlspecialchars($_POST['uploader']);
$description = htmlspecialchars($_POST['description']);
$kategoria = htmlspecialchars($_POST['kategoria']);
if($name == NULL || $author == NULL || $description == NULL)
{
echo "Не сте попълнили всички полета!";
}
else{
     if ($_FILES["file"]["error"] > 0)
      {
      echo "Код на грешката: " . $_FILES["file"]["error"] . "<br />";
      }
     else
      {
      if (file_exists("upload/" . $_FILES["file"]["name"]))
        {
        echo $_FILES["file"]["name"] . " already exists. ";
        }
      else
        {
        move_uploaded_file($_FILES["file"]["tmp_name"],
        "upload/" . $_FILES["file"]["name"]);
        }
      }
      $link = $_FILES["file"]["name"];
      mysql_query("INSERT INTO files (kategoria,name,author,uploader,link,description) VALUES ('$kategoria','$name','$uploader','$author','$link','$description')") or die (mysql_query());
      echo "Файла е качен успешно!";
   }
}
?>

 

[Angry]

<?php
include "configoration.php";
if(isset($_POST['submit']))
{
$name = htmlspecialchars($_POST['name']);
$author = htmlspecialchars($_POST['author']);
$uploader = htmlspecialchars($_POST['uploader']);
$description = htmlspecialchars($_POST['description']);
$kategoria = htmlspecialchars($_POST['kategoria']);
if($name == NULL || $author == NULL || $description == NULL)
{
echo "Не сте попълнили всички полета!";
}
else{
     if ($_FILES["file"]["error"] > 0)
      {
      echo "Код на грешката: " . $_FILES["file"]["error"] . "<br />";
      }
     else
      {
      if (file_exists("upload/" . $_FILES["file"]["name"]))
        {
        echo $_FILES["file"]["name"] . " already exists. ";
        }
      else
        {
        move_uploaded_file($_FILES["file"]["tmp_name"],
        "upload/" . $_FILES["file"]["name"]);
        }
      }
      $link = $_FILES["file"]["name"];
      mysql_query("INSERT INTO `files` (`kategoria`,`name`,`author`,`uploader`,`link`,`description`) VALUES ('$kategoria','$name','$uploader','$author','$link','$description')") or die (mysql_error());
      echo "Файла е качен успешно!";
   }
}
?>

 

[ludasam]

Изписва ми това ..
Unknown column 'kategoria' in 'field list'

 

[Angry]

Нямаш таблица kategoria в dbto.

Сложи тази

CREATE TABLE IF NOT EXISTS `files` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `author` varchar(255) NOT NULL,
  `uploader` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `kategoria` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=31 ;