Canada Provinces SQL

Are you looking for Canada Provinces SQL. Here you go.

--
-- Create table `canadian_provinces`
--
CREATE TABLE `canadian_provinces` (
`id` int(11) NOT NULL auto_increment,
`state` varchar(200) NOT NULL,
`abbreviation` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

-- Insert data
INSERT INTO `canadian_provinces` (`id`, `state`, `abbreviation`)
VALUES (1, 'Alberta', 'AB'),
(2, 'British Columbia', 'BC'),
(3, 'Manitoba', 'MB'),
(4, 'New Brunswick', 'NB'),
(5, 'Newfoundland and Labrador', 'NL'),
(6, 'Northwest Territories', 'NT'),
(7, 'Nova Scotia', 'NS'),
(8, 'Nunavut', 'NU'),
(9, 'Ontario', 'ON'),
(10, 'Prince Edward Island', 'PE'),
(11, 'Québec', 'QC'),
(12, 'Saskatchewan', 'SK'),
(13, 'Yukon Territory', 'YT');

Make me your home page script

Here is a simple script to set your website as home page of user browser:

<a href="#" onclick="this.style.behavior='url(#default#homepage)';this.setHomePage('http://www.webhelps247.com');">Make me your home page</a>

Notes:

1. You have to change http://www.webhelps247.com' to you webiste URL.

2. The script is compatible with IE version 5 and plus.

Copyright message with current year

Even corporate websites have their copy right messages with past years. Here is simple php code for displaying copyright message with current year dynamically.

&copy; Copyright 2004 - <?php echo date("Y") ?> Web Helps 247  , All rights reserved.

Please kindly let us know how help was this post.