Back to previous page

jkkenzie · August 6, 2008

Hi!

After a user finishes entering data and saves the data, if php validation gets an error and 'echo' back the error, WHAT is the code syntax to go back to the previous page and WITH data still at the input boxes and highlighting the boxes with errors.

Or an alternative.

Regards,

Joseph

MasterACE14 · August 6, 2008

I believe its the web browser that determines whether you go back a page and it will keep the form data in it.

And you can use javascript to go back.

Third_Degree · August 6, 2008

Keep everything on one page and use get variables to move along the steps of form submission.

Bare Bones Example:

<?php
switch( $_GET['action'] ) {
case 'form':
	print '<form action="this.php?action=submit" method="post">
	Name: <input type="text" name="name" /><br />
	<input type="submit" value="Submit" />
	</form>';
	break;
case 'submit':
	if ( $_POST['name'] == '' ) {
		print '<form action="this.php?action=submit" method="post">
		Name (Field Left Blank!): <input type="text" name="name" /><br />
		<input type="submit" value="Submit" />
		</form>';
	}
	break;
}
?>

Third_Degree · August 6, 2008

MasterACE14 is right if you simply want to return, but I thought you said highlight errors.

dilum · August 6, 2008

I don't know where to post your page data, If u post the data to the same page , then you can cath all the data whatever user entered. (while you can highlight the error fields also).

MasterACE14 · August 6, 2008

give us some code to work with jkkenzie

jkkenzie · August 7, 2008

Database part 1

-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Aug 07, 2008 at 04:25 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `emobase`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `banks`
-- 

