hi i am lost!!! really lost, i have some php script that i am trying to slightly change by adding a new text entry field.
I have made the change and get the following error when i click my submit button.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '&bname='450', price=NULL, special_price='Simply immaculate detac
my table structure is as follows:
`b&bname` varchar(50) default NULL,
`id` int(11) NOT NULL auto_increment,
`cid` int(11) default NULL,
`scid` int(11) default NULL,
`mid` int(11) default NULL,
`title` varchar(50) default NULL,
`price` double default NULL,
`special_price` double default NULL,
`pdate` datetime default NULL,
`sold` varchar(4) default NULL,
`description` text,
`address` varchar(50) default NULL,
`city` varchar(45) default NULL,
`state` varchar(45) default NULL,
`zip` varchar(50) default NULL,
`exp` int(11) default NULL,
`featured` varchar(4) default NULL,
`active` varchar(5) default NULL,
`hits` int(11) default NULL,
`bed` varchar(10) default NULL,
`bath` varchar(10) default NULL,
`subdiv` varchar(60) default NULL,
`schoold` varchar(60) default NULL,
`year` int(11) default NULL,
`lot_size` double default NULL,
`sqft` double default NULL,
`lat` varchar(40) default NULL,
`long` varchar(40) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
It is an edit.php file(renamed for uploading purposes), so i am trying to edit a current record in my mysql table.
the new field i have added is called "b&bname"
I have added a new field in mymsql table called "b&bname"
i really don't get why i am getting this error.
please help...
my full code is attached:
