I have this little insert program, almost identical to other working programs, which doesn’t work and I don’t know why. Below is the code ?
[CODE]<html><BODY>
<b>Misc. Charges insert form<p>
<form action=”mschginsert.php” method=”post”>
<INPUT TYPE=”text” name=dep>Dep#<BR>
<INPUT TYPE=”text” name=name>Name<BR>
<INPUT TYPE=”text” name=apt>Apt#<BR>
<INPUT TYPE=”text” name=amtpaid>Amount Paid<BR>
<INPUT TYPE=”text” name=damage>Damage Chg<BR>
<INPUT TYPE=”text” name=month>Month Incurred<BR>
<INPUT TYPE=”text” name=courtcost>Court Costs<BR>
<INPUT TYPE=”text” name=nsf>NSF<BR>
<INPUT TYPE=”text” name=latechg>Late Charges<BR>
<INPUT TYPE=”text” name=comments>Comments<BR>
<p>
<INPUT type=submit value=”submit data”><BR>
</form></body></html>
the below PHP file is mschginsert.php
[code=php]<?php
$dep=$_POST[‘dep’];
$name=$_POST[‘name’];
$apt=$_POST[‘apt’];
$amtpaid=$_POST[‘amtpaid’];
$damage=$_POST[‘damage’];
$month=$_POST[‘month’];
$courtcost=$_POST[‘courtcost’];
$nsf=$_POST[‘nsf’];
$latechg=$_POST[‘latechg’];
$comments=$_POST[‘comments’];
mysql_connect(localhost,root,””);
mysql_select_db(mschgdb) or die (“Unable to select database”);
$query = “INSERT INTO miscdata VALUES (”,’$dep’,’$name’,’$apt’,’$amtpaid’,’$damage’,’$month’,’$courtcost’,’$nsf’,’$latechg’,’$comments’)”;
mysql_query($query);
mysql_close();
?>