Hello Jason,
Latest Version of Security Assist
Testing to live server
Table structure as follows:
CREATE TABLE IF NOT EXISTS `tblretailer` (
`retailerid` int(11) NOT NULL AUTO_INCREMENT,
`retailername` varchar(75) DEFAULT NULL,
`retaileraddress` varchar(50) DEFAULT NULL,
`retaileraddress2` varchar(50) DEFAULT NULL,
`retailercity` varchar(25) DEFAULT NULL,
`retailerphone` varchar(15) DEFAULT NULL,
`retailerfax` varchar(15) DEFAULT NULL,
`retailerstate` int(11) DEFAULT NULL,
`retailerzip` varchar(15) DEFAULT NULL,
`retaileremail` varchar(50) DEFAULT NULL,
`retailerwebpage` varchar(70) DEFAULT NULL,
`retailerregionid` int(11) DEFAULT NULL,
`subretailerregionid` varchar(70) DEFAULT NULL,
`retorcomm` int(11) DEFAULT '0',
`retailertype` tinyint(4) DEFAULT '1',
`cnt_name1` varchar(75) DEFAULT NULL,
`cnt_email1` varchar(50) DEFAULT NULL,
`cnt_phone1` varchar(15) DEFAULT NULL,
`cnt_name2` varchar(75) DEFAULT NULL,
`cnt_email2` varchar(50) DEFAULT NULL,
`cnt_phone2` varchar(15) DEFAULT NULL,
`memb_Info` text,
`pdfpath` varchar(60) DEFAULT NULL,
`tollfree_no` varchar(30) DEFAULT NULL,
`keyword` varchar(255) DEFAULT NULL,
`estar` smallint(2) DEFAULT '0',
`lat` float(10,6) DEFAULT NULL COMMENT 'added 2/2012',
`lng` float(10,6) DEFAULT NULL COMMENT 'added 2/2012',
`UserPassword` varchar(500) DEFAULT NULL COMMENT 'password',
PRIMARY KEY (`retailerid`)