CREATE TABLE `banks` (
  `strBanks` varchar(70) default NULL,
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

-- 
-- Dumping data for table `banks`
-- 

INSERT INTO `banks` (`strBanks`, `id`) VALUES 
('--- Select Bank ---', 1),
('ABC', 2),
('BARCLAYS', 3),
('BARINGO SACCO', 4),
('CENTRAL BANK', 5),
('CO-OPERATIVE', 6),
('EQUITY', 7),
('KCB', ,
('NIC', 9),
('Other', 10),
('POST BANK', 11);

-- --------------------------------------------------------

-- 
-- Table structure for table `countries`
-- 

CREATE TABLE `countries` (
  `strCountry` varchar(70) NOT NULL,
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

-- 
-- Dumping data for table `countries`
-- 

INSERT INTO `countries` (`strCountry`, `id`) VALUES 
('--- Select Country ---', 1),
('AUSTRALIA', 2),
('CANADA', 3),
('CHINA', 4),
('EGYPT', 5),
('ERITREA', 6),
('ETHIOPIA', 7),
('FRANCE', ,
('GERMANY', 9),
('KENYA', 10),
('MEXICO', 11),
('Other', 12),
('POLAND', 13),
('SOMALIA', 14),
('SUDAN', 15),
('TANZANIA', 16),
('UGANDA', 17),
('UK', 18),
('USA', 19);

-- --------------------------------------------------------

-- 
-- Table structure for table `country of residence`
-- 

CREATE TABLE `country of residence` (
  `strCountryOfResidence` varchar(70) NOT NULL,
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

-- 
-- Dumping data for table `country of residence`
-- 

INSERT INTO `country of residence` (`strCountryOfResidence`, `id`) VALUES 
('--- Select Country Of Residence ---', 1),
('AUSTRALIA', 2),
('CANADA', 3),
('EGYPT', 4),
('ERITREA', 5),
('ETHIOPIA', 6),
('FRANCE', 7),
('GERMANY', ,
('KENYA', 9),
('MEXICO', 10),
('Other', 11),
('POLAND', 12),
('SOMALIA', 13),
('SUDAN', 14),
('TANZANIA', 15),
('UGANDA', 16),
('UK', 17),
('USA', 18);

-- --------------------------------------------------------

-- 
-- Table structure for table `divisions`
-- 

CREATE TABLE `divisions` (
  `strDivision` varchar(255) default NULL,
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=227 ;

-- 
-- Dumping data for table `divisions`
-- 

INSERT INTO `divisions` (`strDivision`, `id`) VALUES 
('--- Select Division ---', 1),
('AINABKOI', 2),
('AINAMOI', 3),
('ALDAI', 4),
('ALINAMOI', 5),
('BAHATI', 6),
('BARATON', 7),
('BARINGO CENTRAL', ,
('BARTABWA', 9),
('BARWESSA', 10),
('BARWEZA', 11),
('BELGUT', 12),
('BIRAR', 13),
('BOMET', 14),
('BOMET CENTRAL', 15),
('BUELGUT', 16),
('BURET', 17),
('BURETI', 18),
('BURNT FOREST', 19),
('CENRAL', 20),
('CENTRAL', 21),
('CHBIEMET', 22),
('CHEBIEMIT', 23),
('CHEBIYEMIT', 24),
('CHEBORGET', 25),
('CHEBUNYO', 26),
('CHEMUNDU', 27),
('CHEPAKUNDI', 28),
('CHEPKORIO', 29),
('CHEPSEON', 30),
('CHEPSION', 31),
('CHEPTALAL', 32),
('CHEPTERIT', 33),
('CHEPWANGAN', 34),
('CHERAGANY', 35),
('CHERANGANI', 36),
('CHICHILA', 37),
('CKAPCHEROP', 38),
('DIKIRR', 39),
('E/ RAVINE', 40),
('ELBURGON', 41),
('ELDAMA RAVINE', 42),
('ELDAMA/RAVINE', 43),
('ELDORET  EAST', 44),
('ELDORET SOUTH', 45),
('EMINIG', 46),
('EMINING', 47),
('EMINNING', 48),
('ESAGERI', 49),
('ESSGERI', 50),
('EWALEL', 51),
('FLAX', 52),
('FORTENAN', 53),
('GELEGELE', 54),
('ILMOTIOK', 55),
('IRONG', 56),
('KABARNET', 57),
('KABARTONJO', 58),
('KABIANGA', 59),
('KABIANGA KABIANGA', 60),
('KABIYET', 61),
('KABURGEI', 62),
('KAMARA', 63),
('KAMARINY', 64),
('KAMWOSOR', 65),
('KAPCHEROP', 66),
('KAPENGURIA', 67),
('KAPIPICH', 68),
('KAPKATET', 69),
('KAPLAMAI', 70),
('KAPSABET', 71),
('KAPSAOS', 72),
('KAPSARET', 73),
('KAPSBET', 74),
('KAPSERET', 75),
('KAPSOKWONY', 76),
('KAPSOWAR', 77),
('KAPTARAKWA', 78),
('KAPTEBEREWO', 79),
('KAPTEL', 80),
('KAPTUMO ', 81),
('KAPTUMO NORTH', 82),
('KAPYAMA', 83),
('KATUMO NORTH', 84),
('KEIYO ', 85),
('KEIYO NORTH', 86),
('KERICHO', 87),
('KERICHO TOWN', 88),
('KERINGET', 89),
('KESESS', 90),
('KESSES', 91),
('KEYIAN', 92),
('KILGORIS', 93),
('KILIBUNI', 94),
('KILIBWONI', 95),
('KILIGORIS', 96),
('KIMININI', 97),
('KIMNAI', 98),
('KIMNGOROM', 99),
('KIMOTIOK', 100),
('KIMULOT', 101),
('KIMULUT', 102),
('KIPKAREN', 103),
('KIPKAREN SALIENT', 104),
('KIPKELION', 105),
('KIPKELYON', 106),
('KIPSARAMAN', 107),
('KIPSOMBE', 108),
('KIPSONOI', 109),
('KIPTULWO', 110),
('KIRINDON', 111),
('KIRINDONI', 112),
('KIRINGET', 113),
('KISANANA', 114),
('KOBUJOI', 115),
('KOILOT', 116),
('KONGASIA', 117),
('KONGASIS', 118),
('KONGONI', 119),
('KONOIN', 120),
('KOSIRAI', 121),
('KOSIRAY', 122),
('KUINET', 123),
('KUNUIN', 124),
('KURESOI', 125),
('KWANZA', 126),
('LAMURIA', 127),
('LAONGISA', 128),
('LELAN', 129),
('LESHAU ', 130),
('LESSOS', 131),
('LIKUYANI', 132),
('LITEIN', 133),
('LODIANI', 134),
('LOGISA', 135),
('LOLGORIEN', 136),
('LOLKURTO', 137),
('LONDIANI', 138),
('LONGISA', 139),
('MARICHOR', 140),
('MARIGAT', 141),
('MAUCHE', 142),
('MAU-CHE', 143),
('MBOGOINI', 144),
('MBOGONI', 145),
('MELELO', 146),
('MERIGI', 147),
('METKEI', 148),
('MOCHONGOI', 149),
('MOGOGOSIEK', 150),
('MOGOTIO', 151),
('MOIBEN', 152),
('MOLO', 153),
('MOSOP', 154),
('MUCHONGOI', 155),
('MULOT', 156),
('MUMBERES', 157),
('MUNICIPALITY', 158),
('MUTARAKWA', 159),
('NANDI HILLS', 160),
('NDANAI', 161),
('NDARAGUA', 162),
('NDARAGWA', 163),
('NGARIA', 164),
('NGARUA', 165),
('NG''ARUA', 166),
('NGERIA', 167),
('NJORO', 168),
('OLARE', 169),
('OLEGURUNUONE', 170),
('OLENGURUONE', 171),
('OLKURTO', 172),
('OL''LESOSS', 173),
('OLLESSOS', 174),
('OLOLULUNGA', 175),
('OLOLUNGA', 176),
('OLULUNGA', 177),
('PERKERRA', 178),
('PIRARR', 179),
('PLATEU', 180),
('RAVINE', 181),
('RONGAI', 182),
('RORET', 183),
('RORET/EMBWEN', 184),
('RUMURUTI', 185),
('SABATIA', 186),
('SABOTI', 187),
('SACHO', 188),
('SALAMA', 189),
('SALAWA', 190),
('SIGOR', 191),
('SIGOT', 192),
('SIGOWET', 193),
('SILIBWET', 194),
('SINGIROI', 195),
('SINGOROI', 196),
('SIONGIRIO', 197),
('SIONGIROI', 198),
('SIRGOR SOUTH', 199),
('SIRWA', 200),
('SIRWA / KIMNGOROM', 201),
('SIRWA KIMONGROM', 202),
('SIX', 203),
('SOI', 204),
('SOIN', 205),
('SOTIK', 206),
('SOUTHERN', 207),
('SOY', 208),
('SUBUKIA', 209),
('SYPI', 210),
('TAMBACH', 211),
('TARAKWO', 212),
('TECHOGET', 213),
('TENGES', 214),
('TIMBOROA', 215),
('TINDERET', 216),
('TINGEY', 217),
('TIRAP', 218),
('TIRIKI WEST', 219),
('TORONGO', 220),
('TOT', 221),
('TRANS NZOIA', 222),
('TUIYO', 223),
('TUMEIYO', 224),
('TUNYO', 225),
('TURBO', 226);

-- --------------------------------------------------------

-- 
-- Table structure for table `emo_users`
-- 

CREATE TABLE `emo_users` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `username` varchar(25) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `password` varchar(100) NOT NULL,
  `usertype` varchar(25) NOT NULL default '',
  `block` tinyint(4) NOT NULL default '0',
  `sendEmail` tinyint(4) default '0',
  `gid` tinyint(3) unsigned NOT NULL default '1',
  `registerDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `lastvisitDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `activation` varchar(100) NOT NULL default '',
  `params` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `usertype` (`usertype`),
  KEY `idx_name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=63 ;

-- 
-- Dumping data for table `emo_users`
-- 

INSERT INTO `emo_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`, `activation`, `params`) VALUES 
(62, 'Administrator', 'admin', 'jkkenzie@gmail.com', 'superman', 'Super Administrator', 0, 1, 25, '2008-06-15 13:48:03', '0000-00-00 00:00:00', '', '');

-- --------------------------------------------------------

-- 
-- Table structure for table `form of payment`
-- 

CREATE TABLE `form of payment` (
  `strFormOfPayments` varchar(70) NOT NULL,
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

-- 
-- Dumping data for table `form of payment`
-- 

INSERT INTO `form of payment` (`strFormOfPayments`, `id`) VALUES 
('--- Select Form of Payment ---', 1),
('BANK DRAFT', 2),
('CASH', 3),
('CHEQUE', 4),
('CREDIT CARD', 5),
('DEPOSIT SLIP', 6),
('GOLDEN ', 7),
('LPO', ,
('MONEY TRANSFER', 9),
('Other', 10),
('SMART CARD', 11);

-- --------------------------------------------------------

-- 
-- Table structure for table `gender`
-- 

CREATE TABLE `gender` (
  `SEX` varchar(50) NOT NULL,
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `gender`
-- 

INSERT INTO `gender` (`SEX`, `id`) VALUES 
('--- Select Gender ---', 1),
('Female', 2),
('Male', 3),
('Other', 4);

MasterACE14 · August 7, 2008

PHP code not mysql :-\

jkkenzie · August 7, 2008

Database part 2

-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Aug 07, 2008 at 04:26 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `emobase`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `home districts`
-- 

CREATE TABLE `home districts` (
  `strHomeDistrict` varchar(255) NOT NULL,
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=78 ;

-- 
-- Dumping data for table `home districts`
-- 

INSERT INTO `home districts` (`strHomeDistrict`, `id`) VALUES 
('--- Select Home District ---', 1),
('ABOSI', 2),
('AINAKOI', 3),
('AINAMOI', 4),
('BARINGO', 5),
('BARINGO CENTTRAL', 6),
('BARUT', 7),
('BELGUT', ,
('BOMET', 9),
('BUKURO', 10),
('BURET', 11),
('BURETI', 12),
('BURETI/NANDI', 13),
('ELDORET', 14),
('ELDORET EAST', 15),
('GUCHA', 16),
('KAKAMEGA', 17),
('KAPCHORWA', 18),
('KAPLAMAI', 19),
('KAPSABET', 20),
('KAPSAWAR', 21),
('KEIYO', 22),
('KEIYO SOUTH', 23),
('KERICHO', 24),
('KIBAMWA', 25),
('KILGORIS', 26),
('KIPKATA', 27),
('KIPKELION', 28),
('KIPKELOIN', 29),
('KITALE EAST', 30),
('KOIBATEK', 31),
('LAIKIPIA', 32),
('LAIKIPIA EAST', 33),
('LAIKIPIA WEST', 34),
('LAKIPIA WEST', 35),
('LESHAN', 36),
('LITEIN', 37),
('LUGARI', 38),
('MACHAKOS', 39),
('MARAKWET', 40),
('MARICHOR', 41),
('MATHINGIRA', 42),
('METKEI', 43),
('MOIBEN', 44),
('MOLO', 45),
('MT ELGON', 46),
('MT. ELGON', 47),
('NAIVASHA', 48),
('NAKURU', 49),
('NAKURU/MOLO', 50),
('NANDI', 51),
('NANDI HILLS', 52),
('NANDI NORTH', 53),
('NANDI SOUTH', 54),
('NAROK', 55),
('NAROK NORTH', 56),
('NAROK SOUTH', 57),
('NORTH NANDI', 58),
('NYAHURURU', 59),
('NYANDARUA', 60),
('OLENGURURNE', 61),
('RONGAI', 62),
('RONGAI/NAKURU', 63),
('SIRWA', 64),
('SOTIK', 65),
('T.S.C', 66),
('TORONGO', 67),
('TRANS MARA', 68),
('TRANS NZOIA', 69),
('TRANS NZOIA E.', 70),
('TRANSMARA', 71),
('TRANSZOIA', 72),
('TRANSZOIA WEST', 73),
('TSC', 74),
('UASIN GISHU', 75),
('VIHIGA', 76),
('WEST POKOT', 77);

-- --------------------------------------------------------

-- 
-- Table structure for table `locations`
-- 

CREATE TABLE `locations` (
  `strLocation` varchar(255) default NULL,
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=540 ;

-- 
-- Dumping data for table `locations`
-- 

INSERT INTO `locations` (`strLocation`, `id`) VALUES 
('--- Select Location ---', 1),
('ABOSI', 2),
('AINABKOI', 3),
('AINAMOI', 4),
('AMALU', 5),
('ANAIBKOI', 6),
('ARABAL ', 7),
('AROR', ,
('ARWOS', 9),
('BARATON', 10),
('BARSIELE', 11),
('BARSOMBE', 12),
('BARTUM', 13),
('BARTWA', 14),
('BARUT', 15),
('BEKIBON', 16),
('BINGWA', 17),
('BOITO', 18),
('BOMET CENTRAL', 19),
('BOMET TOWNSHIP', 20),
('BONJOGE', 21),
('BOROR', 22),
('BUITU', 23),
('BUKWO', 24),
('BURET', 25),
('BURNT FOREST', 26),
('CHAPCHAP', 27),
('CHEBANGANG', 28),
('CHEBAROR', 29),
('CHEBEREN', 30),
('CHEBOIN', 31),
('CHEBORGE', 32),
('CHEBOROR', 33),
('CHEBUNYO', 34),
('CHEBWAGA', 35),
('CHELEGET', 36),
('CHEMAGEL', 37),
('CHEMALE', 38),
('CHEMAMUL', 39),
('CHEMANER', 40),
('CHEMASE', 41),
('CHEMASIS', 42),
('CHEMELET', 43),
('CHEMNER', 44),
('CHEMOIBEN', 45),
('CHEMOIBON', 46),
('CHEMOIYWA', 47),
('CHEMOMI', 48),
('CHEMOSET', 49),
('CHEMOSOT', 50),
('CHEMUL', 51),
('CHEMUNDU', 52),
('CHEPKOILEL', 53),
('CHEPKORIO', 54),
('CHEPLANGET', 55),
('CHEPLASKEI', 56),
('CHEPLEWA', 57),
('CHEPNGAINA', 58),
('CHEPNGANG', 59),
('CHEPNGOROR', 60),
('CHEPSEON', 61),
('CHEPSIEON', 62),
('CHEPSION', 63),
('CHEPSIRO', 64),
('CHEPSOEN', 65),
('CHEPTALAL', 66),
('CHEPTERIT', 67),
('CHEPTERWAI', 68),
('CHEPTIRET', 69),
('CHEPTUECH', 70),
('CHEPTUIYET', 71),
('CHEPWAGAN', 72),
('CHERAGANI', 73),
('CHERANGANI', 74),
('CHERANGANY', 75),
('CHERANGANYI', 76),
('CHESEGEM', 77),
('CHESEON', 78),
('CHESINENDE', 79),
('CHESOEN', 80),
('CHESUMAN', 81),
('CHICHILA', 82),
('CHUIYAT', 83),
('DIKIR', 84),
('DONDORI', 85),
('E/ RAVINE', 86),
('ELBURGON', 87),
('ELDAMA RAVINE', 88),
('EMARTI', 89),
('EMINING', 90),
('EMOM', 91),
('ENDO', 92),
('EWALEL', 93),
('GATARWET/KAPSABET', 94),
('GELEGELE', 95),
('GETARWET', 96),
('GITUAMBA', 97),
('INDER', 98),
('IRAA', 99),
('IROG', 100),
('IRONG', 101),
('IRONGO', 102),
('IRONY', 103),
('ITEMBE', 104),
('ITIGO', 105),
('JEPKOYAI', 106),
('KABAIMWA', 107),
('KABAINGA', 108),
('KABARNET ', 109),
('KABARNET MOSOP', 110),
('KABARNET SOI', 111),
('KABARNET ZONE', 112),
('KABARONJO', 113),
('KABARTEGAN', 114),
('KABASIS', 115),
('KABEI', 116),
('KABIAGA', 117),
('KABIANGA', 118),
('KABIEMIT', 119),
('KABIMOI SAGAT', 120),
('KABISAGA', 121),
('KABIYEMIT', 122),
('KABIYET', 123),
('KABOI', 124),
('KABOSKEI KERIO', 125),
('KABOSON', 126),
('KABOYWA', 127),
('KABUTIEI', 128),
('KAISAGAT', 129),
('KAITUI', 130),
('KAKIMOR', 131),
('KALABATA', 132),
('KAMAGET', 133),
('KAMAGUT', 134),
('KAMAR', 135),
('KAMARA', 136),
('KAMARING', 137),
('KAMARINY', 138),
('KAMASIA', 139),
('KAMASIAN', 140),
('KAMASIN', 141),
('KAMOGICH', 142),
('KAMOI', 143),
('KAMOIWA', 144),
('KAMOIYA', 145),
('KAMOIYWO', 146),
('KAMOSOR', 147),
('KAMOYWA', 148),
('KAMUNERU', 149),
('KAMUNGEI', 150),
('KAMWELIL', 151),
('KAMWOSOR', 152),
('KANUSIN', 153),
('KAPCHELAL', 154),
('KAPCHEMUTWA', 155),
('KAPCHEMUTWO', 156),
('KAPCHOMBE', 157),
('KAPCHORUA', 158),
('KAPKANGANI', 159),
('KAPKATET', 160),
('KAPKECHUI', 161),
('KAPKELEI', 162),
('KAPKENGETUNY', 163),
('KAPKESASIO', 164),
('KAPKESOSIO', 165),
('KAPKIMOLWA', 166),
('KAPKISIRA', 167),
('KAPKOBAI', 168),
('KAPKOI', 169),
('KAPKOIJAN', 170),
('KAPKOIMOR', 171),
('KAPKORIO', 172),
('KAPKOROS', 173),
('KAPKUGERWET', 174),
('KAPKURES', 175),
('KAPKWONY', 176),
('KAPLAMAI', 177),
('KAPLELARTET', 178),
('KAPLETUNDO', 179),
('KAPLONG', 180),
('KAPNGETUNY', 181),
('KAPSABET', 182),
('KAPSANG', 183),
('KAPSAOS', 184),
('KAPSARET', 185),
('KAPSASIAN', 186),
('KAPSEGER', 187),
('KAPSERET', 188),
('KAPSET', 189),
('KAPSIMBEIWO', 190),
('KAPSIMOTWO', 191),
('KAPSINENDET', 192),
('KAPSOGUT', 193),
('KAPSOIT', 194),
('KAPSOWAR', 195),
('KAPSOYA', 196),
('KAPSUMAI', 197),
('KAPSURER', 198),
('KAPSUSER', 199),
('KAPTABUK', 200),
('KAPTAGAT', 201),
('KAPTALAMWA', 202),
('KAPTARAKWA', 203),
('KAPTEBENGTWET', 204),
('KAPTEBENGWET', 205),
('KAPTEBEREWO', 206),
('KAPTEBERWO', 207),
('KAPTEL', 208),
('KAPTEREN', 209),
('KAPTIEN', 210),
('KAPTOBOITI', 211),
('KAPTULI', 212),
('KAPTUMO', 213),
('KAPTUMO NORTH', 214),
('KAPTUMO SOUTH', 215),
('KAPUNE', 216),
('KAPYEMIT', 217),
('KASEREM', 218),
('KASOIYO', 219),
('KATABUK', 220),
('KATARET', 221),
('KATIORIN', 222),
('KEBENETI', 223),
('KEBULONIK', 224),
('KEDOWA', 225),
('KEIYO', 226),
('KELELWA', 227),
('KEMBU', 228),
('KEMEGUT', 229),
('KEMELIO', 230),
('KENEGUT', 231),
('KERIO', 232),
('KESSES', 233),
('KEU', 234),
('KIBABET', 235),
('KIBAIMWA', 236),
('KIBARGOI', 237),
('KIBOIWO', 238),
('KIBOMET', 239),
('KIBONJOS', 240),
('KIBUGAT', 241),
('KILIBWONI', 242),
('KILIGORIS', 243),
('KIMAWIT', 244),
('KIMININI', 245),
('KIMONING', 246),
('KIMORIOT', 247),
('KIMOSE', 248),
('KIMOSON', 249),
('KIMUAUL', 250),
('KIMUGUL', 251),
('KIMULOT', 252),
('KIMUMU', 253),
('KIMWOKIT', 254),
('KINYACH', 255),
('KINYELWET', 256),
('KINYORO', 257),
('KIPCHAMO', 258),
('KIPCHORIAN', 259),
('KIPKABUS', 260),
('KIPKAREN', 261),
('KIPKATA', 262),
('KIPKEBE', 263),
('KIPKESOSIO', 264),
('KIPKEWA', 265),
('KIPKOIYAN', 266),
('KIPKOYAN', 267),
('KIPLABOTWA', 268),
('KIPLOMBE', 269),
('KIPSAINA', 270),
('KIPSAIYA', 271),
('KIPSANGUI', 272),
('KIPSAOS', 273),
('KIPSERTON', 274),
('KIPSINENDE', 275),
('KIPSIRICHET', 276),
('KIPSOGON', 277),
('KIPSOLA', 278),
('KIPSOLU', 279),
('KIPSOMBA', 280),
('KIPSOMBE', 281),
('KIPSONOI', 282),
('KIPSORIO', 283),
('KIPSULU', 284),
('KIPTENDEN', 285),
('KIPTENNDEN', 286),
('KIPTERE', 287),
('KIPTERES', 288),
('KIPTOIM', 289),
('KIPTOME', 290),
('KIPTORO', 291),
('KIPTULWA', 292),
('KIPTUWO', 293),
('KIRIMWO', 294),
('KIROMWOK', 295),
('KISANANA', 296),
('KISIARA', 297),
('KITALE MUNICIPALITY', 298),
('KITANY', 299),
('KITUAMBA', 300),
('KITURO', 301),
('KOCHOLWO', 302),
('KOIBATEK', 303),
('KOIBIRIR', 304),
('KOIBOS SOI', 305),
('KOILOT', 306),
('KOISAGAT', 307),
('KOITOROR', 308),
('KOIWA', 309),
('KOKOT', 310),
('KOKWAO', 311),
('KOKWET', 312),
('KOKWOI', 313),
('KONGASIS', 314),
('KOPKOI', 315),
('KOSIRAI', 316),
('KOSOIYWO', 317),
('KOYO', 318),
('KURESOI', 319),
('KURGUNG', 320),
('KUSENWO', 321),
('KUSERWO', 322),
('KYOGONG', 323),
('LAWAN', 324),
('LELACHTICH', 325),
('LELAITICH', 326),
('LELMOKWO', 327),
('LEMBUS ', 328),
('LEMBUS CENTRAL', 329),
('LEMBUS CHEMORKONG', 330),
('LEMBUS KAPTUMO', 331),
('LEMBUS KIPTUIM', 332),
('LEMBUS MOGOTIO', 333),
('LEMBUS MOSOP', 334),
('LEMEK', 335),
('LEMOTIT', 336),
('LEMOTTI', 337),
('LESHAU', 338),
('LESHAW', 339),
('LESSOS', 340),
('LITEIN', 341),
('LOLKERINGET', 342),
('LOLMINIGAI', 343),
('LONDIANI', 344),
('LONGISA', 345),
('LONGISAndubai', 346),
('LORTEN', 347),
('LOWER SUBUKIA', 348),
('MAKIMENY', 349),
('MAOI', 350),
('MARICHOR', 351),
('MARMANET', 352),
('MASAITA', 353),
('MATHINGIRA', 354),
('MATOBO', 355),
('MAU NAROK', 356),
('MAUSUMMIT', 357),
('MBUYU', 358),
('MEGUN', 359),
('MERIGI', 360),
('METEITEI', 361),
('METKEI', 362),
('MNAGEI', 363),
('MOBEGO', 364),
('MOCHONGOI', 365),
('MOGOBICH', 366),
('MOGOGOSIEK', 367),
('MOGOSOEK', 368),
('MOIBEN', 369),
('MOINDABI', 370),
('MOIS BRIDGE', 371),
('MOLO', 372),
('MOSONIK', 373),
('MOSOP', 374),
('MOTIRET', 375),
('MOTOSIET', 376),
('MOTOTO', 377),
('MOW', 378),
('MUGANGO', 379),
('MUGEN', 380),
('MUGOR', 381),
('MUHOTETY', 382),
('MULOT', 383),
('MUMBERES', 384),
('MUNICIPALITY', 385),
('MUTARAKWA', 386),
('MUTEI', 387),
('MUTHENGERA', 388),
('MUTWOT', 389),
('NAKURU', 390),
('NANDI HILLS', 391),
('NDALAT', 392),
('NDANAI', 393),
('NDARAWETTA', 394),
('NDERAWET', 395),
('NDURIO', 396),
('NEIBEKI', 397),
('NGATA', 398),
('NGECHEK', 399),
('NGENDALEL', 400),
('NGENYILEL', 401),
('NGERERIT', 402),
('NGERIA', 403),
('NGESUMIN', 404),
('NGETMOI', 405),
('NJIPISHIP', 406),
('NYARU', 407),
('OL DONYOOROK', 408),
('OL LEINGUSESE', 409),
('OLAINGUSE', 410),
('OLALUI', 411),
('OLARE', 412),
('OLENGURUON', 413),
('OLENGUSE', 414),
('OLESSOS', 415),
('OLLAINGUSE', 416),
('OLLESSOS', 417),
('OLMEKENYU', 418),
('OLOIBORSOITO', 419),
('OLOLMASANI', 420),
('OLOLULUNGA', 421),
('OLOONTARE', 422),
('OLPUSIMORI', 423),
('OLPUSIMURU', 424),
('OLULMASANI', 425),
('OROKWO', 426),
('OSSEN', 427),
('PEKERA', 428),
('PERKERRA', 429),
('PIONEER', 430),
('PLATEAU', 431),
('POIYWEK', 432),
('POKOR KEBEN KWEN', 433),
('POROR', 434),
('RAVINE', 435),
('RONGAI', 436),
('RONGENA', 437),
('RONGENE', 438),
('RONGEYA', 439),
('RORET', 440),
('ROSAGA', 441),
('ROSOGA', 442),
('RUMURUTI', 443),
('SABATIA', 444),
('SACHO', 445),
('SACHO SOI', 446),
('SAGAMIAN', 447),
('SAIMO', 448),
('SAIMO  MOSOP', 449),
('SALAMA', 450),
('SAMBIRIR', 451),
('SANGALO', 452),
('SANGCHOR', 453),
('SAOS', 454),
('SAOS KIBIAS', 455),
('SARORA', 456),
('SATIET', 457),
('SEGERO', 458),
('SEGO', 459),
('SEGUTON', 460),
('SENENTET', 461),
('SENGWER', 462),
('SERGOIT', 463),
('SHAWA', 464),
('SIBAYAGAN', 465),
('SIBAYAN', 466),
('SIBIYAN', 467),
('SIGOR NORTH', 468),
('SIGOR SOUTH', 469),
('SIGORO', 470),
('SIGORO -KIPTUNO', 471),
('SIGORO SOUTH', 472),
('SIGOT', 473),
('SIGOWET', 474),
('SIGUMERGA', 475),
('SIMAT', 476),
('SIMOTI', 477),
('SIMOTWET', 478),
('SINGORWET', 479),
('SINYERERE', 480),
('SIONGIROI', 481),
('SIPI', 482),
('SIRENDE', 483),
('SIRIA', 484),
('SIRIKWA', 485),
('SIRIMA ', 486),
('SIRKWA', 487),
('SIRNA', 488),
('SIRWA', 489),
('SOGOO', 490),
('SOI', 491),
('SOIN', 492),
('SOLIAT', 493),
('SONGHOR', 494),
('SONGOLYET', 495),
('SORGET', 496),
('SOSIAN', 497),
('SOSIT', 498),
('SOTIK', 499),
('SOTIT', 500),
('SOY', 501),
('SUBUKIA', 502),
('SUGOI', 503),
('SUGUMERKA', 504),
('TABOINO', 505),
('TALAI', 506),
('TAMBUL', 507),
('TAPSAGOI', 508),
('TARAKWA', 509),
('TEBESONIK', 510),
('TECHOGET', 511),
('TEGAT', 512),
('TELANET', 513),
('TEMBELIO', 514),
('TEMBWO', 515),
('TENDEWET', 516),
('TENDWET', 517),
('TENGES', 518),
('TERET', 519),
('TERIK', 520),
('THIGIO', 521),
('TIMBOROA', 522),
('TINDERET', 523),
('TINDIRET', 524),
('TINET', 525),
('TINGWA', 526),
('TORONGO', 527),
('TOWNSHIP', 528),
('TOYOLUK', 529),
('TUGOMOI', 530),
('TUIGOIN', 531),
('TUIYOTICH', 532),
('TULUONGOI', 533),
('TULWET', 534),
('TUMEIYO', 535),
('TURBO', 536),
('TURESIA', 537),
('WALDAI', 538),
('ZIWA', 539);

-- --------------------------------------------------------

-- 
-- Table structure for table `sublocations`
-- 

CREATE TABLE `sublocations` (
  `strSubLocation` varchar(255) default NULL,
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=803 ;

-- 
-- Dumping data for table `sublocations`
-- 

INSERT INTO `sublocations` (`strSubLocation`, `id`) VALUES 
('--- Select Sublocation ---', 1),
('ABOSSI', 2),
('AINABKOI', 3),
('AINABKOI EAST', 4),
('AINAMOI', 5),
('AISAIK', 6),
('ANGATA', 7),
('ARABAL', ,
('ARAMA', 9),
('AREIYET', 10),
('ARIMI', 11),
('ARIYET', 12),
('AROR', 13),
('ARWOS', 14),
('B FOREST', 15),
('BARATON', 16),
('BARSIELE', 17),
('BARTOLIMO', 18),
('BENONIN', 19),
('BESIOBEI', 20),
('BESIOBIOI', 21),
('BINGWA', 22),
('BIRIBIRIET', 23),
('BOITO', 24),
('BOMET CENTRAL', 25),
('BORBORWET', 26),
('BOSTO', 27),
('BUGUR', 28),
('BUITO', 29),
('BUNGUT', 30),
('BURGEI', 31),
('BURGEU', 32),
('CHANGACH', 33),
('CHEBAI', 34),
('CHEBANO', 35),
('CHEBEREB', 36),
('CHEBEREN', 37),
('CHEBILAT', 38),
('CHEBIOK', 39),
('CHEBIOR', 40),
('CHEBOEN', 41),
('CHEBOIN', 42),
('CHEBOISTUIYET', 43),
('CHEBOLE', 44),
('CHEBORGE', 45),
('CHEBORGEI', 46),
('CHEBORI', 47),
('CHEBUNYO', 48),
('CHEBURBUR', 49),
('CHEBWAGAN', 50),
('CHEBWOSTUIYET', 51),
('CHEGILET', 52),
('CHELELACH', 53),
('CHELINGWA', 54),
('CHEMAGEL', 55),
('CHEMALAL', 56),
('CHEMAMIT', 57),
('CHEMAMUL', 58),
('CHEMARE', 59),
('CHEMELET', 60),
('CHEMNOET', 61),
('CHEMOIBEN', 62),
('CHEMOIBON', 63),
('CHEMOIYWA', 64),
('CHEMOSOT', 65),
('CHEMUGUSU', 66),
('CHEMWOROR', 67),
('CHEPAKUNDI', 68),
('CHEPKAIWA', 69),
('CHEPKATET', 70),
('CHEPKECHEY', 71),
('CHEPKEIGEI', 72),
('CHEPKEIKEI', 73),
('CHEPKEMEL', 74),
('CHEPKERGEI', 75),
('CHEPKOCHUN', 76),
('CHEPKOILEL', 77),
('CHEPKOIYO', 78),
('CHEPKOLON', 79),
('CHEPKONG''ONY', 80),
('CHEPKON''Y', 81),
('CHEPKORIO', 82),
('CHEPKOSA', 83),
('CHEPKOSOM', 84),
('CHEPKUI', 85),
('CHEPKULO', 86),
('CHEPKUMIA', 87),
('CHEPKUNY', 88),
('CHEPKURBET', 89),
('CHEPKURGUNG', 90),
('CHEPKURUM', 91),
('CHEPKWONY', 92),
('CHEPLABUS', 93),
('CHEPLAMBUS', 94),
('CHEPLASKEI', 95),
('CHEPLELWO', 96),
('CHEPNGAINA', 97),
('CHEPNGOROR', 98),
('CHEPOLE', 99),
('CHEPSAITA', 100),
('CHEPSEON', 101),
('CHEPSIEON', 102),
('CHEPSIREI', 103),
('CHEPSOEN', 104),
('CHEPSOIRO', 105),
('CHEPTALAL', 106),
('CHEPTARIT', 107),
('CHEPTERIT', 108),
('CHEPTERWAI', 109),
('CHEPTIGIT', 110),
('CHEPTIL', 111),
('CHEPTIRET', 112),
('CHEPTONGEI', 113),
('CHEPTONON', 114),
('CHEPTUECH', 115),
('CHEPTUINGEY', 116),
('CHEPTUNET', 117),
('CHEPTUYET', 118),
('CHEPWOSTUIYET', 119),
('CHEPYAKWAI', 120),
('CHERAGANI NORTH', 121),
('CHERANGANYI', 122),
('CHERIBO', 123),
('CHEROTA', 124),
('CHESETAN', 125),
('CHESINDE', 126),
('CHESINENDE', 127),
('CHESOGOR', 128),
('CHOP', 129),
('CHUIYAT', 130),
('DIKIRIR', 131),
('E/ RAVINE', 132),
('EITUI', 133),
('ELDAMA RAVINE', 134),
('ELGEYO BOADER', 135),
('EMGWEN', 136),
('EMINING', 137),
('EMITYOT', 138),
('EMKWEN', 139),
('ENEGO', 140),
('ENELERAI', 141),
('EQUATOR', 142),
('EWALEL', 143),
('FLAX', 144),
('GELEGELE', 145),
('GETARWET', 146),
('IBOBOR', 147),
('ILPASHIRE', 148),
('IRAA', 149),
('IRONGO', 150),
('ITEMBE', 151),
('ITEN', 152),
('ITIGO', 153),
('ITOIK', 154),
('JAGOROR', 155),
('KABAINGA', 156),
('KABARAK', 157),
('KABARATEGAN', 158),
('KABARNET MOSOP', 159),
('KABARTEGAN', 160),
('KABASIS', 161),
('KABGOMA', 162),
('KABIANGA', 163),
('KABIEMIT', 164),
('KABIMOI', 165),
('KABIRIRSUS', 166),
('KABIRISUS', 167),
('KABISAGA', 168),
('KABISOGE', 169),
('KABITO', 170),
('KABIYEMIT', 171),
('KABIYET', 172),
('KABOI', 173),
('KABOLESERO', 174),
('KABONGO', 175),
('KABOSON', 176),
('KABOYWA', 177),
('KABUNGUT', 178),
('KABURGEI', 179),
('KABUSASER', 180),
('KABUTIE', 181),
('KACHIBORA', 182),
('KAIBOI', 183),
('KAIGAT', 184),
('KAIMOGOL', 185),
('KAIMOGUL', 186),
('KAISAGAT', 187),
('KAITUI', 188),
('KAKAMOR', 189),
('KAKIAMU', 190),
('KALABATA', 191),
('KALYET', 192),
('KAMAEOMON', 193),
('KAMAGIBOI', 194),
('KAMAGUT', 195),
('KAMAILEL', 196),
('KAMAR', 197),
('KAMARICH', 198),
('KAMARINY', 199),
('KAMASAI', 200),
('KAMASENGA', 201),
('KAMELIL', 202),
('KAMELILO', 203),
('KAMOGIBOI', 204),
('KAMOI', 205),
('KAMOIYWA', 206),
('KAMOSON', 207),
('KAMOSOR', 208),
('KAMOYWA', 209),
('KAMUNGEI', 210),
('KAMWOSOR', 211),
('KANUSIN', 212),
('KAP NAROK', 213),
('KAP OLESEROI', 214),
('KAPCHEBELEL', 215),
('KAPCHELAL', 216),
('KAPCHELUCH', 217),
('KAPCHEMOIYWO', 218),
('KAPCHEMUGUN', 219),
('KAPCHEPKENDI', 220),
('KAPCHEPKOR', 221),
('KAPCHEPKORO', 222),
('KAPCHEPTERIT', 223),
('KAPCHEROP', 224),
('KAPCHORUA', 225),
('KAPCHUMBE', 226),
('KAPJIT', 227),
('KAPKAGORON', 228),
('KAPKALIAN', 229),
('KAPKAMO', 230),
('KAPKAOI', 231),
('KAPKATET', 232),
('KAPKEGETUNY', 233),
('KAPKEI', 234),
('KAPKEIN', 235),
('KAPKELEI', 236),
('KAPKENDA', 237),
('KAPKENO', 238),
('KAPKESOSIO', 239),
('KAPKIAI', 240),
('KAPKIAMO', 241),
('KAPKIMOLWA', 242),
('KAPKITONY', 243),
('KAPKITUNY', 244),
('KAPKOE', 245),
('KAPKOI', 246),
('KAPKOI MABONDE', 247),
('KAPKOI SISAL', 248),
('KAPKOIMUR', 249),
('KAPKOIWO', 250),
('KAPKOIYAN', 251),
('KAPKONG', 252),
('KAPKONGA', 253),
('KAPKORIO', 254),
('KAPKOROS', 255),
('KAPKOWO', 256),
('KAPKUGERWET', 257),
('KAPKURESS', 258),
('KAPLAMAI', 259),
('KAPLELACH', 260),
('KAPLELWO', 261),
('KAPLEMOR', 262),
('KAPLIYO', 263),
('KAPLLWO', 264),
('KAPLOMBOI', 265),
('KAPLONG', 266),
('KAPLUTIET', 267),
('KAPMUNERU', 268),
('KAPNAROK', 269),
('KAPNES', 270),
('KAPNGANJO', 271),
('KAPNGETUNY', 272),
('KAPNGORIEM', 273),
('KAPOLESEROI', 274),
('KAPORUSO', 275),
('KAPROGONYA', 276),
('KAPRONYA', 277),
('KAPROPITA', 278),
('KAPRORET', 279),
('KAPRORET/KAMOBO', 280),
('KAPSABUL', 281),
('KAPSANG', 282),
('KAPSANGAR', 283),
('KAPSANGERE', 284),
('KAPSAOS', 285),
('KAPSARET', 286),
('KAPSASIAN', 287),
('KAPSEMWO', 288),
('KAPSENGERE', 289),
('KAPSENGET', 290),
('KAPSENGWET', 291),
('KAPSERNGWET', 292),
('KAPSERTON', 293),
('KAPSERYON', 294),
('KAPSET', 295),
('KAPSIMATWO', 296),
('KAPSIMBEIWO', 297),
('KAPSIMBIRI', 298),
('KAPSIMOTWA', 299),
('KAPSIMOTWO', 300),
('KAPSOGERUK', 301),
('KAPSOGUT', 302),
('KAPSOIT', 303),
('KAPSOIYO', 304),
('KAPSONGAR', 305),
('KAPSOWAR', 306),
('KAPSOYA', 307),
('KAPSUMAI', 308),
('KAPSUNDEI', 309),
('KAPSUSER', 310),
('KAPTAGAT', 311),
('KAPTARAKWA', 312),
('KAPTEBEE', 313),
('KAPTEL', 314),
('KAPTEMWO', 315),
('KAPTENDON', 316),
('KAPTERE', 317),
('KAPTEREN', 318),
('KAPTICH', 319),
('KAPTIEN', 320),
('KAPTILIL', 321),
('KAPTOBOITI', 322),
('KAPT-SOGON', 323),
('KAPTUM', 324),
('KAPTUMO', 325),
('KAPTUMU', 326),
('KAPYEMIT', 327),
('KARAGOINE', 328),
('KASEREM', 329),
('KASISIT', 330),
('KATALEL', 331),
('KATIBEL', 332),
('KATUNOI', 333),
('KEAPTENET', 334),
('KEBENET', 335),
('KEBOLONIK', 336),
('KEBULONIK', 337),
('KEBURO', 338),
('KELJEN', 339),
('KELJI', 340),
('KELUNET', 341),
('KENEGUT', 342),
('KENENE', 343),
('KENYAGORO', 344),
('KENYILEL', 345),
('KERINGET', 346),
('KERITA', 347),
('KEROTET', 348),
('KESENGEI', 349),
('KESOGON', 350),
('KESSES', 351),
('KESSUP', 352),
('KETIGO', 353),
('KETITUI', 354),
('KETURWO', 355),
('KIAMBOGO', 356),
('KIBABET', 357),
('KIBIGONG', 358),
('KIBINGEI', 359),
('KIBOINO', 360),
('KIBOIWA', 361),
('KIBOROKWA', 362),
('KIBOSON', 363),
('KIBUGAT', 364),
('KIBULGENY', 365),
('KIBUSWA', 366),
('KIBWASITWYO', 367),
('KICHURMO', 368),
('KICHUTMOI', 369),
('kilibwoni', 370),
('KILIMA', 371),
('KIMARWANDI', 372),
('KIMAWIT', 373),
('KIMAYA', 374),
('KIMINDA', 375),
('KIMININI', 376),
('KIMNAI', 377),
('KIMNGERU', 378),
('KIMOGOCH', 379),
('KIMOLWE', 380),
('KIMONING', 381),
('KIMORIOT', 382),
('KIMOSE', 383),
('KIMOSO', 384),
('KIMOSON', 385),
('KIMUCHUL', 386),
('KIMUGUL', 387),
('KIMULOT', 388),
('KIMUMU', 389),
('KIMWAWIT', 390),
('KINACH', 391),
('KINYELWET', 392),
('KIOILONGET', 393),
('KIPAJIT', 394),
('KIPCHAMU', 395),
('KIPCHERERE', 396),
('KIPCHILOI', 397),
('KIPCHIMCHIM', 398),
('KIPKAREN SALIENI', 399),
('KIPKEGEI', 400),
('KIPKELJI', 401),
('KIPKERES', 402),
('KIPKERIENY', 403),
('KIPKEWA', 404),
('KIPKITUR', 405),
('KIPKOIYAN', 406),
('KIPKOMBE', 407),
('KIPKONYO', 408),
('KIPKURERE', 409),
('KIPKUROR', 410),
('KIPLELJI', 411),
('KIPLOMBE', 412),
('KIPRERES', 413),
('KIPSAINA', 414),
('KIPSAIYA', 415),
('KIPSAOS', 416),
('KIPSERNGERE', 417),
('KIPSINENDE', 418),
('KIPSINGE', 419),
('KIPSIRICHET', 420),
('KIPSITET', 421),
('KIPSOEN', 422),
('KIPSOGON', 423),
('KIPSOLA', 424),
('KIPSOLU', 425),
('KIPSOMBA', 426),
('KIPSOMBE', 427),
('KIPSOMBOCH', 428),
('KIPSONOI', 429),
('KIPSUTER', 430),
('KIPTABUS', 431),
('KIPTARGON', 432),
('KIPTENDEN', 433),
('KIPTERE', 434),
('KIPTOIM', 435),
('KIPTOIM MUSERECH', 436),
('KIPTOME', 437),
('KIPTORORO', 438),
('KIPTULUS', 439),
('KIPTUNO', 440),
('KIPWASTUIYO', 441),
('KIPYANKEK', 442),
('KIPYAOR', 443),
('KIPYAOS', 444),
('KIPYEBO', 445),
('KIPYOSIT', 446),
('KIPYTENDEN', 447),
('KIRIMWO', 448),
('KISAMOI', 449),
('KISANANA', 450),
('KISAWAI', 451),
('KISINET', 452),
('KISIWE', 453),
('KISONEI', 454),
('KITANY', 455),
('KITOBEN', 456),
('KITUMBEI', 457),
('KOBES', 458),
('KOCHOLUO', 459),
('KOCHOLWO', 460),
('KOIBAN', 461),
('KOIBARAK', 462),
('KOIBEYON', 463),
('KOIGE', 464),
('KOILOT', 465),
('KOILUGET', 466),
('KOIMERET', 467),
('KOIMUR', 468),
('KOISAGAT', 469),
('KOISARA', 470),
('KOITILIAL', 471),
('KOITOROR', 472),
('KOITUGUM', 473),
('KOIYET', 474),
('KOKOKWEONIN', 475),
('KOKWET', 476),
('KOMBASES', 477),
('KOMBE', 478),
('KONGASIS', 479),
('KONGONI', 480),
('KONGOTIK', 481),
('KORIKITONY', 482),
('KORKITONY', 483),
('KORMAET', 484),
('KOROFA', 485),
('KOROTO', 486),
('KOSIRAI', 487),
('KOSOIYWO', 488),
('KUIKUI', 489),
('KUINET', 490),
('KURESOI', 491),
('KURID', 492),
('KUSUMEK', 493),
('KYOGONG', 494),
('LABORET', 495),
('LAINGUSE', 496),
('LALAGIN', 497),
('LAMAON', 498),
('LANGAS', 499),
('LEBALOS', 500),
('LEBEKYET', 501),
('LEBOINET', 502),
('LEBOLOS', 503),
('LEBOSO', 504),
('LEGEBET', 505),
('LELACHTICH', 506),
('LELBOINET', 507),
('LELECHWET', 508),
('LELIAN', 509),
('LELMEN', 510),
('LELMOKWO', 511),
('LEMBUS', 512),
('LEMOK', 513),
('LENGUSEI', 514),
('LENGUT', 515),
('LESERU', 516),
('LESHAR', 517),
('LESHAW', 518),
('LESSOS', 519),
('LITEIEN', 520),
('LITEIN', 521),
('LOLKERINGET', 522),
('LOLKINYET', 523),
('LOLMININGAI', 524),
('LOLTONYOK', 525),
('LOREIN', 526),
('LORIAN', 527),
('LORIEN', 528),
('LORIENI', 529),
('LOTONYOK', 530),
('LUKUGET', 531),
('MABASI', 532),
('MACHINE', 533),
('MAGONOI', 534),
('MAJI TAMU', 535),
('MAKIMENY', 536),
('MAKONDI', 537),
('MARICHO', 538),
('MARMANET', 539),
('MASO', 540),
('MATABO', 541),
('MAU', 542),
('MBOKOINE', 543),
('MBOKOUKEL', 544),
('MBUYU', 545),
('MEGUN', 546),
('MENET', 547),
('MENGWET', 548),
('MEREWET', 549),
('MERIGI', 550),
('MESWO', 551),
('METEITEI', 552),
('METKEI', 553),
('MILLIMANI', 554),
('MINDILILWO', 555),
('MNAGEI', 556),
('MOBEGO', 557),
('MOCHONGOI', 558),
('MOGOIWET', 559),
('MOGOIYWET', 560),
('MOIBEN', 561),
('MOIGUTWO', 562),
('MOIS BRIDGE', 563),
('MOKKWO', 564),
('MOKWO', 565),
('MOLO', 566),
('MOLOI', 567),
('MOLOT', 568),
('MOMONIAT', 569),
('MONYOROR', 570),
('MOROP', 571),
('MOSOMBOR', 572),
('MOSOP', 573),
('MOSORE', 574),
('MOSORIOT', 575),
('MOTERO', 576),
('MOTIGO', 577),
('MOTIRET', 578),
('MOTOBO', 579),
('MOTOSIET', 580),
('MTARAGON', 581),
('MUCHUKWO', 582),
('MUGEN', 583),
('MUGOR', 584),
('MUGUNDOI', 585),
('MUHOTETY', 586),
('MULOT', 587),
('MUMBERES', 588),
('MURUNYI', 589),
('MUSERECHI', 590),
('MUSKUT', 591),
('MUTEI', 592),
('MUTIGO', 593),
('MUTWOT', 594),
('MWEN', 595),
('NAIBERI', 596),
('NAISAMBU', 597),
('NAISAMUT', 598),
('NDALAT', 599),
('NDANAI', 600),
('NDAPTABWA', 601),
('NDUBAI', 602),
('NDUBERNET', 603),
('NDULELE', 604),
('NGAINET', 605),
('NGATA', 606),
('NGECHEK', 607),
('NGENDALEL', 608),
('NGERERIT', 609),
('NGERIA', 610),
('NGESUMIN', 611),
('NGETMOI', 612),
('NGIITO', 613),
('NGORORGA', 614),
('NGUROIN', 615),
('NIWAI', 616),
('NJIPISHIP', 617),
('NOGIRWET', 618),
('NTULELE', 619),
('NYAMBUGO', 620),
('NYARU', 621),
('NYIRA', 622),
('OGILGEI', 623),
('OL DONYOOROK', 624),
('OL JAPETI', 625),
('OLALISI', 626),
('OLALUI', 627),
('OLLESSOS', 628),
('OLMARIKO', 629),
('OLMEKENYU', 630),
('OLOIBORSOITO', 631),
('OLOKYIN', 632),
('OLPUSIMORU', 633),
('OLULMASANI', 634),
('OSORONGAI', 635),
('OTERIT', 636),
('OUTSPAN FARM', 637),
('PARKERA', 638),
('PERKERRA', 639),
('PIONEER', 640),
('PLATEU', 641),
('POIYWEK', 642),
('POROR ARAMA', 643),
('RACESOURSE', 644),
('RADAD', 645),
('RAVINE', 646),
('RIWO', 647),
('ROKOCHOI', 648),
('ROLOGA', 649),
('RONGAI', 650),
('RONGENA', 651),
('RORET', 652),
('ROSAGA', 653),
('ROSOGA', 654),
('ROSONGA', 655),
('RUMBOBSOO', 656),
('RUMURUTI', 657),
('RUNGUT', 658),
('SABATIA', 659),
('SACHOI', 660),
('SAITO', 661),
('SALAMA ', 662),
('SALAWA', 663),
('SAMABUL', 664),
('SAMAK', 665),
('SAMICH', 666),
('SAMOEI', 667),
('SAMUTET', 668),
('SANIAK', 669),
('SAOS', 670),
('SAPTET', 671),
('SARORA', 672),
('SARURA', 673),
('SEGEMIK', 674),
('SEGERO', 675),
('SEGO', 676),
('SEGUT', 677),
('SEGUTON', 678),
('SERETUNIN', 679),
('SERETUT', 680),
('SERGOIT', 681),
('SERGUTON', 682),
('SETANO', 683),
('SHAWA', 684),
('SIABEI', 685),
('SIBIYANI', 686),
('SIBOW', 687),
('SIGILAI', 688),
('SIGOR', 689),
('SIGORIAN', 690),
('SIGORO', 691),
('SIGOT', 692),
('SIGOWET', 693),
('SILIBWET', 694),
('SIMAT', 695),
('SIMOTWET', 696),
('SINENDET', 697),
('SINGORWET', 698),
('SINYERERE', 699),
('SIONGIROI', 700),
('SIOSIOT', 701),
('SIRENDE', 702),
('SIRIKWA', 703),
('SIRKWA', 704),
('SIRON', 705),
('SIRWA', 706),
('SIRWALO', 707),
('SIRWO', 708),
('SISIYA', 709),
('SITATUNGA', 710),
('SOBA', 711),
('SOGON', 712),
('SOGOO', 713),
('SOIMET', 714),
('SOIN', 715),
('SOLIAN', 716),
('SONGICH', 717),
('SONGLIET', 718),
('SONGOLIET', 719),
('SORE', 720),
('SOSANI', 721),
('SOSIAT', 722),
('SOSIOT', 723),
('SOSIT', 724),
('SOSSSIOT', 725),
('SOTIK', 726),
('SOY', 727),
('SUGOI', 728),
('SURUNGAI', 729),
('TABAITA', 730),
('TABOINO', 731),
('TABSAGOI', 732),
('TACHASIS', 733),
('TAIMON', 734),
('TAIWET', 735),
('TALAI', 736),
('TAMBUL', 737),
('TAPKOINO', 738),
('TAR TAR', 739),
('TARAKWA', 740),
('TEBESON', 741),
('TEBESONIK', 742),
('TEBWO', 743),
('TEGANDA', 744),
('TELAND', 745),
('TELAWET', 746),
('TEMBO', 747),
('TEMBOIYWO', 748),
('TEMBWO', 749),
('TEMGES', 750),
('TENDED', 751),
('TENDENEY', 752),
('TENDWET', 753),
('TENDWO', 754),
('TENDWOI', 755),
('TENGESE', 756),
('TEREK', 757),
('TERET', 758),
('TERIK', 759),
('THIGIO', 760),
('THIGO', 761),
('TILALWO', 762),
('TILOL', 763),
('TIMBOROA', 764),
('TINDERET', 765),
('TINET', 766),
('TINGWA', 767),
('TINOMOI', 768),
('TIRIMIONI', 769),
('TIRIMONIN', 770),
('TIRIONG', 771),
('TIRIONY', 772),
('TIRONY', 773),
('TOGUMOI', 774),
('TOLOITA', 775),
('TOMOK', 776),
('TOMOYETTA', 777),
('TONOIK', 778),
('TORONGO', 779),
('TOWNSHIP', 780),
('TOWNSWIP', 781),
('TOYOLUK', 782),
('TUGOMOI', 783),
('TUGON', 784),
('TUGUMOI', 785),
('TUIYOIBEY', 786),
('TUIYOLUK', 787),
('TUIYOTICH', 788),
('TULOI', 789),
('TULUONGOI', 790),
('TULWET', 791),
('TULWOB LEMBUS', 792),
('TUMEIYO', 793),
('TUMOI', 794),
('TUNOITICH', 795),
('TUNYOTICH', 796),
('TURBO', 797),
('TURESIA', 798),
('WEI', 799),
('WEY', 800),
('YEMIT', 801),
('ZIWA', 802);

-- --------------------------------------------------------

-- 
-- Table structure for table `titles`
-- 

CREATE TABLE `titles` (
  `TITLE` varchar(50) NOT NULL,
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- 
-- Dumping data for table `titles`
-- 

INSERT INTO `titles` (`TITLE`, `id`) VALUES 
('--- Select Title ---', 1),
('CHAIRMAN', 2),
('MEMBER', 3),
('PASTOR', 4),
('REV.', 5),
('VIP', 6);

jkkenzie · August 7, 2008

Am giving mysl for a good reason: because my page is totally complicated: It adds a record, delete, displays record, edit record , create options from tables e.t.c

Database Part 3 : STRUCTURE ONLY:

-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Aug 07, 2008 at 04:28 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `emobase`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `members`
-- 

CREATE TABLE `members` (
  `Receipt Number` int(11) default '0',
  `Title` varchar(255) default NULL,
  `First Name` varchar(255) default NULL,
  `Middle Name` varchar(255) default NULL,
  `Last Name` varchar(255) default NULL,
  `Reg Fees` decimal(18,5) default '0.00000',
  `Date Registered` datetime default NULL,
  `ID Number` varchar(255) default NULL,
  `Y O B` varchar(50) default NULL,
  `Home District` varchar(255) default NULL,
  `Telephone` varchar(50) default NULL,
  `Cell Phone` varchar(50) default NULL,
  `Address` varchar(255) default NULL,
  `E-mail` varchar(255) default NULL,
  `Receipt Issued` tinyint(4) default '0',
  `ID` int(11) NOT NULL auto_increment,
  `Gender` varchar(50) default NULL,
  `Occupation` varchar(255) default NULL,
  `Employer` varchar(255) default NULL,
  `Division` varchar(255) default NULL,
  `Location` varchar(255) default NULL,
  `SubLocation` varchar(255) default NULL,
  `Country` varchar(50) default NULL,
  `Country Of Residence` varchar(50) default NULL,
  `Form Of Payment` varchar(50) default NULL,
  `Bank` varchar(50) default NULL,
  `Current Residence` varchar(50) default NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `strIdNumber` (`ID Number`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6176 ;

jkkenzie · August 7, 2008

index.php part 1

<?php session_start();
 if (isset($_GET["order"])) $order = @$_GET["order"];
 if (isset($_GET["type"])) $ordtype = @$_GET["type"];

 if (isset($_POST["filter"])) $filter = @$_POST["filter"];
 if (isset($_POST["filter_field"])) $filterfield = @$_POST["filter_field"];
 $wholeonly = false;
 if (isset($_POST["wholeonly"])) $wholeonly = @$_POST["wholeonly"];

 if (!isset($order) && isset($_SESSION["order"])) $order = $_SESSION["order"];
 if (!isset($ordtype) && isset($_SESSION["type"])) $ordtype = $_SESSION["type"];
 if (!isset($filter) && isset($_SESSION["filter"])) $filter = $_SESSION["filter"];
 if (!isset($filterfield) && isset($_SESSION["filter_field"])) $filterfield = $_SESSION["filter_field"];

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>emobase -- members</title>
<meta name="generator" http-equiv="content-type" content="text/html">
<script type="text/javascript">
<!--

if (document.images)
{
mouseNormalImage = new Image();
mouseNormalImage.src = "save.gif";
}

//-->
</script>

<style type="text/css">
 body {
   background-color: #317676;
   color: #FFFFFF;
   font-family: Arial;
   font-size: 12px;
   background-image : url("");
 }
 .bd {
   background-color: #317676;
   color: #FFFFFF;
   font-family: Arial;
   font-size: 12px;
 }
 .tbl {
   background-color: #276262;
 }
 a:link { 
   color: #FFE760;
   font-family: Arial;
   font-size: 12px;
 }
 a:active { 
   color: #FFFF00;
   font-family: Arial;
   font-size: 12px;
 }
 a:visited { 
   color: #CCCC39;
   font-family: Arial;
   font-size: 12px;
 }
 .hr {
   background-color: #3A9393;
   color: #FFFFFF;
   font-family: Arial;
   font-size: 12px;
 }
 a.hr:link {
   color: #FFFFFF;
   font-family: Arial;
   font-size: 12px;
 }
 a.hr:active {
   color: #FFFFFF;
   font-family: Arial;
   font-size: 12px;
 }
 a.hr:visited {
   color: #FFFFFF;
   font-family: Arial;
   font-size: 12px;
 }
 .dr {
   background-color: #276262;
   color: #FFE760;
   font-family: Arial;
   font-size: 12px;
 }
 .sr {
   background-color: #367800;
   color: #FFE760;
   font-family: Arial;
   font-size: 12px;
 }
</style>
<?php include("ajaxrequest.js"); ?>

</head>
<body>
<table class="bd" width="100%" cellspacing="0" cellpadding="0" border="0"><tr><td class="hr"><img src="../logos/EI.png" alt="EI" width="135" height="115" longdesc="http://www.emoinvestments.com" /></td>
<td class="hr" align="center"><h2>EMO MEMBERS AND SHARES ADMIN</h2></td><td class="hr" align="right"><img src="../logos/ES.png" alt="ES" width="159" height="97" longdesc="http://www.emosociety.org" /></td>
</tr>
</table>
<td style="border:0px;padding:0px;height:18px;" valign="top">
     <iframe src="http://www.nellydata.com/dsl/ticker.asp" frameborder="0" scrolling="no" style="width:100%;height:18px;padding:0px;">Your browser is not iframe enabled. Please upload a higher version.</iframe>
    </td>
<table width="100%">
<tr>

<td width="16%" valign="top">
<li><a href="banks.php?a=reset">banks</a>
<li><a href="countries.php?a=reset">countries</a>
<li><a href="country_of_residence.php?a=reset">country of residence</a>
<li><a href="divisions.php?a=reset">divisions</a>
<li><a href="emo_users.php?a=reset">emo_users</a>
<li><a href="form_of_payment.php?a=reset">form of payment</a>
<li><a href="gender.php?a=reset">gender</a>
<li><a href="home_districts.php?a=reset">home districts</a>
<li><a href="locations.php?a=reset">locations</a>
<li><a href="sublocations.php?a=reset">sublocations</a>
<li><a href="titles.php?a=reset">titles</a>
</td>
<td width="2%"></td>
<td width="0%" bgcolor="#e0e0e0"></td>
<td width="4%"></td>
<td width="78%" valign="top">
<?php
 if (!login()) exit;
?>
<div style="float: right"><a href="index.php?a=logout">[ LOGOUT ]</a></div>
<br>
<?php
 $conn = connect();
 $showrecs = 20;
 $pagerange = 10;

 $a = @$_GET["a"];
 $recid = @$_GET["recid"];
 $page = @$_GET["page"];
 if (!isset($page)) $page = 1;

 $sql = @$_POST["sql"];

 switch ($sql) {
   case "insert":
     sql_insert();
     break;
   case "update":
     sql_update();
     break;
   case "delete":
     sql_delete();
     break;
 }

 switch ($a) {
   case "add":
     addrec();
     break;
   case "view":
     viewrec($recid);
     break;
   case "edit":
     editrec($recid);
     break;
   case "del":
     deleterec($recid);
     break;
   default:
     select();
     break;
 }

 if (isset($order)) $_SESSION["order"] = $order;
 if (isset($ordtype)) $_SESSION["type"] = $ordtype;
 if (isset($filter)) $_SESSION["filter"] = $filter;
 if (isset($filterfield)) $_SESSION["filter_field"] = $filterfield;
 if (isset($wholeonly)) $_SESSION["wholeonly"] = $wholeonly;

 mysql_close($conn);
?>
</td></tr></table>
<table class="bd" width="100%"><tr><td class="hr"><a href="http://www.emosociety.org">Visit EMO Site for current events</a></td></tr></table>
</body>
</html>

<?php function select()
 {
 global $a;
 global $showrecs;
 global $page;
 global $filter;
 global $filterfield;
 global $wholeonly;
 global $order;
 global $ordtype;


 if ($a == "reset") {
   $filter = "";
   $filterfield = "";
   $wholeonly = "";
   $order = "";
   $ordtype = "";
 }

 $checkstr = "";
 if ($wholeonly) $checkstr = " checked";
 if ($ordtype == "asc") { $ordtypestr = "desc"; } else { $ordtypestr = "asc"; }
 $res = sql_select();
 $count = sql_getrecordcount();
 if ($count % $showrecs != 0) {
   $pagecount = intval($count / $showrecs) + 1;
 }
 else {
   $pagecount = intval($count / $showrecs);
 }
 $startrec = $showrecs * ($page - 1);
 if ($startrec < $count) {mysql_data_seek($res, $startrec);}
 $reccount = min($showrecs * $page, $count);
?>
<table class="bd" border="0" cellspacing="1" cellpadding="4">
<tr><td>Table: members</td></tr>
<tr><td>Records shown <?php echo $startrec + 1 ?> - <?php echo $reccount ?> of <?php echo $count ?></td></tr>
</table>
<hr size="1" noshade>
<form action="index.php" method="post">
<table class="bd" border="0" cellspacing="1" cellpadding="4">
<tr>
<td><b>Custom Search</b> </td>
<td><input type="text" name="filter" value="<?php echo $filter ?>"></td>
<td><select name="filter_field">
<option value="">All Fields</option>
<option value="<?php echo "Receipt Number" ?>"<?php if ($filterfield == "Receipt Number") { echo "selected"; } ?>><?php echo htmlspecialchars("Receipt Number") ?></option>
<option value="<?php echo "Title" ?>"<?php if ($filterfield == "Title") { echo "selected"; } ?>><?php echo htmlspecialchars("Title") ?></option>
<option value="<?php echo "First Name" ?>"<?php if ($filterfield == "First Name") { echo "selected"; } ?>><?php echo htmlspecialchars("First Name") ?></option>
<option value="<?php echo "Middle Name" ?>"<?php if ($filterfield == "Middle Name") { echo "selected"; } ?>><?php echo htmlspecialchars("Middle Name") ?></option>
<option value="<?php echo "Last Name" ?>"<?php if ($filterfield == "Last Name") { echo "selected"; } ?>><?php echo htmlspecialchars("Last Name") ?></option>
<option value="<?php echo "Reg Fees" ?>"<?php if ($filterfield == "Reg Fees") { echo "selected"; } ?>><?php echo htmlspecialchars("Reg Fees") ?></option>
<option value="<?php echo "Date Registered" ?>"<?php if ($filterfield == "Date Registered") { echo "selected"; } ?>><?php echo htmlspecialchars("Date Registered") ?></option>
<option value="<?php echo "ID Number" ?>"<?php if ($filterfield == "ID Number") { echo "selected"; } ?>><?php echo htmlspecialchars("ID Number") ?></option>
<option value="<?php echo "Y O B" ?>"<?php if ($filterfield == "Y O B") { echo "selected"; } ?>><?php echo htmlspecialchars("Y O B") ?></option>
<option value="<?php echo "Home District" ?>"<?php if ($filterfield == "Home District") { echo "selected"; } ?>><?php echo htmlspecialchars("Home District") ?></option>
<option value="<?php echo "Telephone" ?>"<?php if ($filterfield == "Telephone") { echo "selected"; } ?>><?php echo htmlspecialchars("Telephone") ?></option>
<option value="<?php echo "Cell Phone" ?>"<?php if ($filterfield == "Cell Phone") { echo "selected"; } ?>><?php echo htmlspecialchars("Cell Phone") ?></option>
<option value="<?php echo "Address" ?>"<?php if ($filterfield == "Address") { echo "selected"; } ?>><?php echo htmlspecialchars("Address") ?></option>
<option value="<?php echo "E-mail" ?>"<?php if ($filterfield == "E-mail") { echo "selected"; } ?>><?php echo htmlspecialchars("E-mail") ?></option>
<option value="<?php echo "Receipt Issued" ?>"<?php if ($filterfield == "Receipt Issued") { echo "selected"; } ?>><?php echo htmlspecialchars("Receipt Issued") ?></option>
<option value="<?php echo "Gender" ?>"<?php if ($filterfield == "Gender") { echo "selected"; } ?>><?php echo htmlspecialchars("Gender") ?></option>
<option value="<?php echo "Occupation" ?>"<?php if ($filterfield == "Occupation") { echo "selected"; } ?>><?php echo htmlspecialchars("Occupation") ?></option>
<option value="<?php echo "Employer" ?>"<?php if ($filterfield == "Employer") { echo "selected"; } ?>><?php echo htmlspecialchars("Employer") ?></option>
<option value="<?php echo "Division" ?>"<?php if ($filterfield == "Division") { echo "selected"; } ?>><?php echo htmlspecialchars("Division") ?></option>
<option value="<?php echo "Location" ?>"<?php if ($filterfield == "Location") { echo "selected"; } ?>><?php echo htmlspecialchars("Location") ?></option>
<option value="<?php echo "SubLocation" ?>"<?php if ($filterfield == "SubLocation") { echo "selected"; } ?>><?php echo htmlspecialchars("SubLocation") ?></option>
<option value="<?php echo "Country" ?>"<?php if ($filterfield == "Country") { echo "selected"; } ?>><?php echo htmlspecialchars("Country") ?></option>
<option value="<?php echo "Country Of Residence" ?>"<?php if ($filterfield == "Country Of Residence") { echo "selected"; } ?>><?php echo htmlspecialchars("Country Of Residence") ?></option>
<option value="<?php echo "Form Of Payment" ?>"<?php if ($filterfield == "Form Of Payment") { echo "selected"; } ?>><?php echo htmlspecialchars("Form Of Payment") ?></option>
<option value="<?php echo "Bank" ?>"<?php if ($filterfield == "Bank") { echo "selected"; } ?>><?php echo htmlspecialchars("Bank") ?></option>
<option value="<?php echo "Current Residence" ?>"<?php if ($filterfield == "Current Residence") { echo "selected"; } ?>><?php echo htmlspecialchars("Current Residence") ?></option>
</select></td>
<td><input type="checkbox" name="wholeonly"<?php echo $checkstr ?>>Whole words only</td>
</td></tr>
<tr>
<td> </td>
<td><input type="submit" name="action" value="Search"></td>
<td><a href="index.php?a=reset">Reset</a></td>
</tr>
</table>
</form>
<hr size="1" noshade>
<?php showpagenav($page, $pagecount); ?>
<br>
<table class="tbl" border="0" cellspacing="1" cellpadding="3"width="100%">
<tr>
<td class="hr"> </td>
<td class="hr"> </td>
<td class="hr"> </td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "Receipt Number" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("Receipt Number") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "Title" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("Title") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "First Name" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("First Name") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "Middle Name" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("Middle Name") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "Last Name" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("Last Name") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "Reg Fees" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("Reg Fees") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "Date Registered" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("Date Registered") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "ID Number" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("ID Number") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "Y O B" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("Y O B") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "Home District" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("Home District") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "Telephone" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("Telephone") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "Cell Phone" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("Cell Phone") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "Address" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("Address") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "E-mail" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("E-mail") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "Receipt Issued" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("Receipt Issued") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "Gender" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("Gender") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "Occupation" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("Occupation") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "Employer" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("Employer") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "Division" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("Division") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "Location" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("Location") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "SubLocation" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("SubLocation") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "Country" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("Country") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "Country Of Residence" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("Country Of Residence") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "Form Of Payment" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("Form Of Payment") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "Bank" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("Bank") ?></a></td>
<td class="hr"><a class="hr" href="index.php?order=<?php echo "Current Residence" ?>&type=<?php echo $ordtypestr ?>"><?php echo htmlspecialchars("Current Residence") ?></a></td>
</tr>
<?php
 for ($i = $startrec; $i < $reccount; $i++)
 {
   $row = mysql_fetch_assoc($res);
   $style = "dr";
   if ($i % 2 != 0) {
     $style = "sr";
   }
?>
<tr>
<td class="<?php echo $style ?>"><a href="index.php?a=view&recid=<?php echo $i ?>">VIEW</a></td>
<td class="<?php echo $style ?>"><a href="index.php?a=edit&recid=<?php echo $i ?>">EDIT</a></td>
<td class="<?php echo $style ?>"><a href="index.php?a=del&recid=<?php echo $i ?>">DELETE</a></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Receipt Number"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Title"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["First Name"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Middle Name"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Last Name"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Reg Fees"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Date Registered"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["ID Number"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Y O B"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Home District"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Telephone"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Cell Phone"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Address"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["E-mail"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Receipt Issued"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Gender"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Occupation"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Employer"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Division"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Location"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["SubLocation"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Country"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Country Of Residence"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Form Of Payment"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Bank"]) ?></td>
<td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["Current Residence"]) ?></td>
</tr>
<?php
 }
 mysql_free_result($res);
?>
</table>
<br>
<?php showpagenav($page, $pagecount); ?>
<?php } ?>

<?php function login()
{
 global $_POST;
 global $_SESSION;

 global $_GET;
 if (isset($_GET["a"]) && ($_GET["a"] == 'logout')) $_SESSION["logged_in"] = false;
 if (!isset($_SESSION["logged_in"])) $_SESSION["logged_in"] = false;
 if (!$_SESSION["logged_in"]) {
   $login = "";
   $password = "";
   if (isset($_POST["login"])) $login = @$_POST["login"];
   if (isset($_POST["password"])) $password = @$_POST["password"];

   if (($login != "") && ($password != "")) {
     $conn = mysql_connect("localhost", "root", "");
     mysql_select_db("emobase");
     $sql = "select `password` from `emo_users` where `username` = '" .$login ."'";
     $res = mysql_query($sql, $conn) or die(mysql_error());
     $row = mysql_fetch_assoc($res) or $row = array(0 => "");;
     if (isset($row)) reset($row);

     if (isset($password) && ($password == trim(current($row)))) {
       $_SESSION["logged_in"] = true;
   }
   else {
?>
<p><b><font color="-1">Sorry, the login/password combination you've entered is invalid</font></b></p>
<?php } } }if (isset($_SESSION["logged_in"]) && (!$_SESSION["logged_in"])) { ?>
<form action="index.php" method="post">
<table class="bd" border="0" cellspacing="1" cellpadding="4">
<br><br><br><br>
<tr>
<td width="40%"></td><td>LOGIN</td>
<td><input type="text" name="login" value="<?php echo $login ?>"></td>
</tr>
<tr>
<td width="40%"></td><td>PASSWORD</td>
<td><input type="password" name="password" value="<?php echo $password ?>"></td>
</tr>
<tr>
<td width="40%"></td><td><input type="submit" name="action" value="LOGIN"></td>
</tr>
</table>
</form>
<?php
 }
 if (!isset($_SESSION["logged_in"])) $_SESSION["logged_in"] = false;
 return $_SESSION["logged_in"];
} ?>

<?php function showrow($row, $recid)
 {
?>
<table class="tbl" border="0" cellspacing="1" cellpadding="3"width="50%">
<tr>
<td class="hr"><?php echo htmlspecialchars("Receipt Number")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["Receipt Number"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Title")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["Title"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("First Name")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["First Name"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Middle Name")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["Middle Name"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Last Name")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["Last Name"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Reg Fees")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["Reg Fees"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Date Registered")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["Date Registered"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("ID Number")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["ID Number"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Y O B")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["Y O B"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Home District")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["Home District"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Telephone")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["Telephone"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Cell Phone")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["Cell Phone"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Address")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["Address"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("E-mail")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["E-mail"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Receipt Issued")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["Receipt Issued"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Gender")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["Gender"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Occupation")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["Occupation"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Employer")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["Employer"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Division")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["Division"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Location")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["Location"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("SubLocation")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["SubLocation"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Country")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["Country"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Country Of Residence")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["Country Of Residence"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Form Of Payment")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["Form Of Payment"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Bank")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["Bank"]) ?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Current Residence")." " ?></td>
<td class="dr"><?php echo htmlspecialchars($row["Current Residence"]) ?></td>
</tr>
</table>
<?php } ?>

<?php function showroweditor($row, $iseditmode)
 {
 global $conn;
 

?>
<table class="tbl" border="0" cellspacing="1" cellpadding="3" width="70%">
<tr> 
<td class="hr"><?php echo htmlspecialchars("Receipt Number")." " ?></td>
<td class="dr"><input type="text" id="Receipt_Number" name="Receipt_Number" tabindex="1" maxlength="255" value="<?php echo str_replace('"', '"', trim($row["Receipt Number"])) ?>"onblur="javascript: MyAjaxRequest('rn','hello.php?ReceiptNumber=','Receipt_Number')"/></td>
	<td id="rn"></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Title")." " ?></td>
<td class="dr">
<?php 

$result2 = mysql_query("SELECT TITLE
FROM titles
ORDER BY TITLE"); 

echo "<select name='Title' id='Title' tabindex='2' onchange='javascript: MyAjaxRequest('tle','hello.php?Title=','Title')'>";
while($nt=mysql_fetch_array($result2)){
echo "<option value='$nt[TITLE]'";
if($nt[TITLE] == $row["Title"]) { echo " selected"; }
echo " >$nt[TITLE]</option>";
}
echo "</select>"; ?>

</td> 
<td id="tle"></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("First Name")." " ?></td>
<td class="dr"><input type="text" name="First_Name" maxlength="255" value="<?php echo str_replace('"', '"', trim($row["First Name"])) ?>"></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Middle Name")." " ?></td>
<td class="dr"><input type="text" name="Middle_Name" maxlength="255" value="<?php echo str_replace('"', '"', trim($row["Middle Name"])) ?>"></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Last Name")." " ?></td>
<td class="dr"><input type="text" name="Last_Name" maxlength="255" value="<?php echo str_replace('"', '"', trim($row["Last Name"])) ?>"></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Reg Fees")." " ?></td>
<td class="dr"><input type="text" name="Reg_Fees" value="<?php echo str_replace('"', '"', trim($row["Reg Fees"])) ?>"></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Date Registered")." " ?></td>
<td class="dr"><input type="text" name="Date_Registered" value="<?php echo str_replace('"', '"', trim($row["Date Registered"])) ?>"></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("ID Number")." " ?></td>
<td class="dr"><input type="text" name="ID_Number" maxlength="255" value="<?php echo str_replace('"', '"', trim($row["ID Number"])) ?>"></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Y O B")." " ?></td>
<td class="dr"><input type="text" name="Y_O_B" maxlength="50" value="<?php echo str_replace('"', '"', trim($row["Y O B"])) ?>"></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Home District")." " ?></td>
<td class="dr">
<?php 

$result2 = mysql_query("SELECT DISTINCT strHomeDistrict
FROM `home districts` 
ORDER BY strHomeDistrict"); 

echo "<select name='Home District'>";
while($nt=mysql_fetch_array($result2)){
echo "<option  value='$nt[strHomeDistrict]'";
if($nt[strHomeDistrict] == $row["Home District"]) { echo " selected"; }
echo ">$nt[strHomeDistrict]</option>";
}
echo "</select>";
?>
</td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Telephone")." " ?></td>
<td class="dr"><input type="text" name="Telephone" maxlength="50" value="<?php echo str_replace('"', '"', trim($row["Telephone"])) ?>"></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Cell Phone")." " ?></td>
<td class="dr"><input type="text" name="Cell_Phone" maxlength="50" value="<?php echo str_replace('"', '"', trim($row["Cell Phone"])) ?>"></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Address")." " ?></td>
<td class="dr"><textarea cols="35" rows="4" name="Address" maxlength="255"><?php echo str_replace('"', '"', trim($row["Address"])) ?></textarea></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("E-mail")." " ?></td>
<td class="dr"><input type="text" name="E-mail" maxlength="255" value="<?php echo str_replace('"', '"', trim($row["E-mail"])) ?>"></td>
</tr>

jkkenzie · August 7, 2008

index.php part 2 end:

<tr>
<td class="hr"><?php echo htmlspecialchars("Receipt Issued")." " ?></td>
<td class="dr"><input type="checkbox" name="Receipt_Issued"/></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Gender")." " ?></td>
<td class="dr">
<?php 

$result2 = mysql_query("SELECT SEX
FROM gender
ORDER BY SEX"); 

echo "<select name='Gender'>";
while($nt=mysql_fetch_array($result2)){
echo "<option value='$nt[sEX]'";
if($nt[sEX] == $row["Gender"]) { echo " selected"; }
echo ">$nt[sEX]</option>";
}
echo "</select>";
?>
</td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Occupation")." " ?></td>
<td class="dr"><?php

$result2 = mysql_query("SELECT DISTINCT Occupation
FROM members
ORDER BY Occupation"); 

echo "<select name='Occupation'>";
while($nt=mysql_fetch_array($result2)){
echo "<option value='$nt[Occupation]'";
if($nt[Occupation] == $row["Occupation"]) { echo " selected"; }
echo ">$nt[Occupation]</option>";
}
echo "</select>";
?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Employer")." " ?></td>
<td class="dr"><textarea cols="35" rows="4" name="Employer" maxlength="255"><?php echo str_replace('"', '"', trim($row["Employer"])) ?></textarea></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Division")." " ?></td>
<td class="dr"><?php 

$result2 = mysql_query("SELECT DISTINCT strDivision
FROM divisions  
ORDER BY strDivision"); 

echo "<select name='Division'>";
while($nt=mysql_fetch_array($result2)){
echo "<option value='$nt[strDivision]'";
if($nt[strDivision] == $row['Division']) { echo " selected"; }
echo ">$nt[strDivision]</option>";
}

echo "</select>";
?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Location")." " ?></td>
<td class="dr"><?php 

$result2 = mysql_query("SELECT DISTINCT strLocation
FROM locations  
ORDER BY strLocation"); 

echo "<select name='Location'>";
while($nt=mysql_fetch_array($result2)){
echo "<option value='$nt[strLocation]'";
if($nt[strLocation] == $row['Location']) { echo " selected"; }
echo ">$nt[strLocation]</option>";
}
echo "</select>";
?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("SubLocation")." " ?></td>
<td class="dr"><?php 

$result2 = mysql_query("SELECT DISTINCT strSubLocation
FROM sublocations  
ORDER BY strSubLocation"); 

echo "<select name='SubLocation'>";
while($nt=mysql_fetch_array($result2)){
echo "<option value='$nt[strSubLocation]'";
if($nt[strSubLocation] == $row['SubLocation']) { echo " selected"; }
echo ">$nt[strSubLocation]</option>";
}
echo "</select>";
?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Country")." " ?></td>
<td class="dr"><?php 

$result2 = mysql_query("SELECT DISTINCT strCountry
FROM countries  
ORDER BY strCountry"); 

echo "<select name='Country'>";
while($nt=mysql_fetch_array($result2)){
echo "<option value='$nt[strCountry]'";
if($nt[strCountry] == $row['Country']) { echo " selected"; }
echo ">$nt[strCountry]</option>";
}
echo "</select>";
?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Country Of Residence")." " ?></td>
<td class="dr"><?php 

$result2 = mysql_query("SELECT DISTINCT strCountryOfResidence
FROM `country of residence`  
ORDER BY strCountryOfResidence"); 

echo "<select name='Country Of Residence'>";
while($nt=mysql_fetch_array($result2)){
echo "<option value='$nt[strCountryOfResidence]'";
if($nt[strCountryOfResidence] == $row['Country Of Residence']) { echo " selected"; }
echo ">$nt[strCountryOfResidence]</option>";
}
echo "</select>";
?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Form Of Payment")." " ?></td>
<td class="dr"><?php 

$result2 = mysql_query("SELECT DISTINCT strFormOfPayments
FROM `form of payment`  
ORDER BY strFormOfPayments"); 

echo "<select name='Form Of Payment'>";
while($nt=mysql_fetch_array($result2)){
echo "<option value='$nt[strFormOfPayments]'";
if($nt[strFormOfPayments] == $row['Form Of Payment']) { echo " selected"; }
echo ">$nt[strFormOfPayments]</option>";
}
echo "</select>";
?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Bank")." " ?></td>
<td class="dr"><?php 

$result2 = mysql_query("SELECT DISTINCT strBanks
FROM `banks`  
ORDER BY strBanks"); 

echo "<select name='Bank'>";
while($nt=mysql_fetch_array($result2)){
echo "<option value='$nt[strBanks]'";
if($nt[strBanks] == $row['Bank']) { echo " selected"; }
echo ">$nt[strBanks]</option>";
}
echo "</select>";
?></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("Current Residence")." " ?></td>
<td class="dr"><?php 

$result2 = mysql_query("SELECT DISTINCT res
FROM `current residence`  
ORDER BY res"); 

echo "<select name='Current Residence'>";
while($nt=mysql_fetch_array($result2)){
echo "<option value='$nt[res]'";
if($nt[res] == $row['Current Residence']) { echo " selected"; }
echo ">$nt[res]</option>";
}
echo "</select>";
?></td>
</tr>
</table>
<?php } ?>

<?php function showpagenav($page, $pagecount)
{
?>
<table class="bd" border="0" cellspacing="1" cellpadding="4">
<tr>
<td><a href="index.php?a=add">ADD</a> </td>
<?php if ($page > 1) { ?>
<td><a href="index.php?page=<?php echo $page - 1 ?>"><< PREVIOUS</a> </td>
<?php } ?>
<?php
  global $pagerange;

  if ($pagecount > 1) {

  if ($pagecount % $pagerange != 0) {
    $rangecount = intval($pagecount / $pagerange) + 1;
  }
  else {
    $rangecount = intval($pagecount / $pagerange);
  }
  for ($i = 1; $i < $rangecount + 1; $i++) {
    $startpage = (($i - 1) * $pagerange) + 1;
    $count = min($i * $pagerange, $pagecount);

    if ((($page >= $startpage) && ($page <= ($i * $pagerange)))) {
      for ($j = $startpage; $j < $count + 1; $j++) {
        if ($j == $page) {
?>
<td><b><?php echo $j ?></b></td>
<?php } else { ?>
<td><a href="index.php?page=<?php echo $j ?>"><?php echo $j ?></a></td>
<?php } } } else { ?>
<td><a href="index.php?page=<?php echo $startpage ?>"><?php echo $startpage ."..." .$count ?></a></td>
<?php } } } ?>
<?php if ($page < $pagecount) { ?>
<td> <a href="index.php?page=<?php echo $page + 1 ?>">NEXT >></a> </td>
<?php } ?>
</tr>
</table>
<?php } ?>

<?php function showrecnav($a, $recid, $count)
{
?>
<table class="bd" border="0" cellspacing="1" cellpadding="4">
<tr>
<td><a href="index.php">HOME</a></td>
<?php if ($recid > 0) { ?>
<td><a href="index.php?a=<?php echo $a ?>&recid=<?php echo $recid - 1 ?>">PREVIOUS</a></td>
<?php } if ($recid < $count - 1) { ?>
<td><a href="index.php?a=<?php echo $a ?>&recid=<?php echo $recid + 1 ?>">NEXT</a></td>
<?php } ?>
</tr>
</table>
<hr size="1" noshade>
<?php } ?>

<?php function addrec()
{
?>
<table class="bd" border="0" cellspacing="1" cellpadding="4">
<tr>
<td><a href="index.php">HOME</a></td>
</tr>
</table>
<hr size="1" noshade>
<div id="main" style="color:#FF9900; font-size:20px;"> <!-- all results appears dynamic within the div like right here --> </div>
<form enctype="multipart/form-data" action="index.php" name="INSUP" id="INSUP" method="post">
<p><input type="hidden" name="sql" value="insert"></p>
<?php
$row = array(

  "Receipt Number" =>"", 
  "Title" => "",
  "First Name" => "",
  "Middle Name" => "",
  "Last Name" => "",
  "Reg Fees" => "",
  "Date Registered" => "",
  "ID Number" => "",
  "Y O B" => "",
  "Home District" => "",
  "Telephone" => "",
  "Cell Phone" => "",
  "Address" => "",
  "E-mail" => "",
  "Receipt Issued" => "",
  "ID" => "",
  "Gender" => "",
  "Occupation" => "",
  "Employer" => "",
  "Division" => "",
  "Location" => "",
  "SubLocation" => "",
  "Country" => "",
  "Country Of Residence" => "",
  "Form Of Payment" => "",
  "Bank" => "",
  "Current Residence" => "");
showroweditor($row, false);
?>
<p><input  type="image" width="90" height="40" name="action" alt="" src="save.gif" onMouseOut="this.src='save.gif'"></p>

</form>
<?php } ?>

<?php function viewrec($recid)
{
  $res = sql_select();
  $count = sql_getrecordcount();
  mysql_data_seek($res, $recid);
  $row = mysql_fetch_assoc($res);
  showrecnav("view", $recid, $count);
?>
<br>
<?php showrow($row, $recid) ?>
<br>
<hr size="1" noshade>
<table class="bd" border="0" cellspacing="1" cellpadding="4">
<tr>
<td><a href="index.php?a=add">ADD</a></td>
<td><a href="index.php?a=edit&recid=<?php echo $recid ?>">EDIT</a></td>
<td><a href="index.php?a=del&recid=<?php echo $recid ?>">DELETE</a></td>
</tr>
</table>
<?php
  mysql_free_result($res);
} ?>

<?php function editrec($recid)
{
  $res = sql_select();
  $count = sql_getrecordcount();
  mysql_data_seek($res, $recid);
  $row = mysql_fetch_assoc($res);
  showrecnav("edit", $recid, $count);
?>
<div id="main"> <!-- all results appears dynamic within the div like right here --> </div>
<br>
<form enctype="multipart/form-data" action="index.php" name="insertupdate" method="post" onSubmit="return validate(this);">
<input type="hidden" name="sql" value="update">
<input type="hidden" name="xID" value="<?php echo $row["ID"] ?>">
<?php showroweditor($row, true); ?>
<p><input type="image" width="90" height="40" name="action" alt="" src="save.gif" onMouseOut="this.src='save.gif'" onClick="return validate();"></p>
</form>
<?php
  mysql_free_result($res);
} ?>

<?php function deleterec($recid)
{
  $res = sql_select();
  $count = sql_getrecordcount();
  mysql_data_seek($res, $recid);
  $row = mysql_fetch_assoc($res);
  showrecnav("del", $recid, $count);
?>
<br>
<form action="index.php" method="post">
<input type="hidden" name="sql" value="delete">
<input type="hidden" name="xID" value="<?php echo $row["ID"] ?>">
<?php showrow($row, $recid) ?>
<?php echo "<br><font color='#CC0000'><b>Once deleted would not be recovered</b></font>";?>
<p><input type="submit" name="action" value="CONFIRM"></p>
</form>
<?php
  mysql_free_result($res);
} ?>

<?php function connect()
{
  $conn = mysql_connect("localhost", "root", "");
  mysql_select_db("emobase");
  return $conn;
}

function sqlvalue($val, $quote)
{
  if ($quote)
    $tmp = sqlstr($val);
  else
    $tmp = $val;
  if ($tmp == "")
    $tmp = "NULL";
  elseif ($quote)
    $tmp = "'".$tmp."'";
  return $tmp;
}

function sqlstr($val)
{
  return str_replace("'", "''", $val);
}

function sql_select()
{
  global $conn;
  global $order;
  global $ordtype;
  global $filter;
  global $filterfield;
  global $wholeonly;

  $filterstr = sqlstr($filter);
  if (!$wholeonly && isset($wholeonly) && $filterstr!='') $filterstr = "%" .$filterstr ."%";
  $sql = "SELECT `Receipt Number`, `Title`, `First Name`, `Middle Name`, `Last Name`, `Reg Fees`, `Date Registered`, `ID Number`, `Y O B`, `Home District`, `Telephone`, `Cell Phone`, `Address`, `E-mail`, `Receipt Issued`, ID, `Gender`, `Occupation`, `Employer`, `Division`, `Location`, `SubLocation`, `Country`, `Country Of Residence`, `Form Of Payment`, `Bank`, `Current Residence` FROM `members`";
  if (isset($filterstr) && $filterstr!='' && isset($filterfield) && $filterfield!='') {
    $sql .= " where `" .sqlstr($filterfield) ."` like '" .$filterstr ."'";
  } elseif (isset($filterstr) && $filterstr!='') {
    $sql .= " where (`Receipt Number` like '" .$filterstr ."') or (`Title` like '" .$filterstr ."') or (`First Name` like '" .$filterstr ."') or (`Middle Name` like '" .$filterstr ."') or (`Last Name` like '" .$filterstr ."') or (`Reg Fees` like '" .$filterstr ."') or (`Date Registered` like '" .$filterstr ."') or (`ID Number` like '" .$filterstr ."') or (`Y O B` like '" .$filterstr ."') or (`Home District` like '" .$filterstr ."') or (`Telephone` like '" .$filterstr ."') or (`Cell Phone` like '" .$filterstr ."') or (`Address` like '" .$filterstr ."') or (`E-mail` like '" .$filterstr ."') or (`Receipt Issued` like '" .$filterstr ."') or (`Gender` like '" .$filterstr ."') or (`Occupation` like '" .$filterstr ."') or (`Employer` like '" .$filterstr ."') or (`Division` like '" .$filterstr ."') or (`Location` like '" .$filterstr ."') or (`SubLocation` like '" .$filterstr ."') or (`Country` like '" .$filterstr ."') or (`Country Of Residence` like '" .$filterstr ."') or (`Form Of Payment` like '" .$filterstr ."') or (`Bank` like '" .$filterstr ."') or (`Current Residence` like '" .$filterstr ."')";
  }
  if (isset($order) && $order!='') $sql .= " order by `" .sqlstr($order) ."`";
  if (isset($ordtype) && $ordtype!='') $sql .= " " .sqlstr($ordtype);
  $res = mysql_query($sql, $conn) or die(mysql_error());
  return $res;
}

function sql_getrecordcount()
{
  global $conn;
  global $order;
  global $ordtype;
  global $filter;
  global $filterfield;
  global $wholeonly;

  $filterstr = sqlstr($filter);
  if (!$wholeonly && isset($wholeonly) && $filterstr!='') $filterstr = "%" .$filterstr ."%";
  $sql = "SELECT COUNT(*) FROM `members`";
  if (isset($filterstr) && $filterstr!='' && isset($filterfield) && $filterfield!='') {
    $sql .= " where `" .sqlstr($filterfield) ."` like '" .$filterstr ."'";
  } elseif (isset($filterstr) && $filterstr!='') {
    $sql .= " where (`Receipt Number` like '" .$filterstr ."') or (`Title` like '" .$filterstr ."') or (`First Name` like '" .$filterstr ."') or (`Middle Name` like '" .$filterstr ."') or (`Last Name` like '" .$filterstr ."') or (`Reg Fees` like '" .$filterstr ."') or (`Date Registered` like '" .$filterstr ."') or (`ID Number` like '" .$filterstr ."') or (`Y O B` like '" .$filterstr ."') or (`Home District` like '" .$filterstr ."') or (`Telephone` like '" .$filterstr ."') or (`Cell Phone` like '" .$filterstr ."') or (`Address` like '" .$filterstr ."') or (`E-mail` like '" .$filterstr ."') or (`Receipt Issued` like '" .$filterstr ."') or (`Gender` like '" .$filterstr ."') or (`Occupation` like '" .$filterstr ."') or (`Employer` like '" .$filterstr ."') or (`Division` like '" .$filterstr ."') or (`Location` like '" .$filterstr ."') or (`SubLocation` like '" .$filterstr ."') or (`Country` like '" .$filterstr ."') or (`Country Of Residence` like '" .$filterstr ."') or (`Form Of Payment` like '" .$filterstr ."') or (`Bank` like '" .$filterstr ."') or (`Current Residence` like '" .$filterstr ."')";
  }
  $res = mysql_query($sql, $conn) or die(mysql_error());
  $row = mysql_fetch_assoc($res);
  reset($row);
  return current($row);
}

function sql_insert()
{
  global $conn;
  global $_POST;

  $sql = "insert into `members` (`Receipt Number`, `Title`, `First Name`, `Middle Name`, `Last Name`, `Reg Fees`, `Date Registered`, `ID Number`, `Y O B`, `Home District`, `Telephone`, `Cell Phone`, `Address`, `E-mail`, `Receipt Issued`, `Gender`, `Occupation`, `Employer`, `Division`, `Location`, `SubLocation`, `Country`, `Country Of Residence`, `Form Of Payment`, `Bank`, `Current Residence`) values (" .sqlvalue(@$_POST["Receipt_Number"], false).", " .sqlvalue(@$_POST["Title"], true).", " .sqlvalue(@$_POST["First_Name"], true).", " .sqlvalue(@$_POST["Middle_Name"], true).", " .sqlvalue(@$_POST["Last_Name"], true).", " .sqlvalue(@$_POST["Reg_Fees"], false).", " .sqlvalue(@$_POST["Date_Registered"], true).", " .sqlvalue(@$_POST["ID_Number"], true).", " .sqlvalue(@$_POST["Y_O_B"], true).", " .sqlvalue(@$_POST["Home_District"], true).", " .sqlvalue(@$_POST["Telephone"], true).", " .sqlvalue(@$_POST["Cell_Phone"], true).", " .sqlvalue(@$_POST["Address"], true).", " .sqlvalue(@$_POST["E-mail"], true).", " .sqlvalue(@$_POST["Receipt_Issued"], false).", " .sqlvalue(@$_POST["Gender"], true).", " .sqlvalue(@$_POST["Occupation"], true).", " .sqlvalue(@$_POST["Employer"], true).", " .sqlvalue(@$_POST["Division"], true).", " .sqlvalue(@$_POST["Location"], true).", " .sqlvalue(@$_POST["SubLocation"], true).", " .sqlvalue(@$_POST["Country"], true).", " .sqlvalue(@$_POST["Country_Of_Residence"], true).", " .sqlvalue(@$_POST["Form_Of_Payment"], true).", " .sqlvalue(@$_POST["Bank"], true).", " .sqlvalue(@$_POST["Current_Residence"], true).")";
  mysql_query($sql, $conn) or die(mysql_error());

}

function sql_update()
{
  global $conn;
  global $_POST;

  $sql = "update `members` set `Receipt Number`=" .sqlvalue(@$_POST["Receipt_Number"], false).", `Title`=" .sqlvalue(@$_POST["Title"], true).", `First Name`=" .sqlvalue(@$_POST["First_Name"], true).", `Middle Name`=" .sqlvalue(@$_POST["Middle_Name"], true).", `Last Name`=" .sqlvalue(@$_POST["Last_Name"], true).", `Reg Fees`=" .sqlvalue(@$_POST["Reg_Fees"], false).", `Date Registered`=" .sqlvalue(@$_POST["Date_Registered"], true).", `ID Number`=" .sqlvalue(@$_POST["ID_Number"], true).", `Y O B`=" .sqlvalue(@$_POST["Y_O_B"], true).", `Home District`=" .sqlvalue(@$_POST["Home_District"], true).", `Telephone`=" .sqlvalue(@$_POST["Telephone"], true).", `Cell Phone`=" .sqlvalue(@$_POST["Cell_Phone"], true).", `Address`=" .sqlvalue(@$_POST["Address"], true).", `E-mail`=" .sqlvalue(@$_POST["E-mail"], true).", `Receipt Issued`=" .sqlvalue(@$_POST["Receipt_Issued"], false).", `Gender`=" .sqlvalue(@$_POST["Gender"], true).", `Occupation`=" .sqlvalue(@$_POST["Occupation"], true).", `Employer`=" .sqlvalue(@$_POST["Employer"], true).", `Division`=" .sqlvalue(@$_POST["Division"], true).", `Location`=" .sqlvalue(@$_POST["Location"], true).", `SubLocation`=" .sqlvalue(@$_POST["SubLocation"], true).", `Country`=" .sqlvalue(@$_POST["Country"], true).", `Country Of Residence`=" .sqlvalue(@$_POST["Country_Of_Residence"], true).", `Form Of Payment`=" .sqlvalue(@$_POST["Form_Of_Payment"], true).", `Bank`=" .sqlvalue(@$_POST["Bank"], true).", `Current Residence`=" .sqlvalue(@$_POST["Current_Residence"], true) ." where " .primarykeycondition();
  mysql_query($sql, $conn) or die(mysql_error());
}

function sql_delete()
{
  global $conn;

  $sql = "delete from `members` where " .primarykeycondition();
  mysql_query($sql, $conn) or die(mysql_error());
}

function primarykeycondition()
{
  global $_POST;
  $pk = "";
  $pk .= "(ID";
  if (@$_POST["xID"] == "") {
    $pk .= " IS NULL";
  }else{
  $pk .= " = " .sqlvalue(@$_POST["xID"], false);
  };
  $pk .= ")";
  return $pk;
}
?>
</body>
</html>

Sign In

Back to previous page

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information