php adding data mysql error ekak...

indi8305 · Mar 24, 2015

<html>
<head>
<title>Add New Record in MySQL Database</title>
</head>
<body>
<?php
if(isset($_POST['add']))
{
$dbhost = 'localhost';
$dbuser = 'wwshora_sudu';
$dbpass = 'jeewan83';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('Could not connect: ' . mysql_error());
}

if(! get_magic_quotes_gpc() )
{
$Name = addslashes ($_POST['Name']);
$Address = addslashes ($_POST['Address']);
$Contact = addslashes ($_POST['Contact']);
$Service = addslashes ($_POST['Service']);
$Services = addslashes ($_POST['Services']);

}
else
{
$Name = $_POST['Name'];
$Address = $_POST['Address'];
$Contact = $_POST['Contact'];
$Service = $_POST['Service'];
$Services = $_POST['Services'];
}

$More = $_POST['More'];

$sql = "INSERT INTO busines ".
"(Name,Address,Contact,Service,Services,More,join_date) ".
"VALUES('$Name','$Address','$Contact','$Service','$Services',$More, NOW())";
mysql_select_db('wwshora_dir');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not enter data: ' . mysql_error());
}
echo "Entered data successfully\n";
mysql_close($conn);
}
else
{
?>
<form method="post" action="<?php $_PHP_SELF ?>">
<table width="400" border="0" cellspacing="1" cellpadding="2">
<tr>
<td width="100">Name</td>
<td><input name="Name" type="text" id="Name"></td>
</tr>
<tr>
<td width="300">Address</td>
<td><input name="Address" type="text" id="Address"></td>
</tr>
<tr>
<td width="100">Contact</td>
<td><input name="Contact" type="text" id="Contact"></td>
</tr>
<tr>
<td width="300">Service</td>
<td><input name="Service" type="text" id="Service"></td></td></td>
</tr>
<tr>
<td width="300">Services</td>
<td><input name="Services" type="text" id="Services"></td></td></td>
</tr>
<tr>
<td width="300">More</td>
<td><input name="More" type="text" id="More"></td></td></td>
</tr>
<tr>
<td width="100"> </td>
<td> </td>
</tr>
<tr>
<td width="100"> </td>
<td>
<input name="add" type="submit" id="add" value="Add">
</td>
</tr>
</table>
</form>
<?php
}
?>
</body>
</html>

meke menna me error eka enawa..katada meke waradda kiyanna puluwan machanla...
"Could not enter data: Unknown column 'Advertising' in 'field list'" :no: