Code: Select all
$address="INSERT INTO address (add1, add2, town, county, postcode, homephone) VALUES (`{$clean['add1']}`,`{$clean['add2']}`,`{$clean['town']}`,`{$clean['county']}`,`{$clean['postcode']}`,`{$clean['phone']}`)";
echo $address.'<br>';
$result2=mysql_query($address) OR DIE("Couldn't store address".mysql_error());Code: Select all
INSERT INTO address (add1, add2, town, county, postcode, homephone) VALUES (`streetname`,`areaname`,`town`,`countyname`,`B21 5FE`,``)
Couldn't store addressUnknown column 'streetname' in 'field list'Code: Select all
CREATE TABLE `address` (
`address_id` int(11) NOT NULL auto_increment,
`add1` varchar(255) NOT NULL,
`add2` varchar(255) NOT NULL,
`town` varchar(255) NOT NULL,
`county` varchar(255) NOT NULL,
`postcode` varchar(8) NOT NULL,
`homephone` varchar(15) NOT NULL,
PRIMARY KEY (`address_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;