Data doesnt enter table MYSQL

[eciym]

Hi I have this very simple form, and want it to insert some data in to some field. Very simple you might think however after following the step by step functions a gazillion times it still doesn't work. I get no error message, it prints the variables before the insert query and prints the text "Records added to the database" after it is supposed to be inserted.

 

But the table remain empty... it's beaten me and now I implore the help of somebody who knows what they are doing.

 

<?php mysql_connect("localhost", "usr", "pwd") or die(mysql_error());

mysql_select_db("dbname") or die(mysql_error());

?>

 

...

<?php

print $erbjmarke;

print $erbjartikel ;

print $erbjxpris ;

print $erbjordpris ;

 

  $query = "INSERT INTO erbjudan (erbjmarke, erbjartikel, erbjxpris, erbjordpris) VALUES ('$erbjmarke','$erbjartikel','$erbjxpris','$erbjordpris')";

 

  print "Records added to the database";

?>

 

 

Thank you in anticipation

 

[paul2463]

missing execution line

 

try this

<?php mysql_connect("localhost", "usr", "pwd") or die(mysql_error());
mysql_select_db("dbname") or die(mysql_error());
?>

...
<?php
print $erbjmarke;
print $erbjartikel ;
print $erbjxpris ;
print $erbjordpris ;

  $query = "INSERT INTO erbjudan (erbjmarke, erbjartikel, erbjxpris, erbjordpris) VALUES ('$erbjmarke','$erbjartikel','$erbjxpris','$erbjordpris')";

//this line was missing
mysql_query($query) or die ('Error in query: $query. ' . mysql_error());
  
  print "Records added to the database";
?>

[eciym]

thank you. now i can stop aggravating my forming stomach ulcer. looks like i have a lot of learning to do.

[weknowtheworld]

Do visit php.net for more learning in php.  Happy learning....