Login   Register  
PHP Classes
elePHPant
Icontem

File: Instruction.txt

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Md. Aminul Islam  >  Birthday Ordering  >  Instruction.txt  >  Download  
File: Instruction.txt
Role: Auxiliary data
Content type: text/plain
Description: Instruction and Database
Class: Birthday Ordering
Retrieve user database records sorted by birthday
Author: By
Last change:
Date: 2006-12-07 21:29
Size: 1,367 bytes
 

Contents

Class file image Download
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');