MySql没有插入

Question

Is not giving me any error, I am already linked with server but I am still unable to get it work.

It's still unable to add message, do you see any errors?

function pridaj_tovar() {

    if ($link = spoj_s_db()) {    
    $sql = "INSERT INTO `Auto-Moto`".
            "(`Tovar`, `Kategoria`,`Mesto`, `Cena`, `ID`, `Popis`)".
            "VALUES".
            "('$_POST['nazov']', '$_POST['kategorie']', '$_POST['mesta']',' $_POST['cena']', NULL,'$_POST['popis']')";
        $result = mysql_query($sql, $link); 
        if ($result) {
            // unable to add
        echo '<p>inserting was successful.</p>'. "
"; 
    } else {
            // unable to add!
        echo '<p class="chyba">Nastala chyba pri pridávaní tovaru.</p>' . "
";  
    }
        mysql_close($link);
    } else {
        // NEpodarilo sa spojiť s databázovým serverom!
        echo '<p class="chyba">NEpodarilo sa spojiť s databázovým serverom!</p>';
    }
  }

Answer 1

This is how you should handle field and table names with spaces,dashes (etc) :

  $sql = "INSERT INTO `Auto-Moto`".
   "(`Tovar`, `Kategoria`,`Mesto`, `Cena`, `ID`, `Popis`)".
   "VALUES".
   "('Something', 'Something1', 'word', '50', NULL, 'anotherword')";

  $sql = "INSERT INTO `Auto-Moto`". 
         "(`Tovar`, `Kategoria`,`Mesto`, `Cena`, `ID`, `Popis`)". 
         "VALUES". " 
         ('{$_POST['nazov']}', '{$_POST['kategorie']}', '{$_POST['mesta']}','{$_POST['cena']}',  
  NULL,'{$_POST['popis']}')";