231 Front Street, Lahaina, HI 96761 info@givingpress.com 808.123.4567

The 10 Best Resources For Products

A Guide To Get The Best E-Cigarette Products

Since the use of cigars are known to have cancer-causing effects the modern Industry have invented a way to provide an alternative cigarette to people who are chain smokers to avoid these kinds of illnesses and this is the so-called electronics cigarettes. With the creation of the modern electronic cigarette a healthy option is provided to people who are smoking so that they can avoid illnesses but still enjoy their cigarette smoking habit. Aside from that these electronic cigarettes are known to have an effect of unbinding the smokers from their constant smoking habits which can be utilized as a means to quit smoking.
Obtaining an e-cigarette is very easy since there are a lot of online e-cig shop that offers high-quality e-cigarettes including the e-juices that they use.

Due to the dedicated effort in the research and development of electronic cigarette more and more people are finding this helpful innovation ask an appealing product to use not only because it helps smoker avoid the risk associated with smoking but it is also a user-friendly product that anyone could use easily. Electronic cigars small in size preferably about 10 millimeter in size which made it a very conventional product to use.

After shifting from smoking traditional cigarettes to electronic cigarette, a smoker will immediately feel the effects of electronic cigarettes which is lessening the cravings of a smoker from smoking the conventional tobacco due to the fact that electronic cigarettes contains less harmful chemicals especially the addictive substances that is contained in the traditional tobacco which makes smoker crave more tobacco.
Why Shops Aren’t As Bad As You Think

Electronic cigarettes really are very helpful in helping smokers avoid the health risk brought about by the traditional tobacco that they smoke and maintain their healthy state despite smoking. There is a wide range of reliable e-cig shops online that you can certainly find an electronic cigarette easily if you are looking for one including juices and a liquid that comes in a variety of flavors.
Smart Ideas: Liquids Revisited

Electronic cigarettes have many different parts in order to give the user a real feel of smoking, the cigarette is composed of a battery and an atomizer as well as a nicotine chamber all in one compartment which the smoker is made to hold for the vapor to be generated by the electronic cigarette and this also comes with a red LED light to resemble the real cigarette burning. There are several different cartridges that can be used in the nicotine chamber of an electronic cigarette and these cartridges vary in strength so that the user will be able to choose which liquid instead he is comfortable with us to recreate and simulate the traditional cigarette smoking. These are only few of the convenience and benefits that an electronic cigarette will provide to you.

Looking On The Bright Side of Options

Choosing the Best Home Products

An appliance is considered the best machine in the house if it saves and time for the homeowner. We need these machineries in our home. Consider the appliances’ usage in the household and see if it improves your quality of life.

The microwave is the appliance that is considered as the best invention for the home today. The microwave has made cooking and reheating of foods very efficient. A microwave is one of the most important things that parents would pack and put in the car of their children who are going away for college. Having and enjoying a delicious hot meal will be assured to those who reads with the use of the microwave.

Considered as another best appliance in the home is the refrigerator. Refrigerators are being reinvented and improved since the invention. The refrigerator is one appliance in our home that is always running and storing our perishable food. New refrigerators have advanced features like they have freezers, ice makers that are automatic, and water purifier. Almost all households today have a refrigerator.
The 10 Commandments of Sales And How Learn More

Any home would be happy to have a sewing machine. Clothes, drapes and other clothing materials need mending from time to time. If we mend these materials ourselves, our time and money are saved instead of buying new ones. The new sewing machines make repairs to a precision and so we save on time. The sewing machines could be an old invention but it has still its importance to households of today.
The Ultimate Guide to Sales

Other home products also give our household comfort. Our busy lives are made easier with other home kitchen products like ovens, dishwashers and dryers, toasters, etc. Let us not forget our vacuum cleaners that make our cleaning in our rooms easier and faster.

