y doesnt this work

[olm475]

trying to send to mysql database ......

<?php
$venuename = $POST['venue name'];
$email = $POST['email'];
$website = $POST['website'];
$phonenumber = $POST['phone number'];
$areacode = $POST['area code'];
$address = $POST['address'];
$city = $POST['city'];
$state = $POST['state'];
$zipCode = $POST['zipcode'];
$contact = $POST['contact'];
$inputclubtype = $POST['club type'];
$inputmusictype = $POST['music type'];
$inputcrowd = $POST['crowd'];
$inputdresscode = $POST['dress code'];
$comment = $_POST['comment'];

$conn = mysql_connect("localhost", "nigolmvc_nigolmv", "babystuff");
mysql_select_db ("nigolmvc_nightspotz", $conn);
$result = mysql_query("INSERT INTO venues (
venue name,
email,
website,

phone number,
area code,
address,
city,
state,
zipcode,
contact,
club type,
music type,
crowd,
dress code,
comment)

VALUES(
'$venuename',
'$email',
'$website',

'$phonenumber',
'$areacode',
'$address',
'$city',
'$state',
'$zipCode',
'$contact',
'$inputclubtype',
'$inputmusictype',
'$inputcrowd',
'$inputdresscode',
'$comment')");

?>

[chyan]

...
$conn = mysql_connect("localhost", "nigolmvc_nigolmv", "babystuff");
mysql_select_db ("nigolmvc_nightspotz", $conn);
$query = "INSERT INTO venues (
venue name,
email,
website,
phone number,
area code,
address,
city,
state,
zipcode,
contact,
club type,
music type,
crowd,
dress code,
comment)

VALUES(
'$venuename',
'$email',
'$website',
'$phonenumber',
'$areacode',
'$address',
'$city',
'$state',
'$zipCode',
'$contact',
'$inputclubtype',
'$inputmusictype',
'$inputcrowd',
'$inputdresscode',
'$comment')";

if(!mysql_query($query,$conn))
{
echo mysql_error();
exit;
}