Re: php edit data page issue
Posted: Tue Jun 30, 2015 1:58 pm
So you're getting 9 rows per user?ianhaney wrote:The only issue is the renewal data is being duplicated 3 times
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
So you're getting 9 rows per user?ianhaney wrote:The only issue is the renewal data is being duplicated 3 times
Code: Select all
CREATE TABLE IF NOT EXISTS `renewal` (
`renewal_id` int(11) NOT NULL AUTO_INCREMENT,
`id` int(11) NOT NULL,
`item_id` int(11) NOT NULL,
`renewal_date` date NOT NULL,
`date_notified` datetime DEFAULT NULL,
PRIMARY KEY (`renewal_id`),
KEY `renewal_id` (`renewal_id`),
KEY `renewal_id_2` (`renewal_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=217 ;