Our home products are made to make our household activities easier and efficient. Our chores will not be easy if we do not have these various appliances at home. Without these home products, we cannot do a simultaneous job of doing other works in the house.
Good appliance producers are manufacturing our home products from all over the globe. The improvement of these appliances are always the aim of these international brands in order to make our household chores more efficient. The internet or retails stores are places where you can buy these international brands. It is advisable that you review first if you need to buy an new appliance with its new gadgets.. Meaning, if you are into baking cakes, then buy an oven and a blender, and do not be tempted t buy other machines not needed in baking.

locating a fence firm is often the most effective understanding you might have making use of your property.

Receiving a kennel area generally is a satisfying knowledge. Look through Engines like google, use the proper group, and negotiate back and relax. If you are in the requirement of wall and you also are in the Schererville region then you might like to check out the wright fencing enterprise. The Wright Fencing Company could have that you simply run area developed without delay in any way. Pet owners are fantastic folks with many of the most good quality perform you may picture.

You may be obtaining a Faux solid wood, series website link, wood, or material wall does not matter. The Wright Fence Business has encounter with every design. Should you prefer a Schererville fence company In, then you definately should then click on this link. You will end up lead around the most reliable business that one could see in the North west Downtown indiana location to get the most notable offer over a kennel area that you are able to depend for years to come.

Require a Schererville fence company is surely an straightforward task that usually takes no brain in any respect. Select your wall membrane sort and continue with your choice. The calculate will likely be specific and sensible and you will probably purchase your wall structure installed in a few days not a few months. So listen to me from prior expertise you’ll be able to go incorrect after you hire The Wright Wall Firm currently.

GeoDataSource World Cities Database Gold Edition MYSQL CODE TO LOAD DATA

My own reference for future . Need to write the code like below , if not file not found.

LOAD DATA LOCAL
INFILE 'C:\\Program Files (x86)\\EasyPHP-DevServer-14.1VC11\\binaries\\mysql\\bin\\GEODATASOURCE-CITIES-GOLD.TXT'

