[SOLVED] What am I doing wrong?????

[JayCee]

I'm running XAMPP and I have created a form using HTML, I have written the following code in PHP in order to store the data into my DB:

 

<?php

$Name = $_Post['Name'];

$Surname = $_Post['Surname'];

$Comment = $_Post['Comment'];

 

mysql_connect ("localhost","root","test") or die ('Error: ' . mysql_error());

mysql_select_db ("results");

 

$query="INSERT INTO entries (Name, Surname, Comments)VALUES ('".$Name."','".$Surname."','".$Comment."')";

 

mysql_query($query) or die ('Error updating database');

 

ECHO "UPDATED";

 

?>

 

I keep getting the message Error updating database and obviously no data in my DB, anyone help me with what I'm doing wrong?

 

Thanks in advance!!!!!

 

JC

[trq]

Its $_POST not $_Post.

[JayCee]

Thanks for swift response Thorpe, I've changed it to $_POST but I'm still getting the same error??

[Mark Baker]

$query="INSERT INTO entries (Name, Surname, Comments)VALUES ('".$Name."','".$Surname."','".$Comment."')";

echo $query.'<br />';

mysql_query($query) or die ('Error updating database: '.mysql_error());

 

[trq]

Generally its best to avoid die(), but if you going to use it, at least make it throw you a decent error message.

 

mysql_query($query) or die (mysql_error());

[JayCee]

Thorpe!!!! Thanks! I changed die to show me an error and it highlighted my ridiculous poor spelling, the field is comment not comments!!! D'OH!!! Thanks Again!!