CREATE TABLE hvcPledge (
  'hvcID'          INT(5) NOT NULL AUTO_INCREMENT,
  'intime'         DATETIME,
  'last_name1'     VARCHAR(50) NOT NULL,
  'first_name1'    VARCHAR(50) NOT NULL,
  'middle_name1'   VARCHAR(1),
  'addr1_street'   VARCHAR(65) NOT NULL,
  'addr1_city'     VARCHAR(50) NOT NULL,
  'addr1_state'    CHAR(2) NOT NULL,
  'addr1_zip'      CHAR(10) NOT NULL,
  'addr1_h_phone'  VARCHAR(29) NOT NULL,
  'addr1_e_mail'   VARCHAR(65) NOT NULL,
  'last_Name2'     VARCHAR(50),
  'first_Name2'    VARCHAR(50),
  'middle_name2'   VARCHAR(1),
  'addr2_street'   VARCHAR(65),
  'addr2_city'     VARCHAR(50),
  'addr2_state'    CHAR(2),
  'addr2_zip'      CHAR(10),
  'addr2_h_phone'  VARCHAR(29),
  'addr2_e_mail'   VARCHAR(65),
  'first_name_c1'  VARCHAR(50) NOT NULL,
  'grade1'         VARCHAR(6) NOT NULL,
  'school1'        VARCHAR(17) NOT NULL,
  'first_name_c2'  VARCHAR(50),
  'grade2'         VARCHAR(6),
  'school2'        VARCHAR(17),
  'first_name_c3'  VARCHAR(50),
  'grade3'         VARCHAR(6),
  'school3'        VARCHAR(17),
  'first_name_c4'  VARCHAR(50),
  'grade4'         VARCHAR(6),
  'school4'        VARCHAR(17),
  'first_name_c5'  VARCHAR(50),
  'grade5'         VARCHAR(6),
  'school5'        VARCHAR(17),
  'comments'       TEXT(364),
  'first_name_cp'  VARCHAR(50) NOT NULL,
  'middle_name_cp' VARCHAR(1),
  'last_name_cp'   VARCHAR(50) NOT NULL,
  PRIMARY KEY  ('hvcID')
);



 Status:SetupHost
 Name:p50mysql239.secureserver.net
 Database Name:hvcDatabase
 Database Version:5.0
 Description:Hills Valley Coalition
 User Name:hvcDatabase



Status: Setup
 Host Name: p50mysql231.secureserver.net
 Database Name: memDirectory
 Database Version: 5.0
 Description: practice for class
 User Name: memDirectory


$text = preg_replace("/([0-9]{5})([0-9]{4})/", "$1-$2", $text); //zip code replace