— Create table “world_cities_gold”
CREATE TABLE `world_cities_gold`(
`region_code` INT,
`sub_region_code` VARCHAR(2),
`ufi` INT,
`uni` INT,
`dsg` CHAR(5),
`cc_fips` VARCHAR(2),
`cc_iso` VARCHAR(2),
`full_name` VARCHAR(200),
`full_name_nd` VARCHAR(200),
`sort_name` VARCHAR(200),
`adm1_code` VARCHAR(3),
`adm1_full_name` VARCHAR(200),
`adm2_code` VARCHAR(3),
`adm2_full_name` VARCHAR(200),
`latitude` FLOAT,
`longitude` FLOAT,
INDEX `idx_region_code` (`region_code`),
INDEX `idx_sub_region_code` (`sub_region_code`),
INDEX `idx_region` (`region_code`,`sub_region_code`),
INDEX `idx_cc_iso` (`cc_iso`),
INDEX `idx_dsg` (`dsg`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

— Load data into table
LOAD DATA LOCAL
INFILE 'C:\\Program Files (x86)\\EasyPHP-DevServer-14.1VC11\\binaries\\mysql\\bin\\GEODATASOURCE-CITIES-GOLD.TXT'
INTO TABLE `world_cities_gold`
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES;

— Create table “country”
CREATE TABLE `country`(
`cc_fips` VARCHAR(2),
`cc_iso` VARCHAR(2),
`tld` VARCHAR(3),
`country_name` VARCHAR(100),
INDEX `idx_cc_fips`(`cc_fips`),
INDEX `idx_cc_iso`(`cc_iso`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

— Insert country data
INSERT INTO `country` VALUES
('AA', 'AW', '.aw', 'Aruba'),
('AC', 'AG', '.ag', 'Antigua and Barbuda'),
('AE', 'AE', '.ae', 'United Arab Emirates'),
('AF', 'AF', '.af', 'Afghanistan'),
('AG', 'DZ', '.dz', 'Algeria'),
('AJ', 'AZ', '.az', 'Azerbaijan'),
('AL', 'AL', '.al', 'Albania'),
('AM', 'AM', '.am', 'Armenia'),
('AN', 'AD', '.ad', 'Andorra'),
('AO', 'AO', '.ao', 'Angola'),
('AQ', 'AS', '.as', 'American Samoa'),
('AR', 'AR', '.ar', 'Argentina'),
('AS', 'AU', '.au', 'Australia'),
('AT', '-', '-', 'Ashmore and Cartier Islands'),
('AU', 'AT', '.at', 'Austria'),
('AV', 'AI', '.ai', 'Anguilla'),
('AX', 'AX', '.ax', 'Åland Islands'),
('AY', 'AQ', '.aq', 'Antarctica'),
('BA', 'BH', '.bh', 'Bahrain'),
('BB', 'BB', '.bb', 'Barbados'),
('BC', 'BW', '.bw', 'Botswana'),
('BD', 'BM', '.bm', 'Bermuda'),
('BE', 'BE', '.be', 'Belgium'),
('BF', 'BS', '.bs', 'Bahamas, The'),
('BG', 'BD', '.bd', 'Bangladesh'),
('BH', 'BZ', '.bz', 'Belize'),
('BK', 'BA', '.ba', 'Bosnia and Herzegovina'),
('BL', 'BO', '.bo', 'Bolivia'),
('BM', 'MM', '.mm', 'Myanmar'),
('BN', 'BJ', '.bj', 'Benin'),
('BO', 'BY', '.by', 'Belarus'),
('BP', 'SB', '.sb', 'Solomon Islands'),
('BQ', '-', '-', 'Navassa Island'),
('BR', 'BR', '.br', 'Brazil'),
('BS', '-', '-', 'Bassas da India'),
('BT', 'BT', '.bt', 'Bhutan'),
('BU', 'BG', '.bg', 'Bulgaria'),
('BV', 'BV', '.bv', 'Bouvet Island'),
('BX', 'BN', '.bn', 'Brunei'),
('BY', 'BI', '.bi', 'Burundi'),
('CA', 'CA', '.ca', 'Canada'),
('CB', 'KH', '.kh', 'Cambodia'),
('CD', 'TD', '.td', 'Chad'),
('CE', 'LK', '.lk', 'Sri Lanka'),
('CF', 'CG', '.cg', 'Congo, Republic of the'),
('CG', 'CD', '.cd', 'Congo, Democratic Republic of the'),
('CH', 'CN', '.cn', 'China'),
('CI', 'CL', '.cl', 'Chile'),
('CJ', 'KY', '.ky', 'Cayman Islands'),
('CK', 'CC', '.cc', 'Cocos (Keeling) Islands'),
('CM', 'CM', '.cm', 'Cameroon'),
('CN', 'KM', '.km', 'Comoros'),
('CO', 'CO', '.co', 'Colombia'),
('CQ', 'MP', '.mp', 'Northern Mariana Islands'),
('CR', '-', '-', 'Coral Sea Islands'),
('CS', 'CR', '.cr', 'Costa Rica'),
('CT', 'CF', '.cf', 'Central African Republic'),
('CU', 'CU', '.cu', 'Cuba'),
('CV', 'CV', '.cv', 'Cape Verde'),
('CW', 'CK', '.ck', 'Cook Islands'),
('CY', 'CY', '.cy', 'Cyprus'),
('DA', 'DK', '.dk', 'Denmark'),
('DJ', 'DJ', '.dj', 'Djibouti'),
('DO', 'DM', '.dm', 'Dominica'),
('DQ', 'UM', '-', 'Jarvis Island'),
('DR', 'DO', '.do', 'Dominican Republic'),
('DX', '-', '-', 'Dhekelia Sovereign Base Area'),
('EC', 'EC', '.ec', 'Ecuador'),
('EG', 'EG', '.eg', 'Egypt'),
('EI', 'IE', '.ie', 'Ireland'),
('EK', 'GQ', '.gq', 'Equatorial Guinea'),
('EN', 'EE', '.ee', 'Estonia'),
('ER', 'ER', '.er', 'Eritrea'),
('ES', 'SV', '.sv', 'El Salvador'),
('ET', 'ET', '.et', 'Ethiopia'),
('EU', '-', '-', 'Europa Island'),
('EZ', 'CZ', '.cz', 'Czech Republic'),
('FG', 'GF', '.gf', 'French Guiana'),
('FI', 'FI', '.fi', 'Finland'),
('FJ', 'FJ', '.fj', 'Fiji'),
('FK', 'FK', '.fk', 'Falkland Islands (Islas Malvinas)'),
('FM', 'FM', '.fm', 'Micronesia, Federated States of'),
('FO', 'FO', '.fo', 'Faroe Islands'),
('FP', 'PF', '.pf', 'French Polynesia'),
('FQ', 'UM', '-', 'Baker Island'),
('FR', 'FR', '.fr', 'France'),
('FS', 'TF', '.tf', 'French Southern and Antarctic Lands'),
('GA', 'GM', '.gm', 'Gambia, The'),
('GB', 'GA', '.ga', 'Gabon'),
('GG', 'GE', '.ge', 'Georgia'),
('GH', 'GH', '.gh', 'Ghana'),
('GI', 'GI', '.gi', 'Gibraltar'),
('GJ', 'GD', '.gd', 'Grenada'),
('GK', '-', '.gg', 'Guernsey'),
('GL', 'GL', '.gl', 'Greenland'),
('GM', 'DE', '.de', 'Germany'),
('GO', '-', '-', 'Glorioso Islands'),
('GP', 'GP', '.gp', 'Guadeloupe'),
('GQ', 'GU', '.gu', 'Guam'),
('GR', 'GR', '.gr', 'Greece'),
('GT', 'GT', '.gt', 'Guatemala'),
('GV', 'GN', '.gn', 'Guinea'),
('GY', 'GY', '.gy', 'Guyana'),
('GZ', '-', '-', 'Gaza Strip'),
('HA', 'HT', '.ht', 'Haiti'),
('HK', 'HK', '.hk', 'Hong Kong'),
('HM', 'HM', '.hm', 'Heard Island and McDonald Islands'),
('HO', 'HN', '.hn', 'Honduras'),
('HQ', 'UM', '-', 'Howland Island'),
('HR', 'HR', '.hr', 'Croatia'),
('HU', 'HU', '.hu', 'Hungary'),
('IC', 'IS', '.is', 'Iceland'),
('ID', 'ID', '.id', 'Indonesia'),
('IM', 'IM', '.im', 'Isle of Man'),
('IN', 'IN', '.in', 'India'),
('IO', 'IO', '.io', 'British Indian Ocean Territory'),
('IP', '-', '-', 'Clipperton Island'),
('IR', 'IR', '.ir', 'Iran'),
('IS', 'IL', '.il', 'Israel'),
('IT', 'IT', '.it', 'Italy'),
('IV', 'CI', '.ci', 'Cote d\'Ivoire'),
('IZ', 'IQ', '.iq', 'Iraq'),
('JA', 'JP', '.jp', 'Japan'),
('JE', 'JE', '.je', 'Jersey'),
('JM', 'JM', '.jm', 'Jamaica'),
('JN', 'SJ', '-', 'Jan Mayen'),
('JO', 'JO', '.jo', 'Jordan'),
('JQ', 'UM', '-', 'Johnston Atoll'),
('JU', '-', '-', 'Juan de Nova Island'),
('KE', 'KE', '.ke', 'Kenya'),
('KG', 'KG', '.kg', 'Kyrgyzstan'),
('KN', 'KP', '.kp', 'Korea, North'),
('KQ', 'UM', '-', 'Kingman Reef'),
('KR', 'KI', '.ki', 'Kiribati'),
('KS', 'KR', '.kr', 'Korea, South'),
('KT', 'CX', '.cx', 'Christmas Island'),
('KU', 'KW', '.kw', 'Kuwait'),
('KV', 'KV', '-', 'Kosovo'),
('KZ', 'KZ', '.kz', 'Kazakhstan'),
('LA', 'LA', '.la', 'Laos'),
('LE', 'LB', '.lb', 'Lebanon'),
('LG', 'LV', '.lv', 'Latvia'),
('LH', 'LT', '.lt', 'Lithuania'),
('LI', 'LR', '.lr', 'Liberia'),
('LO', 'SK', '.sk', 'Slovakia'),
('LQ', 'UM', '-', 'Palmyra Atoll'),
('LS', 'LI', '.li', 'Liechtenstein'),
('LT', 'LS', '.ls', 'Lesotho'),
('LU', 'LU', '.lu', 'Luxembourg'),
('LY', 'LY', '.ly', 'Libyan Arab'),
('MA', 'MG', '.mg', 'Madagascar'),
('MB', 'MQ', '.mq', 'Martinique'),
('MC', 'MO', '.mo', 'Macau'),
('MD', 'MD', '.md', 'Moldova, Republic of'),
('MF', 'YT', '.yt', 'Mayotte'),
('MG', 'MN', '.mn', 'Mongolia'),
('MH', 'MS', '.ms', 'Montserrat'),
('MI', 'MW', '.mw', 'Malawi'),
('MJ', 'ME', '.me', 'Montenegro'),
('MK', 'MK', '.mk', 'The Former Yugoslav Republic of Macedonia'),
('ML', 'ML', '.ml', 'Mali'),
('MN', 'MC', '.mc', 'Monaco'),
('MO', 'MA', '.ma', 'Morocco'),
('MP', 'MU', '.mu', 'Mauritius'),
('MQ', 'UM', '-', 'Midway Islands'),
('MR', 'MR', '.mr', 'Mauritania'),
('MT', 'MT', '.mt', 'Malta'),
('MU', 'OM', '.om', 'Oman'),
('MV', 'MV', '.mv', 'Maldives'),
('MX', 'MX', '.mx', 'Mexico'),
('MY', 'MY', '.my', 'Malaysia'),
('MZ', 'MZ', '.mz', 'Mozambique'),
('NC', 'NC', '.nc', 'New Caledonia'),
('NE', 'NU', '.nu', 'Niue'),
('NF', 'NF', '.nf', 'Norfolk Island'),
('NG', 'NE', '.ne', 'Niger'),
('NH', 'VU', '.vu', 'Vanuatu'),
('NI', 'NG', '.ng', 'Nigeria'),
('NL', 'NL', '.nl', 'Netherlands'),
('NM', '', '', 'No Man\'s Land'),
('NO', 'NO', '.no', 'Norway'),
('NP', 'NP', '.np', 'Nepal'),
('NR', 'NR', '.nr', 'Nauru'),
('NS', 'SR', '.sr', 'Suriname'),
('NT', 'AN', '.an', 'Netherlands Antilles'),
('NU', 'NI', '.ni', 'Nicaragua'),
('NZ', 'NZ', '.nz', 'New Zealand'),
('PA', 'PY', '.py', 'Paraguay'),
('PC', 'PN', '.pn', 'Pitcairn Islands'),
('PE', 'PE', '.pe', 'Peru'),
('PF', '-', '-', 'Paracel Islands'),
('PG', '-', '-', 'Spratly Islands'),
('PK', 'PK', '.pk', 'Pakistan'),
('PL', 'PL', '.pl', 'Poland'),
('PM', 'PA', '.pa', 'Panama'),
('PO', 'PT', '.pt', 'Portugal'),
('PP', 'PG', '.pg', 'Papua New Guinea'),
('PS', 'PW', '.pw', 'Palau'),
('PU', 'GW', '.gw', 'Guinea-Bissau'),
('QA', 'QA', '.qa', 'Qatar'),
('RE', 'RE', '.re', 'Reunion'),
('RI', 'RS', '.rs', 'Serbia'),
('RM', 'MH', '.mh', 'Marshall Islands'),
('RN', 'MF', '-', 'Saint Martin'),
('RO', 'RO', '.ro', 'Romania'),
('RP', 'PH', '.ph', 'Philippines'),
('RQ', 'PR', '.pr', 'Puerto Rico'),
('RS', 'RU', '.ru', 'Russia'),
('RW', 'RW', '.rw', 'Rwanda'),
('SA', 'SA', '.sa', 'Saudi Arabia'),
('SB', 'PM', '.pm', 'Saint Pierre and Miquelon'),
('SC', 'KN', '.kn', 'Saint Kitts and Nevis'),
('SE', 'SC', '.sc', 'Seychelles'),
('SF', 'ZA', '.za', 'South Africa'),
('SG', 'SN', '.sn', 'Senegal'),
('SH', 'SH', '.sh', 'Saint Helena'),
('SI', 'SI', '.si', 'Slovenia'),
('SL', 'SL', '.sl', 'Sierra Leone'),
('SM', 'SM', '.sm', 'San Marino'),
('SN', 'SG', '.sg', 'Singapore'),
('SO', 'SO', '.so', 'Somalia'),
('SP', 'ES', '.es', 'Spain'),
('ST', 'LC', '.lc', 'Saint Lucia'),
('SU', 'SD', '.sd', 'Sudan'),
('SV', 'SJ', '.sj', 'Svalbard'),
('SW', 'SE', '.se', 'Sweden'),
('SX', 'GS', '.gs', 'South Georgia and the Islands'),
('SY', 'SY', '.sy', 'Syrian Arab Republic'),
('SZ', 'CH', '.ch', 'Switzerland'),
('TD', 'TT', '.tt', 'Trinidad and Tobago'),
('TE', '-', '-', 'Tromelin Island'),
('TH', 'TH', '.th', 'Thailand'),
('TI', 'TJ', '.tj', 'Tajikistan'),
('TK', 'TC', '.tc', 'Turks and Caicos Islands'),
('TL', 'TK', '.tk', 'Tokelau'),
('TN', 'TO', '.to', 'Tonga'),
('TO', 'TG', '.tg', 'Togo'),
('TP', 'ST', '.st', 'Sao Tome and Principe'),
('TS', 'TN', '.tn', 'Tunisia'),
('TT', 'TL', '.tl', 'East Timor'),
('TU', 'TR', '.tr', 'Turkey'),
('TV', 'TV', '.tv', 'Tuvalu'),
('TW', 'TW', '.tw', 'Taiwan'),
('TX', 'TM', '.tm', 'Turkmenistan'),
('TZ', 'TZ', '.tz', 'Tanzania, United Republic of'),
('UG', 'UG', '.ug', 'Uganda'),
('UK', 'GB', '.uk', 'United Kingdom'),
('UP', 'UA', '.ua', 'Ukraine'),
('US', 'US', '.us', 'United States'),
('UV', 'BF', '.bf', 'Burkina Faso'),
('UY', 'UY', '.uy', 'Uruguay'),
('UZ', 'UZ', '.uz', 'Uzbekistan'),
('VC', 'VC', '.vc', 'Saint Vincent and the Grenadines'),
('VE', 'VE', '.ve', 'Venezuela'),
('VI', 'VG', '.vg', 'British Virgin Islands'),
('VM', 'VN', '.vn', 'Vietnam'),
('VQ', 'VI', '.vi', 'Virgin Islands (US)'),
('VT', 'VA', '.va', 'Holy See (Vatican City)'),
('WA', 'NA', '.na', 'Namibia'),
('WE', '-', '-', 'West Bank'),
('WF', 'WF', '.wf', 'Wallis and Futuna'),
('WI', 'EH', '.eh', 'Western Sahara'),
('WQ', 'UM', '-', 'Wake Island'),
('WS', 'WS', '.ws', 'Samoa'),
('WZ', 'SZ', '.sz', 'Swaziland'),
('YI', 'CS', '.yu', 'Serbia and Montenegro'),
('YM', 'YE', '.ye', 'Yemen'),
('ZA', 'ZM', '.zm', 'Zambia'),
('ZI', 'ZW', '.zw', 'Zimbabwe');

— Create table “region”
CREATE TABLE `region`(
`region_code` INT,
`region_name` VARCHAR(10),
INDEX `idx_region_code` (`region_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

— Insert region data
INSERT INTO `region` VALUES
(1, 'Africa'),
(2, 'Americas'),
(3, 'Antarctica'),
(4, 'Asia'),
(5, 'Europe'),
(6, 'Oceania');

— Create table “sub_region”
CREATE TABLE `sub_region`(
`sub_region_code` CHAR(2),
`sub_region_name` VARCHAR(20),
INDEX `idx_sub_region_code` (`sub_region_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

— Insert sub region data
INSERT INTO `sub_region` VALUES
('1A', 'Central Africa'),
('1B', 'Eastern Africa'),
('1C', 'Indian Ocean'),
('1D', 'Northern Africa'),
('1E', 'Southern Africa'),
('1F', 'Western Africa'),
('2A', 'Central America'),
('2B', 'North America'),
('2C', 'South America'),
('2D', 'West Indies'),
('3A', 'Antarctica'),
('3B', 'Atlantic Ocean'),
('4A', 'Central Asia'),
('4B', 'East Asia'),
('4C', 'Northern Asia'),
('4D', 'South Asia'),
('4E', 'South East Asia'),
('4F', 'South West Asia'),
('5A', 'Central Europe'),
('5B', 'Eastern Europe'),
('5C', 'Northern Europe'),
('5D', 'South East Europe'),
('5E', 'South West Europe'),
('5F', 'Southern Europe'),
('5G', 'Western Europe'),
('6A', 'North Pacific Ocean'),
('6B', 'Pacific'),
('6C', 'South Pacific Ocean');

— Create table “city_feature”
CREATE TABLE `city_feature`(
`feature_code` VARCHAR(5),
`feature_name` VARCHAR(50),
INDEX `idx_feature_code` (`feature_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

— Insert feature data
INSERT INTO `city_feature` VALUES
('PPL', 'Populated place'),
('PPLA', 'Seat of a first-order administrative division'),
('PPLC', 'Capital of a political entity'),
('PPLL', 'Populated locality'),
('PPLQ', 'Abandoned populated place'),
('PPLR', 'Religious populated place'),
('PPLS', 'Populated places'),
('PPLW', 'Destroyed populated place'),
('PPLX', 'Section of populated place'),
('PPLA2', 'Second-order administrative division'),
('PPLA3', 'Third-order administrative division'),
('PPLA4', 'Fourth-order administrative division');

Strict Standards: Non-static method JLoader::import() should not be called statically in

I was getting lot's of error messages for my joomla installation, after my php version for my shared hosting company upgraded the php version .

Strict Standards: Non-static method JLoader::import() should not be called statically in.

To stop the error message, just added the following code in my index.php file for my front end and back end script and the error messages has stop.

Strict Standards: Non-static method JLoader::import() should not be called statically in

define( '_JEXEC', 1 );

error_reporting( E_ERROR | E_PARSE | E_CORE_ERROR | E_CORE_WARNING | E_COMPILE_ERROR | E_COMPILE_WARNING );

Dumping large database into mysql sql using console

Dumping large database into mysql sql using console

Change the directory where your mysql folder is located for easyphp. Mine is as follow


C:\Program Files\EasyPHP5.3.0\mysql\bin>


Type the following command, i am accessing via root.


C:\Program Files\EasyPHP5.3.0\mysql\bin>mysql -p -u root;

Enter the password:

Drop the current database.

mysql > drop database [database name] ;

mysql > show databases;

mysql > create database [database name] ;

mysql > use [database name] ;

Dump data into the database

mysql> source freepres_freeprdb.sql ;

mysql> show tables;

Check the total records, to see the latest record.

mysql > select count(*) as total_records from articles;


Free Press Release DB, Helps You To Reach Out To Global Audition

Just developed a press release site Submit Press Release @ Free Press Release DB

You can submit press release easily, no restriction to the number of press release.

Not easy developing the system. Quite hard also.

You can browse for the latest press release based on country. Enjoy posting your press release.

http://freepressreleasedb.com/country/Latest-France-Press-Release-CC-FR/

http://freepressreleasedb.com/country/Latest-Ireland-Press-Release-CC-IE/

http://freepressreleasedb.com/country/Latest-Malaysia-Press-Release-CC-MY/

How to access EasyPhp MySql Command Line

Whatever you do, always back you file using php admin all the database first before accessing mysql via command line. You don't want to screw up your database if anything happen. I did.


Go to Ms Dos command line.


Change the directory where your mysql folder is located for easyphp. Mine is as follow


C:\Program Files\EasyPHP5.3.0\mysql\bin>


Type the following command, i am accessing via root.


C:\Program Files\EasyPHP5.3.0\mysql\bin>mysql -p -u root


Once click enter. It will request password. Just enter cause normally it is blank.


That's all, screen shot below. You will get the idea..


How to access EasyPhp MySql Command Line
How to access EasyPhp MySql Command Line


Easiest way to reduce multiple photos file size using Picasa 3

I have been using GIMP to reduce my pictures before this. The process is bit slow if you have many photos. Found out that Picasa 3 could the job much faster.

The steps are as follows:

1. Download Picasa 3, if you don't have one.

2. Open the program.

3. Picasa will auto scan your folders for photos, if it didn't found your photo folder. Then click File > Add Folder To Picasa. Then scan the folder that got the images.

Easiest way to reduce multiple photos file size using Picasa 3
Scan the photos

4. Then click the photo that you want to reduce the file size and click File > Export Picture To Folder.

Easiest way to reduce multiple photos file size using Picasa 3
Export the photos

5. At Export To Folder pop up, select the folder that you want to export your photo. Name the folder name. Click Resize To to reduce the file size. 800 pixel is good enough if you want upload your photos to website or blog. Add your watermark. And then click export. That's all.

Easiest way to reduce multiple photos file size using Picasa 3
Resize the photo

Live Minutes Review, Free Web Conferencing Software

Looking for free web conferencing software, visit Live Minutes. They provide free web conferencing software. Yes, it is free and I am not sure how they're going to monetize their product. 


You can share and collaborate with others to discuss about any document, excel design sheet and design template. It is much more effective then by sending the files to your colleagues via email.
You could host a meeting without sign in, but your nice report would be public. Therefore, better you sign up and host a meeting. To sign up it is easy; just enter your username, email and password. That’s all. 


Then you could host a meeting. Just click the Host a Meeting button. And start inviting your friend to the meeting by sending web conference link to your friends.
To have better audio and video system, use skype. Click skype icon, at the dashboard and you must also login into skype to enable skype mode for the web conference. Wait for other participants to call you, if you’re the host.
You could use Live Minutes whiteboard to convey hard to grasp ideas. Once the meeting is over, you could download a nice report that captures the participant inputs to the document. 


For more information, why not visit Live Minutes.
Live Minutes Review, Free Web Conferencing Software