insert program won't work

ckdoublenecks · #1 (**permalink**) 09-11-10, 12:36 PM

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

PHP Code:


			
<?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();

?>

blackhawkso · #2 (**permalink**) 09-13-10, 09:27 AM

What is happening when you atempt the insert?

blackhawkso · #3 (**permalink**) 09-13-10, 09:32 AM

Just try this to see what error you will get

PHP Code:


			
$query = "INSERT INTO miscdata VALUES ('','$dep','$name','$apt','$amtpaid','$damage','$month','$courtcost','$nsf','$latechg','$comments')";

if (mysql_query($query))

{

echo 'Worked';

} else {

die('Didnt Work<br />: ' . mysql_error());

};