Hi Dear all
Its my table structure...
CREATE TABLE IF NOT EXISTS `limsrentpayment` (
`PaymentMonth` varchar(15) NOT NULL,
`SiteID` varchar(15) NOT NULL,
`DurationS` varchar(25) NOT NULL,
`DurationE` varchar(25) NOT NULL,
`Amount` varchar(15) NOT NULL,
`pDate` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
and data stored in it
INSERT INTO `limsrentpayment` (`PaymentMonth`, `SiteID`, `DurationS`, `DurationE`, `Amount`, `pDate`) VALUES
('Dec-09', 'C-LHR-7300', '1-Dec-09', '30-Nov-10', '252,000.00', '2009-11-23'),
('Nov-09', 'C-ADP-5900', '8-Nov-09', '7-Nov-10', '152,769.00', '2009-11-12'),
('Nov-09', 'C-BAX-5825', '9-Nov-09', '8-Nov-10', '105,840.00', '2009-11-12');
another table is
CREATE TABLE IF NOT EXISTS `limscheaquesdispatched` (
`SiteID` varchar(12) NOT NULL,
`BaseAmount` varchar(25) NOT NULL,
`cDate` date NOT NULL,
`DurationSY` varchar(25) NOT NULL,
`DurationEY` varchar(25) NOT NULL,
`BatNo` varchar(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
and values are
INSERT INTO `limscheaquesdispatched` (`SiteID`, `BaseAmount`, `cDate`, `DurationSY`, `DurationEY`, `BatNo`) VALUES
('C-LHR-7300', '208,596.00', '2009-12-07', '09', '10', 'BAT364'),
('C-ADP-5900', '212,700.00', '2009-12-07', '09', '10', 'BAT364'),
('C-BAX-5825', '158,322.00', '2009-12-07', '09', '10', 'BAT364');
Now For one year I can easily show
Year, Due Date ,Date Sent To Finance, Date Returned From Finance, Date Resubmitted To Finance, Date Cheque Issued, Date Cheque Received by Owner, Payment Status
But I have to show it for more years.
Please check attached image.
I am confused.....!!!
For showing like this how I can store Data, i means structure of DB.