03-16-2010, 10:53 PM
Hello there...
I had this php script built for me a while back, but I recently deleted a file that was needed so I had to work to rebuild it. I keep getting this annoying error when I try to insert data into the database so maybe someone here will know what the problem is.....
when I try to insert data into the database, I get the follow error:
Unknown column 'Data_Distance' in 'field list'
here's my insert.php file:
here's a link to form where the data is inserted:
http://www.andrewshemo.com/reloading/insert.php
I had this php script built for me a while back, but I recently deleted a file that was needed so I had to work to rebuild it. I keep getting this annoying error when I try to insert data into the database so maybe someone here will know what the problem is.....
when I try to insert data into the database, I get the follow error:
Unknown column 'Data_Distance' in 'field list'
here's my insert.php file:
Code:
<?PHP
foreach ($_POST as $key => $value){
$$key = $value;
}
if (!$submit) {
?>
<HTML>
<HEAD>
<TITLE>Insert stuff</TITLE>
<style type="text/css">
ul, li
{
list-style: none;
text-align: left;
}
</style>
</HEAD>
<BODY>
<H1>Insert stuff...</H1>
<FORM ACTION="insert.php" METHOD=POST>
<ul>
<li>Caliber: <INPUT TYPE=TEXT NAME=Caliber></li><BR>
<li>Bullet: <INPUT TYPE=TEXT NAME=Bullet></li><BR>
<li>Powder: <INPUT TYPE=TEXT NAME=Powder></li><BR>
<li>Primer: <INPUT TYPE=TEXT NAME=Primer></li><BR>
<li>OAL: <INPUT TYPE=TEXT NAME=OAL></li><BR>
<li>Distance: <INPUT TYPE=TEXT NAME=Data_Distance></li><BR>
<li>Grouping: <INPUT TYPE=TEXT NAME=Grouping></li><BR>
<li>Bench: <INPUT TYPE=TEXT NAME=Bench></li><BR>
<BR>
<li><INPUT TYPE=HIDDEN NAME=submit VALUE="yes">
<INPUT TYPE=SUBMIT VALUE="Submit your stuff..."></li>
</ul>
</FORM>
</BODY>
</HTML>
<?PHP
exit;
}
$username = removed
$password = removed
$database = removed
$hostname = removed
mysql_connect("$hostname", "$username", "$password") or die(mysql_error());
mysql_select_db("$database") or die(mysql_error());
# this stuff is just for reference (copied from your post) so you know what the database limits are when doing the insert...
# for example, varchar(10) tells us that Ammo_Caliber can be pretty much any character, but not more than 10 characters long...
# and NOT NULL means exactly that... the database won't let you leave it blank (null)
#`Ammo_Caliber` varchar(10) collate latin1_german2_ci NOT NULL,
#`Bullet` varchar(20) collate latin1_german2_ci NOT NULL,
#`Powder` varchar(20) collate latin1_german2_ci NOT NULL,
#`Primer` varchar(20) collate latin1_german2_ci NOT NULL,
#`OAL` varchar(20) collate latin1_german2_ci NOT NULL,
#`Data_Distance` varchar(20) collate latin1_german2_ci NOT NULL,
#`Grouping` varchar(20) collate latin1_german2_ci NOT NULL,
#`Bench` varchar(20) collate latin1_german2_ci NOT NULL,
// Get all the data from the "example" table
$result = mysql_query("INSERT into NewGuns (Caliber,Bullet,Powder,Primer,OAL,Data_Distance,Grouping,Bench) VALUES ('$Caliber','$Bullet','$Powder','$Primer','$OAL','$Data_Distance','$Grouping','$Bench')") or die(mysql_error());
print "Stuff was inserted. Click <A HREF=\"select.php\">here</A> to see if it worked...\n";
?>here's a link to form where the data is inserted:
http://www.andrewshemo.com/reloading/insert.php