Codezwiz >> Forums >> Codezwiz PHP Nuke Help >> y doesnt this work

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", "xxxxxxxxx", "xxxxxxxx");
mysql_select_db ("xxxxxxxx", $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')");

?>

You need to be very careful about what you post in forums. Your post above includes your database username and password. I edited it out, but you might want to change your username and password for your database now that you have compromised the security of your database.