PHP Script (add.php)
<?php
$DBhost = "localhost";
$DBuser = "me";
$DBpass = "mypass";
$DBName = "mydatabase";
$table = "table";
mysql_connect($DBhost, $DBuser, $DBpass) or die("News=Uh Oh, Could not connect");
mysql_select_db($DBName, $Connect);
$result = mysql_query("INSERT INTO $table (CC, Contact, Phone, Email) VALUES ('$CC', '$Contact', '$Phone', '$Email')", $Connect);
Print "Status=Record has been added";
?>
Form information
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<h1 align="center">Install / Upgrade Client Information - Input Form </h1>
<form name="Clients" method="post" action="add.php">
<table width="75%" border="1" align="center">
<tr>
<td height="33">Company Code: </td>
<td height="33">
<input type="text" name="CC" maxlength="3">
</td>
<td height="33">Contact: </td>
<td height="33">
<input type="text" name="Contact">
</td>
</tr>
<tr>
<td>Phone Number:</td>
<td>
<input type="text" name="Phone">
<td>E-Mail</td>
<td>
<input type="text" name="Email">
</td>
</tr>
</table>
<p align="center">
<input type="submit" name="Submit" value="Submit">
</p>
<p> </p>
<p> </p>
</form>
<h1 align="center"> </h1>
</body>
</html>
Am I missing something ??