php - Input data doesn't appear on the database -

i'm new forum, , i'm having trouble project. i've used same code other tables 1 won't work. help! d:

this doesn't work:

<?php $host="127.0.0.1";  $username="root";  $password="";  $db_name="nadel";  $tbl_name="soldprod";   mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select db");   $sprodname=$_post['sprodname']; $spquant=$_post['spquant']; $scli=$_post['scli']; $spds=$_post['spds'];  if(empty($sprodname) || empty($spquant) || empty($scli) || empty($spds)) { echo "<script> alert('you did not fill out required fields. ');  window.location.href='addsprod.php';</script> "; } else{  $sprodname = stripslashes($sprodname); $spquant = stripslashes($spquant); $scli = stripslashes($scli); $spds = stripslashes($spds);  $sprodname = mysql_real_escape_string($sprodname); $spquant = mysql_real_escape_string($spquant); $scli = mysql_real_escape_string($scli); $spds = mysql_real_escape_string($spds);   $sql="insert soldprod(sp_name, sp_quantity, sp_cli_name, date_sold)  values ('$sprodname','$spquant','$scli','$spds')"; $result=mysql_query($sql);  echo "<script> alert('successfully added sold product!');     window.location.href='sprod.php';</script> "; } ?> 

but works:

<?php $host="127.0.0.1";  $username="root";  $password="";  $db_name="nadel";  $tbl_name="products";    mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select db");  $prodname=$_post['prodname']; $pquant=$_post['pquant']; $pprice=$_post['pprice']; $pdman=$_post['pdman']; $pdex=$_post['pdex'];    if(empty($prodname) || empty($pquant) || empty($pprice) ||  empty($pdman)|| empty($pdex))     {         echo "<script> alert('you did not fill out required fields. ');       window.location.href='addprod.php';</script> ";     }     else{       $prodname = stripslashes($prodname);     $pquant = stripslashes($pquant);     $pprice = stripslashes($pprice);     $pdman = stripslashes($pdman);     $pdex = stripslashes($pdex);      $prodname = mysql_real_escape_string($prodname);     $pquant = mysql_real_escape_string($pquant);     $pprice = mysql_real_escape_string($pprice);     $pdman = mysql_real_escape_string($pdman);     $pdex = mysql_real_escape_string($pdex);      $sql="insert products(`product_name`, `prod_quantity`,     `prod_price`, `prod_mand`, `prod_expd`) values     ('$prodname','$pquant','$pprice','$pdman','$pdex')";     $result=mysql_query($sql);       echo "<script> alert('successfully added product! ');     window.location.href='prod.php';</script> ";     }     ?> 

i don't know went wrong d:

$sql="insert soldprod(sp_name, sp_quantity, prod_quant, sp_cli_name, date_sold) values      ('$sprodname','$spquant','$scli','$spds')"; 

you specify 5 columns enter 4 values.

you should checking results of database calls , checking mysql_error find out issue is.

please consider moving mysql_* mysqli or pdo. mysql_* functions deprecated , removed in future.