This class is used for retrieve member information according to their birthday sequence from today (current date).
If today is June 20 then the output like:
Your Name june 20th
Hello Liza july 10th
Md. Aminul Islam september 10th
Md. Kamrul Islam december 31st
Sumon january 10th
Lata Pata June 2nd
create database named "aminul"
Run the script to create database table.
----------------------------------------------
--
-- Table structure for table `pla_registration`
--
CREATE TABLE registration (
MemberId int(11) NOT NULL auto_increment,
FirstName varchar(100)NOT NULL,
SirName varchar(100)NOT NULL,
DateOfBirth varchar(100)NOT NULL default '0000-00-00',
PRIMARY KEY (`MemberId`)
) ;
--
-- Dumping data for table `registration`
--
INSERT INTO `registration` VALUES (1, 'Aminul', 'Islam', '1980-09-10');
INSERT INTO `registration` VALUES (2, 'Your', 'Name', '1984-10-25');
INSERT INTO `registration` VALUES (3, 'Kamrul', 'Islam', '1978-11-09');
INSERT INTO `registration` VALUES (4, 'Yahoo', 'Group', '1978-10-09');
INSERT INTO `registration` VALUES (5, 'Sabbir', 'Ahmed', '1978-03-09');
INSERT INTO `registration` VALUES (6, 'Lata', 'Yeasmin', '1950-07-25');
INSERT INTO `registration` VALUES (7, 'Biju', 'Ahmed', '1982-09-25');
INSERT INTO `registration` VALUES (8, 'Sami', 'AlIslam', '1978-07-15');
|