help with php

[andrewjs18]

Check your table. I'm guessing that the column 'Data_Distance' does not exist or the column it is referring to is having a different name.

I'm not sure.....but here's a screenshot for you to check out.



here's the mysql structure I suppose you'd call it:

Code:

CREATE TABLE IF NOT EXISTS `Guns` (
  `ID` int(5) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`ID`)