mysql dump file into a php search page

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
gavenp
Forum Newbie
Posts: 6
Joined: Sat Jun 09, 2007 3:03 am

mysql dump file into a php search page

Post by gavenp »

I would like to make a search page out of the following sql tables. Can anyone give me assistance on how Iwould do this.

I only want to search using company, position and country for now.

Code: Select all

<?php

$sql = array (
  0 => 'Database worktest running on localhost 


CREATE TABLE `company` (
  `companyid` varchar(255) NOT NULL default \'\',
  `type` int(11) default \'0\',
  `name` varchar(255) default NULL,
  `country` int(11) default \'0\',
  `address` varchar(255) default NULL,
  `suburb` varchar(255) default NULL,
  `state` varchar(255) default NULL,
  `postcode` varchar(255) default NULL,
  `phone` varchar(255) default NULL,
  `fax` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `url` varchar(255) default NULL,
  `industry` int(11) default \'0\',
  `description` varchar(255) default NULL,
  `adlocs` varchar(255) default NULL,
  `workexp` tinyint(1) default NULL,
  `recruitcomp` varchar(255) default NULL,
  `employees` varchar(255) default NULL,
  PRIMARY KEY  (`companyid`),
  KEY `postcode` (`postcode`),
  KEY `Reference` (`type`),
  KEY `Reference1` (`country`),
  KEY `Reference2` (`industry`),
  CONSTRAINT `Reference` FOREIGN KEY (`type`) REFERENCES `reg_type` (`typeid`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `Reference1` FOREIGN KEY (`country`) REFERENCES `countries` (`countryid`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `Reference2` FOREIGN KEY (`industry`) REFERENCES `industries` (`industryid`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8',
  1 => 'CREATE TABLE `countries` (
  `countryid` int(11) NOT NULL auto_increment,
  `iso_code` varchar(255) default NULL,
  `country` varchar(255) default NULL,
  PRIMARY KEY  (`countryid`),
  KEY `Code` (`iso_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=246',
  2 => 'INSERT INTO `countries` VALUES (1, \'AF\', \'Afghanistan\')',
  3 => 'INSERT INTO `countries` VALUES (2, \'AL\', \'Albania\')',
  4 => 'INSERT INTO `countries` VALUES (3, \'DZ\', \'Algeria\')',
  5 => 'INSERT INTO `countries` VALUES (4, \'AS\', \'American Samoa\')',
  6 => 'INSERT INTO `countries` VALUES (5, \'AD\', \'Andorra\')',
  7 => 'INSERT INTO `countries` VALUES (6, \'AO\', \'Angola\')',
  8 => 'INSERT INTO `countries` VALUES (7, \'AI\', \'Anguilla\')',
  9 => 'INSERT INTO `countries` VALUES (8, \'AQ\', \'Antarctica\')',
  10 => 'INSERT INTO `countries` VALUES (9, \'AG\', \'Antigua and Barbuda\')',
  11 => 'INSERT INTO `countries` VALUES (10, \'AR\', \'Argentina\')',
  12 => 'INSERT INTO `countries` VALUES (11, \'AM\', \'Armenia\')',
  13 => 'INSERT INTO `countries` VALUES (12, \'AW\', \'Aruba\')',
  14 => 'INSERT INTO `countries` VALUES (13, \'AU\', \'Australia\')',
  15 => 'INSERT INTO `countries` VALUES (14, \'AT\', \'Austria\')',
  16 => 'INSERT INTO `countries` VALUES (15, \'AZ\', \'Azerbaijan\')',
  17 => 'INSERT INTO `countries` VALUES (16, \'BS\', \'Bahamas\')',
  18 => 'INSERT INTO `countries` VALUES (17, \'BH\', \'Bahrain\')',
  19 => 'INSERT INTO `countries` VALUES (18, \'BB\', \'Barbados\')',
  20 => 'INSERT INTO `countries` VALUES (19, \'BD\', \'Bangladesh\')',
  21 => 'INSERT INTO `countries` VALUES (20, \'BY\', \'Belarus\')',
  22 => 'INSERT INTO `countries` VALUES (21, \'BE\', \'Belgium\')',
  23 => 'INSERT INTO `countries` VALUES (22, \'BZ\', \'Belize\')',
  24 => 'INSERT INTO `countries` VALUES (23, \'BJ\', \'Benin\')',
  25 => 'INSERT INTO `countries` VALUES (24, \'BM\', \'Bermuda\')',
  26 => 'INSERT INTO `countries` VALUES (25, \'BS\', \'Bahamas\')',
  27 => 'INSERT INTO `countries` VALUES (26, \'BT\', \'Bhutan\')',
  28 => 'INSERT INTO `countries` VALUES (27, \'BW\', \'Botswana\')',
  29 => 'INSERT INTO `countries` VALUES (28, \'BO\', \'Bolivia\')',
  30 => 'INSERT INTO `countries` VALUES (29, \'BA\', \'Bosnia and Herzegovina\')',
  31 => 'INSERT INTO `countries` VALUES (30, \'BV\', \'Bouvet Island\')',
  32 => 'INSERT INTO `countries` VALUES (31, \'BR\', \'Brazil\')',
  33 => 'INSERT INTO `countries` VALUES (32, \'IO\', \'British Indian Ocean Territory\')',
  34 => 'INSERT INTO `countries` VALUES (33, \'BN\', \'Brunei Darussalam\')',
  35 => 'INSERT INTO `countries` VALUES (34, \'BG\', \'Bulgaria\')',
  36 => 'INSERT INTO `countries` VALUES (35, \'BF\', \'Burkina Faso\')',
  37 => 'INSERT INTO `countries` VALUES (36, \'BI\', \'Burundi\')',
  38 => 'INSERT INTO `countries` VALUES (37, \'KH\', \'Cambodia\')',
  39 => 'INSERT INTO `countries` VALUES (38, \'CM\', \'Cameroon\')',
  40 => 'INSERT INTO `countries` VALUES (39, \'CA\', \'Canada\')',
  41 => 'INSERT INTO `countries` VALUES (40, \'CV\', \'Cape Verde\')',
  42 => 'INSERT INTO `countries` VALUES (41, \'KY\', \'Cayman Islands\')',
  43 => 'INSERT INTO `countries` VALUES (42, \'CF\', \'Central African Republic\')',
  44 => 'INSERT INTO `countries` VALUES (43, \'TD\', \'Chad\')',
  45 => 'INSERT INTO `countries` VALUES (44, \'CL\', \'Chile\')',
  46 => 'INSERT INTO `countries` VALUES (45, \'CN\', \'China\')',
  47 => 'INSERT INTO `countries` VALUES (46, \'CX\', \'Christmas Island\')',
  48 => 'INSERT INTO `countries` VALUES (47, \'CC\', \'Cocos (Keeling) Islands\')',
  49 => 'INSERT INTO `countries` VALUES (48, \'CO\', \'Colombia\')',
  50 => 'INSERT INTO `countries` VALUES (49, \'KM\', \'Comoros\')',
  51 => 'INSERT INTO `countries` VALUES (50, \'CG\', \'Congo\')',
  52 => 'INSERT INTO `countries` VALUES (51, \'CD\', \'Congo, Democratic Republic\')',
  53 => 'INSERT INTO `countries` VALUES (52, \'CK\', \'Cook Islands\')',
  54 => 'INSERT INTO `countries` VALUES (53, \'CR\', \'Costa Rica\')',
  55 => 'INSERT INTO `countries` VALUES (55, \'HR\', \'Croatia (Hrvatska)\')',
  56 => 'INSERT INTO `countries` VALUES (56, \'CU\', \'Cuba\')',
  57 => 'INSERT INTO `countries` VALUES (57, \'CY\', \'Cyprus\')',
  58 => 'INSERT INTO `countries` VALUES (58, \'CZ\', \'Czech Republic\')',
  59 => 'INSERT INTO `countries` VALUES (59, \'CS\', \'Czechoslovakia (former)\')',
  60 => 'INSERT INTO `countries` VALUES (60, \'DK\', \'Denmark\')',
  61 => 'INSERT INTO `countries` VALUES (61, \'DJ\', \'Djibouti\')',
  62 => 'INSERT INTO `countries` VALUES (62, \'DM\', \'Dominica\')',
  63 => 'INSERT INTO `countries` VALUES (63, \'DO\', \'Dominican Republic\')',
  64 => 'INSERT INTO `countries` VALUES (64, \'TP\', \'East Timor\')',
  65 => 'INSERT INTO `countries` VALUES (65, \'EC\', \'Ecuador\')',
  66 => 'INSERT INTO `countries` VALUES (66, \'EG\', \'Egypt\')',
  67 => 'INSERT INTO `countries` VALUES (67, \'SV\', \'El Salvador\')',
  68 => 'INSERT INTO `countries` VALUES (68, \'GQ\', \'Equatorial Guinea\')',
  69 => 'INSERT INTO `countries` VALUES (69, \'ER\', \'Eritrea\')',
  70 => 'INSERT INTO `countries` VALUES (70, \'EE\', \'Estonia\')',
  71 => 'INSERT INTO `countries` VALUES (71, \'ET\', \'Ethiopia\')',
  72 => 'INSERT INTO `countries` VALUES (72, \'FK\', \'Falkland Islands (Malvinas)\')',
  73 => 'INSERT INTO `countries` VALUES (73, \'FO\', \'Faroe Islands\')',
  74 => 'INSERT INTO `countries` VALUES (74, \'FJ\', \'Fiji\')',
  75 => 'INSERT INTO `countries` VALUES (75, \'FI\', \'Finland\')',
  76 => 'INSERT INTO `countries` VALUES (76, \'FR\', \'France\')',
  77 => 'INSERT INTO `countries` VALUES (77, \'FX\', \'France, Metropolitan\')',
  78 => 'INSERT INTO `countries` VALUES (78, \'GF\', \'French Guiana\')',
  79 => 'INSERT INTO `countries` VALUES (79, \'PF\', \'French Polynesia\')',
  80 => 'INSERT INTO `countries` VALUES (80, \'TF\', \'French Southern Territories\')',
  81 => 'INSERT INTO `countries` VALUES (81, \'MK\', \'F.Y.R.O.M. (Macedonia)\')',
  82 => 'INSERT INTO `countries` VALUES (82, \'GA\', \'Gabon\')',
  83 => 'INSERT INTO `countries` VALUES (83, \'GM\', \'Gambia\')',
  84 => 'INSERT INTO `countries` VALUES (84, \'GE\', \'Georgia\')',
  85 => 'INSERT INTO `countries` VALUES (85, \'DE\', \'Germany\')',
  86 => 'INSERT INTO `countries` VALUES (86, \'GH\', \'Ghana\')',
  87 => 'INSERT INTO `countries` VALUES (87, \'GI\', \'Gibraltar\')',
  88 => 'INSERT INTO `countries` VALUES (88, \'GB\', \'Great Britain (UK)\')',
  89 => 'INSERT INTO `countries` VALUES (89, \'GR\', \'Greece\')',
  90 => 'INSERT INTO `countries` VALUES (90, \'GL\', \'Greenland\')',
  91 => 'INSERT INTO `countries` VALUES (91, \'GD\', \'Grenada\')',
  92 => 'INSERT INTO `countries` VALUES (92, \'GP\', \'Guadeloupe\')',
  93 => 'INSERT INTO `countries` VALUES (93, \'GU\', \'Guam\')',
  94 => 'INSERT INTO `countries` VALUES (94, \'GT\', \'Guatemala\')',
  95 => 'INSERT INTO `countries` VALUES (95, \'GN\', \'Guinea\')',
  96 => 'INSERT INTO `countries` VALUES (96, \'GW\', \'Guinea-Bissau\')',
  97 => 'INSERT INTO `countries` VALUES (97, \'GY\', \'Guyana\')',
  98 => 'INSERT INTO `countries` VALUES (98, \'HT\', \'Haiti\')',
  99 => 'INSERT INTO `countries` VALUES (99, \'HM\', \'Heard and McDonald Islands\')',
  100 => 'INSERT INTO `countries` VALUES (100, \'HN\', \'Honduras\')',
  101 => 'INSERT INTO `countries` VALUES (101, \'HK\', \'Hong Kong\')',
  102 => 'INSERT INTO `countries` VALUES (102, \'HU\', \'Hungary\')',
  103 => 'INSERT INTO `countries` VALUES (103, \'IS\', \'Iceland\')',
  104 => 'INSERT INTO `countries` VALUES (104, \'IN\', \'India\')',
  105 => 'INSERT INTO `countries` VALUES (105, \'ID\', \'Indonesia\')',
  106 => 'INSERT INTO `countries` VALUES (106, \'IR\', \'Iran\')',
  107 => 'INSERT INTO `countries` VALUES (107, \'IQ\', \'Iraq\')',
  108 => 'INSERT INTO `countries` VALUES (108, \'IE\', \'Ireland\')',
  109 => 'INSERT INTO `countries` VALUES (109, \'IL\', \'Israel\')',
  110 => 'INSERT INTO `countries` VALUES (110, \'IT\', \'Italy\')',
  111 => 'INSERT INTO `countries` VALUES (111, \'JM\', \'Jamaica\')',
  112 => 'INSERT INTO `countries` VALUES (112, \'JP\', \'Japan\')',
  113 => 'INSERT INTO `countries` VALUES (113, \'JO\', \'Jordan\')',
  114 => 'INSERT INTO `countries` VALUES (114, \'KZ\', \'Kazakhstan\')',
  115 => 'INSERT INTO `countries` VALUES (115, \'KE\', \'Kenya\')',
  116 => 'INSERT INTO `countries` VALUES (116, \'KI\', \'Kiribati\')',
  117 => 'INSERT INTO `countries` VALUES (117, \'KP\', \'Korea (North)\')',
  118 => 'INSERT INTO `countries` VALUES (118, \'KR\', \'Korea (South)\')',
  119 => 'INSERT INTO `countries` VALUES (119, \'KW\', \'Kuwait\')',
  120 => 'INSERT INTO `countries` VALUES (120, \'KG\', \'Kyrgyzstan\')',
  121 => 'INSERT INTO `countries` VALUES (121, \'LA\', \'Laos\')',
  122 => 'INSERT INTO `countries` VALUES (122, \'LV\', \'Latvia\')',
  123 => 'INSERT INTO `countries` VALUES (123, \'LB\', \'Lebanon\')',
  124 => 'INSERT INTO `countries` VALUES (124, \'LI\', \'Liechtenstein\')',
  125 => 'INSERT INTO `countries` VALUES (125, \'LR\', \'Liberia\')',
  126 => 'INSERT INTO `countries` VALUES (126, \'LY\', \'Libya\')',
  127 => 'INSERT INTO `countries` VALUES (127, \'LS\', \'Lesotho\')',
  128 => 'INSERT INTO `countries` VALUES (128, \'LT\', \'Lithuania\')',
  129 => 'INSERT INTO `countries` VALUES (129, \'LU\', \'Luxembourg\')',
  130 => 'INSERT INTO `countries` VALUES (130, \'MO\', \'Macau\')',
  131 => 'INSERT INTO `countries` VALUES (131, \'MG\', \'Madagascar\')',
  132 => 'INSERT INTO `countries` VALUES (132, \'MW\', \'Malawi\')',
  133 => 'INSERT INTO `countries` VALUES (133, \'MY\', \'Malaysia\')',
  134 => 'INSERT INTO `countries` VALUES (134, \'MV\', \'Maldives\')',
  135 => 'INSERT INTO `countries` VALUES (135, \'ML\', \'Mali\')',
  136 => 'INSERT INTO `countries` VALUES (136, \'MT\', \'Malta\')',
  137 => 'INSERT INTO `countries` VALUES (137, \'MH\', \'Marshall Islands\')',
  138 => 'INSERT INTO `countries` VALUES (138, \'MQ\', \'Martinique\')',
  139 => 'INSERT INTO `countries` VALUES (139, \'MR\', \'Mauritania\')',
  140 => 'INSERT INTO `countries` VALUES (140, \'MU\', \'Mauritius\')',
  141 => 'INSERT INTO `countries` VALUES (141, \'YT\', \'Mayotte\')',
  142 => 'INSERT INTO `countries` VALUES (142, \'MX\', \'Mexico\')',
  143 => 'INSERT INTO `countries` VALUES (143, \'FM\', \'Micronesia\')',
  144 => 'INSERT INTO `countries` VALUES (144, \'MC\', \'Monaco\')',
  145 => 'INSERT INTO `countries` VALUES (145, \'MD\', \'Moldova\')',
  146 => 'INSERT INTO `countries` VALUES (146, \'MA\', \'Morocco\')',
  147 => 'INSERT INTO `countries` VALUES (147, \'MN\', \'Mongolia\')',
  148 => 'INSERT INTO `countries` VALUES (148, \'MS\', \'Montserrat\')',
  149 => 'INSERT INTO `countries` VALUES (149, \'MZ\', \'Mozambique\')',
  150 => 'INSERT INTO `countries` VALUES (150, \'MM\', \'Myanmar\')',
  151 => 'INSERT INTO `countries` VALUES (151, \'NA\', \'Namibia\')',
  152 => 'INSERT INTO `countries` VALUES (152, \'NR\', \'Nauru\')',
  153 => 'INSERT INTO `countries` VALUES (153, \'NP\', \'Nepal\')',
  154 => 'INSERT INTO `countries` VALUES (154, \'NL\', \'Netherlands\')',
  155 => 'INSERT INTO `countries` VALUES (155, \'AN\', \'Netherlands Antilles\')',
  156 => 'INSERT INTO `countries` VALUES (156, \'NT\', \'Neutral Zone\')',
  157 => 'INSERT INTO `countries` VALUES (157, \'NC\', \'New Caledonia\')',
  158 => 'INSERT INTO `countries` VALUES (158, \'NZ\', \'New Zealand (Aotearoa)\')',
  159 => 'INSERT INTO `countries` VALUES (159, \'NI\', \'Nicaragua\')',
  160 => 'INSERT INTO `countries` VALUES (160, \'NE\', \'Niger\')',
  161 => 'INSERT INTO `countries` VALUES (161, \'NG\', \'Nigeria\')',
  162 => 'INSERT INTO `countries` VALUES (162, \'NU\', \'Niue\')',
  163 => 'INSERT INTO `countries` VALUES (163, \'NF\', \'Norfolk Island\')',
  164 => 'INSERT INTO `countries` VALUES (164, \'MP\', \'Northern Mariana Islands\')',
  165 => 'INSERT INTO `countries` VALUES (165, \'NO\', \'Norway\')',
  166 => 'INSERT INTO `countries` VALUES (166, \'OM\', \'Oman\')',
  167 => 'INSERT INTO `countries` VALUES (167, \'PK\', \'Pakistan\')',
  168 => 'INSERT INTO `countries` VALUES (168, \'PW\', \'Palau\')',
  169 => 'INSERT INTO `countries` VALUES (169, \'PA\', \'Panama\')',
  170 => 'INSERT INTO `countries` VALUES (170, \'PG\', \'Papua New Guinea\')',
  171 => 'INSERT INTO `countries` VALUES (171, \'PY\', \'Paraguay\')',
  172 => 'INSERT INTO `countries` VALUES (172, \'PE\', \'Peru\')',
  173 => 'INSERT INTO `countries` VALUES (173, \'PH\', \'Philippines\')',
  174 => 'INSERT INTO `countries` VALUES (174, \'PN\', \'Pitcairn\')',
  175 => 'INSERT INTO `countries` VALUES (175, \'PL\', \'Poland\')',
  176 => 'INSERT INTO `countries` VALUES (176, \'PT\', \'Portugal\')',
  177 => 'INSERT INTO `countries` VALUES (177, \'PR\', \'Puerto Rico\')',
  178 => 'INSERT INTO `countries` VALUES (178, \'QA\', \'Qatar\')',
  179 => 'INSERT INTO `countries` VALUES (179, \'RE\', \'Reunion\')',
  180 => 'INSERT INTO `countries` VALUES (180, \'RO\', \'Romania\')',
  181 => 'INSERT INTO `countries` VALUES (181, \'RU\', \'Russian Federation\')',
  182 => 'INSERT INTO `countries` VALUES (182, \'RW\', \'Rwanda\')',
  183 => 'INSERT INTO `countries` VALUES (183, \'GS\', \'S. Georgia and S. Sandwich Isls.\')',
  184 => 'INSERT INTO `countries` VALUES (184, \'KN\', \'Saint Kitts and Nevis\')',
  185 => 'INSERT INTO `countries` VALUES (185, \'LC\', \'Saint Lucia\')',
  186 => 'INSERT INTO `countries` VALUES (186, \'VC\', \'Saint Vincent & the Grenadines\')',
  187 => 'INSERT INTO `countries` VALUES (187, \'WS\', \'Samoa\')',
  188 => 'INSERT INTO `countries` VALUES (188, \'SM\', \'San Marino\')',
  189 => 'INSERT INTO `countries` VALUES (189, \'ST\', \'Sao Tome and Principe\')',
  190 => 'INSERT INTO `countries` VALUES (190, \'SA\', \'Saudi Arabia\')',
  191 => 'INSERT INTO `countries` VALUES (191, \'SN\', \'Senegal\')',
  192 => 'INSERT INTO `countries` VALUES (192, \'SC\', \'Seychelles\')',
  193 => 'INSERT INTO `countries` VALUES (193, \'SL\', \'Sierra Leone\')',
  194 => 'INSERT INTO `countries` VALUES (194, \'SG\', \'Singapore\')',
  195 => 'INSERT INTO `countries` VALUES (195, \'SI\', \'Slovenia\')',
  196 => 'INSERT INTO `countries` VALUES (196, \'SK\', \'Slovak Republic\')',
  197 => 'INSERT INTO `countries` VALUES (197, \'SB\', \'Solomon Islands\')',
  198 => 'INSERT INTO `countries` VALUES (198, \'SO\', \'Somalia\')',
  199 => 'INSERT INTO `countries` VALUES (199, \'ZA\', \'South Africa\')',
  200 => 'INSERT INTO `countries` VALUES (200, \'ES\', \'Spain\')',
  201 => 'INSERT INTO `countries` VALUES (201, \'LK\', \'Sri Lanka\')',
  202 => 'INSERT INTO `countries` VALUES (202, \'SH\', \'St. Helena\')',
  203 => 'INSERT INTO `countries` VALUES (203, \'PM\', \'St. Pierre and Miquelon\')',
  204 => 'INSERT INTO `countries` VALUES (204, \'SD\', \'Sudan\')',
  205 => 'INSERT INTO `countries` VALUES (205, \'SR\', \'Suriname\')',
  206 => 'INSERT INTO `countries` VALUES (206, \'SJ\', \'Svalbard & Jan Mayen Islands\')',
  207 => 'INSERT INTO `countries` VALUES (207, \'SZ\', \'Swaziland\')',
  208 => 'INSERT INTO `countries` VALUES (208, \'SE\', \'Sweden\')',
  209 => 'INSERT INTO `countries` VALUES (209, \'CH\', \'Switzerland\')',
  210 => 'INSERT INTO `countries` VALUES (210, \'SY\', \'Syria\')',
  211 => 'INSERT INTO `countries` VALUES (211, \'TW\', \'Taiwan\')',
  212 => 'INSERT INTO `countries` VALUES (212, \'TJ\', \'Tajikistan\')',
  213 => 'INSERT INTO `countries` VALUES (213, \'TZ\', \'Tanzania\')',
  214 => 'INSERT INTO `countries` VALUES (214, \'TH\', \'Thailand\')',
  215 => 'INSERT INTO `countries` VALUES (215, \'TG\', \'Togo\')',
  216 => 'INSERT INTO `countries` VALUES (216, \'TK\', \'Tokelau\')',
  217 => 'INSERT INTO `countries` VALUES (217, \'TO\', \'Tonga\')',
  218 => 'INSERT INTO `countries` VALUES (218, \'TT\', \'Trinidad and Tobago\')',
  219 => 'INSERT INTO `countries` VALUES (219, \'TN\', \'Tunisia\')',
  220 => 'INSERT INTO `countries` VALUES (220, \'TR\', \'Turkey\')',
  221 => 'INSERT INTO `countries` VALUES (221, \'TM\', \'Turkmenistan\')',
  222 => 'INSERT INTO `countries` VALUES (222, \'TC\', \'Turks and Caicos Islands\')',
  223 => 'INSERT INTO `countries` VALUES (223, \'TV\', \'Tuvalu\')',
  224 => 'INSERT INTO `countries` VALUES (224, \'UG\', \'Uganda\')',
  225 => 'INSERT INTO `countries` VALUES (225, \'UA\', \'Ukraine\')',
  226 => 'INSERT INTO `countries` VALUES (226, \'AE\', \'United Arab Emirates\')',
  227 => 'INSERT INTO `countries` VALUES (227, \'UK\', \'United Kingdom\')',
  228 => 'INSERT INTO `countries` VALUES (228, \'US\', \'United States\')',
  229 => 'INSERT INTO `countries` VALUES (229, \'UM\', \'US Minor Outlying Islands\')',
  230 => 'INSERT INTO `countries` VALUES (230, \'UY\', \'Uruguay\')',
  231 => 'INSERT INTO `countries` VALUES (231, \'SU\', \'USSR (former)\')',
  232 => 'INSERT INTO `countries` VALUES (232, \'UZ\', \'Uzbekistan\')',
  233 => 'INSERT INTO `countries` VALUES (233, \'VU\', \'Vanuatu\')',
  234 => 'INSERT INTO `countries` VALUES (234, \'VA\', \'Vatican City State (Holy See)\')',
  235 => 'INSERT INTO `countries` VALUES (235, \'VE\', \'Venezuela\')',
  236 => 'INSERT INTO `countries` VALUES (236, \'VN\', \'Viet Nam\')',
  237 => 'INSERT INTO `countries` VALUES (237, \'VG\', \'Virgin Islands (British)\')',
  238 => 'INSERT INTO `countries` VALUES (238, \'VI\', \'Virgin Islands (U.S.)\')',
  239 => 'INSERT INTO `countries` VALUES (239, \'WF\', \'Wallis and Futuna Islands\')',
  240 => 'INSERT INTO `countries` VALUES (240, \'EH\', \'Western Sahara\')',
  241 => 'INSERT INTO `countries` VALUES (241, \'YE\', \'Yemen\')',
  242 => 'INSERT INTO `countries` VALUES (242, \'YU\', \'Yugoslavia\')',
  243 => 'INSERT INTO `countries` VALUES (243, \'ZM\', \'Zambia\')',
  244 => 'INSERT INTO `countries` VALUES (244, \'(ZR\', \'Zaire)\')',
  245 => 'INSERT INTO `countries` VALUES (245, \'ZW\', \'Zimbabwe\')',
  246 => 'CREATE TABLE `course_titles` (
  `coursetitleid` int(11) NOT NULL auto_increment,
  `course_title` varchar(255) default NULL,
  `type` varchar(255) default NULL,
  `length` varchar(255) default NULL,
  PRIMARY KEY  (`coursetitleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=624',
  247 => 'INSERT INTO `course_titles` VALUES (1, \'Advanced Diploma in Farm Management (Orange)\', \'Advanced Diploma\', \'104 \\r\\n\\r\\nweeks\')',
  248 => 'INSERT INTO `course_titles` VALUES (2, \'Advanced Diploma in Horticulture (Orange)\', \'Advanced Diploma\', \'104 \\r\\n\\r\\nweeks\')',
  249 => 'INSERT INTO `course_titles` VALUES (3, \'Advanced Diploma of Business (Agricultural Commerce)\\r\\n\\r\\n(orange)\', \'Advanced Diploma\', \'104 weeks\')',
  250 => 'INSERT INTO `course_titles` VALUES (4, \'Advanced Diploma of Equine Business Management (Orange)\', \'Advanced \\r\\n\\r\\nDiploma\', \'104 weeks\')',
  251 => 'INSERT INTO `course_titles` VALUES (5, \'Advanced Diploma of Horicultural Management (Orange)\', \'Advanced \\r\\n\\r\\nDiploma\', \'104 weeks\')',
  252 => 'INSERT INTO `course_titles` VALUES (6, \'Advanced Diploma of Horticulture (Orange)\', \'Advanced Diploma\', \'104 \\r\\n\\r\\nweeks\')',
  253 => 'INSERT INTO `course_titles` VALUES (7, \'Advanced Diploma of Land Management (Orange)\', \'Advanced Diploma\', \'104 \\r\\n\\r\\nweeks\')',
  254 => 'INSERT INTO `course_titles` VALUES (8, \'Advanced Diploma of Management (Orange)\', \'Advanced Diploma\', \'104 \\r\\n\\r\\nweeks\')',
  255 => 'INSERT INTO `course_titles` VALUES (9, \'Advanced Diploma of Rural Business Administration (Orange)\', \'Advanced \\r\\n\\r\\nDiploma\', \'104 weeks\')',
  256 => 'INSERT INTO `course_titles` VALUES (10, \'Advanced Diploma of Viticultural Managemnent (Orange)\', \'Advanced \\r\\n\\r\\nDiploma\', \'104 weeks\')',
  257 => 'INSERT INTO `course_titles` VALUES (11, \'Associate Degree (Ministry)\', \'Associate Degree\', \'104 weeks\')',
  258 => 'INSERT INTO `course_titles` VALUES (12, \'Bach of Health Science (Aborig Health & Comm Devel) \\r\\n\\r\\nHonours\', \'Bachelor Degree\', \'208 weeks\')',
  259 => 'INSERT INTO `course_titles` VALUES (13, \'Bachelor Health Science & Master Rehabilitation \\r\\n\\r\\nCounselling\', \'Bachelor Degree\', \'208 weeks\')',
  260 => 'INSERT INTO `course_titles` VALUES (14, \'Bachelor of Accounting\', \'Masters Degree (Coursework)\', \'104 weeks\')',
  261 => 'INSERT INTO `course_titles` VALUES (15, \'Bachelor of Agricultural Economics\', \'Bachelor Degree\', \'208 weeks\')',
  262 => 'INSERT INTO `course_titles` VALUES (16, \'Bachelor of Animal and Veterinary Bioscience\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
  263 => 'INSERT INTO `course_titles` VALUES (17, \'Bachelor of Animal Science\', \'Bachelor Degree\', \'208 weeks\')',
  264 => 'INSERT INTO `course_titles` VALUES (18, \'Bachelor of Applied Geographical Information Systems\', \'Bachelor \\r\\n\\r\\nDegree\', \'156 weeks\')',
  265 => 'INSERT INTO `course_titles` VALUES (19, \'Bachelor of Applied Geographical Information Systems \\r\\n\\r\\n(Honours)\', \'Bachelor Degree\', \'52 weeks\')',
  266 => 'INSERT INTO `course_titles` VALUES (20, \'Bachelor of Applied Geospatial and Information Technology\', \'Bachelor \\r\\n\\r\\nDegree\', \'156 weeks\')',
  267 => 'INSERT INTO `course_titles` VALUES (21, \'Bachelor of Applied Geospatial and Information Technology\\r\\n\\r\\n(Honours)\', \'Bachelor Degree\', \'52 weeks\')',
  268 => 'INSERT INTO `course_titles` VALUES (22, \'Bachelor of Applied Science (Disability Studies)\', \'Bachelor \\r\\n\\r\\nDegree\', \'156 weeks\')',
  269 => 'INSERT INTO `course_titles` VALUES (23, \'Bachelor of Applied Science (Disability Studies) Honours\', \'Bachelor \\r\\n\\r\\nDegree\', \'52 weeks\')',
  270 => 'INSERT INTO `course_titles` VALUES (24, \'Bachelor of Applied Science (Exercise & Sport Science) \\r\\n\\r\\nHonours\', \'Bachelor Degree\', \'52 weeks\')',
  271 => 'INSERT INTO `course_titles` VALUES (25, \'Bachelor of Applied Science (Exercise & Sport Science)/Bachelor of \\r\\n\\r\\nScience (Nutrition)\', \'Bachelor Degree\', \'260 weeks\')',
  272 => 'INSERT INTO `course_titles` VALUES (26, \'Bachelor of Applied Science (Exercise & Sport Science)/Master of \\r\\n\\r\\nNursing\', \'Bachelor Degree\', \'208 weeks\')',
  273 => 'INSERT INTO `course_titles` VALUES (27, \'Bachelor of Applied Science (Exercise and Sport Science)\', \'Bachelor \\r\\n\\r\\nDegree\', \'156 weeks\')',
  274 => 'INSERT INTO `course_titles` VALUES (28, \'Bachelor of Applied Science (Exercise Sport Science and \\r\\n\\r\\nNutrition)\', \'Bachelor Degree\', \'208 weeks\')',
  275 => 'INSERT INTO `course_titles` VALUES (29, \'Bachelor of Applied Science (Health Information \\r\\n\\r\\nManagement)\', \'Bachelor Degree\', \'208 weeks\')',
  276 => 'INSERT INTO `course_titles` VALUES (30, \'Bachelor of Applied Science (Health Information Management) \\r\\n\\r\\n(Honours)\', \'Bachelor Degree\', \'104 weeks\')',
  277 => 'INSERT INTO `course_titles` VALUES (31, \'Bachelor of Applied Science (Leisure & Health) Honours\', \'Bachelor \\r\\n\\r\\nDegree\', \'52 weeks\')',
  278 => 'INSERT INTO `course_titles` VALUES (32, \'Bachelor of Applied Science (Leisure and Health)\', \'Bachelor \\r\\n\\r\\nDegree\', \'156 weeks\')',
  279 => 'INSERT INTO `course_titles` VALUES (33, \'Bachelor of Applied Science (Medical Radiation Science) - Diagnostic \\r\\n\\r\\nRadiography\', \'Bachelor Degree\', \'156 weeks\')',
  280 => 'INSERT INTO `course_titles` VALUES (34, \'Bachelor of Applied Science (Medical Radiation Science) - Radiation \\r\\n\\r\\nTherapy\', \'Bachelor Degree\', \'156 weeks\')',
  281 => 'INSERT INTO `course_titles` VALUES (35, \'Bachelor of Applied Science (Medical Radiation Sciences) \\r\\n\\r\\n(Honours)\', \'Bachelor Degree\', \'104 weeks\')',
  282 => 'INSERT INTO `course_titles` VALUES (36, \'Bachelor of Applied Science (Medical Radiation Sciences) Nuc \\r\\n\\r\\nMed\', \'Bachelor Degree\', \'156 weeks\')',
  283 => 'INSERT INTO `course_titles` VALUES (37, \'Bachelor of Applied Science (Occupational Therapy) \\r\\n\\r\\n(Honours)\', \'Bachelor Degree\', \'104 weeks\')',
  284 => 'INSERT INTO `course_titles` VALUES (38, \'Bachelor of Applied Science (Occupational Therapy) 4 Yrs\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
  285 => 'INSERT INTO `course_titles` VALUES (39, \'Bachelor of Applied Science (Orthoptics) 4 yrs\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
  286 => 'INSERT INTO `course_titles` VALUES (40, \'Bachelor of Applied Science (Orthoptics) Honours\', \'Bachelor \\r\\n\\r\\nDegree\', \'104 weeks\')',
  287 => 'INSERT INTO `course_titles` VALUES (41, \'Bachelor of Applied Science (Physiotheraphy)\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
  288 => 'INSERT INTO `course_titles` VALUES (42, \'Bachelor of Applied Science (Physiotherapy) (Honours)\', \'Bachelor \\r\\n\\r\\nDegree\', \'104 weeks\')',
  289 => 'INSERT INTO `course_titles` VALUES (43, \'Bachelor of Applied Science (Speech Pathology)\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
  290 => 'INSERT INTO `course_titles` VALUES (44, \'Bachelor of Applied Science (Speech Pathology) (Honours)\', \'Bachelor \\r\\n\\r\\nDegree\', \'104 weeks\')',
  291 => 'INSERT INTO `course_titles` VALUES (45, \'Bachelor of Applied Science MRS ( Nuclear Medicine Technology) \\r\\n\\r\\nHonours\', \'Bachelor Degree\', \'208 weeks\')',
  292 => 'INSERT INTO `course_titles` VALUES (46, \'Bachelor of Applied Science MRS (Diagnostic Radiography)\', \'Bachelor \\r\\n\\r\\nDegree\', \'156 weeks\')',
  293 => 'INSERT INTO `course_titles` VALUES (47, \'Bachelor of Applied Science MRS (Diagnostic Radiography) \\r\\n\\r\\nHonours\', \'Bachelor Degree\', \'208 weeks\')',
  294 => 'INSERT INTO `course_titles` VALUES (48, \'Bachelor of Applied Science MRS (Nuclear Medicine \\r\\n\\r\\nTechnology)\', \'Bachelor Degree\', \'156 weeks\')',
  295 => 'INSERT INTO `course_titles` VALUES (49, \'Bachelor of Applied Science MRS(Radiation Therapy)\', \'Bachelor \\r\\n\\r\\nDegree\', \'156 weeks\')',
  296 => 'INSERT INTO `course_titles` VALUES (50, \'Bachelor of Applied Science MRS(Radiation Therapy) \\r\\n\\r\\nHonours\', \'Bachelor Degree\', \'208 weeks\')',
  297 => 'INSERT INTO `course_titles` VALUES (51, \'Bachelor of Archaeology\', \'Bachelor Degree\', \'156 weeks\')',
  298 => 'INSERT INTO `course_titles` VALUES (52, \'Bachelor of Archaeology (Honours)\', \'Bachelor Degree\', \'52 weeks\')',
  299 => 'INSERT INTO `course_titles` VALUES (53, \'Bachelor of Architecture\', \'Bachelor Degree\', \'286 weeks\')',
  300 => 'INSERT INTO `course_titles` VALUES (54, \'Bachelor of Architecture\', \'Bachelor Degree\', \'104 weeks\')',
  301 => 'INSERT INTO `course_titles` VALUES (55, \'Bachelor of Architecture / Bachelor of Law\', \'Bachelor Degree\', \'364 \\r\\n\\r\\nweeks\')',
  302 => 'INSERT INTO `course_titles` VALUES (56, \'Bachelor of Architecture/Bachelor of Arts\', \'Bachelor Degree\', \'312 \\r\\n\\r\\nweeks\')',
  303 => 'INSERT INTO `course_titles` VALUES (57, \'Bachelor of Architecture/Bachelor of Social Science\', \'Bachelor \\r\\n\\r\\nDegree\', \'312 weeks\')',
  304 => 'INSERT INTO `course_titles` VALUES (58, \'Bachelor of Art Education\', \'Bachelor Degree\', \'208 weeks\')',
  305 => 'INSERT INTO `course_titles` VALUES (59, \'Bachelor of Art Theory\', \'Bachelor Degree\', \'156 weeks\')',
  306 => 'INSERT INTO `course_titles` VALUES (60, \'Bachelor of Art Theory/Bachelor of Arts\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
  307 => 'INSERT INTO `course_titles` VALUES (61, \'Bachelor of Art Theory/Bachelor of Law\', \'Bachelor Degree\', \'260 \\r\\n\\r\\nweeks\')',
  308 => 'INSERT INTO `course_titles` VALUES (62, \'Bachelor of Art Theory/Bachelor of Social Science\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
  309 => 'INSERT INTO `course_titles` VALUES (63, \'Bachelor of Arts\', \'Bachelor Degree\', \'156 weeks\')',
  310 => 'INSERT INTO `course_titles` VALUES (64, \'Bachelor of Arts (Advanced)\', \'Bachelor Degree\', \'156 weeks\')',
  311 => 'INSERT INTO `course_titles` VALUES (65, \'Bachelor of Arts (Advanced) (Honours)\', \'Bachelor Degree\', \'156 \\r\\n\\r\\nweeks\')',
  312 => 'INSERT INTO `course_titles` VALUES (66, \'Bachelor of Arts (Advanced) (Honours) / Bachelor of Medicine and \\r\\n\\r\\nBachelor\', \'Bachelor Degree\', \'364 weeks\')',
  313 => 'INSERT INTO `course_titles` VALUES (67, \'Bachelor of Arts (Biblical Studies)\', \'Bachelor Degree\', \'156 weeks\')',
  314 => 'INSERT INTO `course_titles` VALUES (68, \'Bachelor of Arts (Christian Studies)\', \'Bachelor Degree\', \'156 \\r\\n\\r\\nweeks\')',
  315 => 'INSERT INTO `course_titles` VALUES (69, \'Bachelor of Arts (Dance)/Bachelor of Education\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
  316 => 'INSERT INTO `course_titles` VALUES (70, \'Bachelor of Arts (Digital Technology and Culture)\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
  317 => 'INSERT INTO `course_titles` VALUES (71, \'Bachelor of Arts (Honours)\', \'Bachelor Degree\', \'52 weeks\')',
  318 => 'INSERT INTO `course_titles` VALUES (72, \'Bachelor of Arts (Informatics)\', \'Bachelor Degree\', \'208 weeks\')',
  319 => 'INSERT INTO `course_titles` VALUES (73, \'Bachelor of Arts (Intercultural Ministry)\', \'Bachelor Degree\', \'156 \\r\\n\\r\\nweeks\')',
  320 => 'INSERT INTO `course_titles` VALUES (74, \'Bachelor of Arts (Languages)\', \'Bachelor Degree\', \'208 weeks\')',
  321 => 'INSERT INTO `course_titles` VALUES (75, \'Bachelor of Arts (Media & Communications)\', \'Bachelor Degree\', \'156 \\r\\n\\r\\nweeks\')',
  322 => 'INSERT INTO `course_titles` VALUES (76, \'Bachelor of Arts (Media and Communications)\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
  323 => 'INSERT INTO `course_titles` VALUES (77, \'Bachelor of Arts (Media and Communications) / LLB\', \'Bachelor \\r\\n\\r\\nDegree\', \'260 weeks\')',
  324 => 'INSERT INTO `course_titles` VALUES (78, \'Bachelor of Arts (Ministry)\', \'Bachelor Degree\', \'156 weeks\')',
  325 => 'INSERT INTO `course_titles` VALUES (79, \'Bachelor of Arts (Psychology)\', \'Bachelor Degree\', \'208 weeks\')',
  326 => 'INSERT INTO `course_titles` VALUES (80, \'Bachelor of Arts / Bachelor of Commerce\', \'Bachelor Degree\', \'260 \\r\\n\\r\\nweeks\')',
  327 => 'INSERT INTO `course_titles` VALUES (81, \'Bachelor of Arts / Bachelor of Laws\', \'Bachelor Degree\', \'260 weeks\')',
  328 => 'INSERT INTO `course_titles` VALUES (82, \'Bachelor of Arts / Bachelor of Music\', \'Bachelor Degree\', \'260 \\r\\n\\r\\nweeks\')',
  329 => 'INSERT INTO `course_titles` VALUES (83, \'Bachelor of Arts / Bachelor of Music Studies\', \'Bachelor Degree\', \'260 \\r\\n\\r\\nweeks\')',
  330 => 'INSERT INTO `course_titles` VALUES (84, \'Bachelor of Arts / Bachelor of Social Work\', \'Bachelor Degree\', \'260 \\r\\n\\r\\nweeks\')',
  331 => 'INSERT INTO `course_titles` VALUES (85, \'Bachelor of Arts / Bachelor of Theology\', \'Bachelor Degree\', \'260 \\r\\n\\r\\nweeks\')',
  332 => 'INSERT INTO `course_titles` VALUES (86, \'Bachelor of Arts / Science\', \'Bachelor Degree\', \'260 weeks\')',
  333 => 'INSERT INTO `course_titles` VALUES (87, \'Bachelor of Arts and Sciences\', \'Bachelor Degree\', \'156 weeks\')',
  334 => 'INSERT INTO `course_titles` VALUES (88, \'Bachelor of Arts Informatics (Honours)\', \'Bachelor Degree\', \'52 \\r\\n\\r\\nweeks\')',
  335 => 'INSERT INTO `course_titles` VALUES (89, \'Bachelor of Arts/Bachelor of Behavioural Science \\r\\n\\r\\n(Psychology)\', \'Bachelor Degree\', \'208 weeks\')',
  336 => 'INSERT INTO `course_titles` VALUES (90, \'Bachelor of Arts/Bachelor of Education\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
  337 => 'INSERT INTO `course_titles` VALUES (91, \'Bachelor of Arts/Bachelor of Law\', \'Bachelor Degree\', \'260 weeks\')',
  338 => 'INSERT INTO `course_titles` VALUES (92, \'Bachelor of Arts/Bachelor of Laws and Legal Practice\', \'Bachelor \\r\\n\\r\\nDegree\', \'286 weeks\')',
  339 => 'INSERT INTO `course_titles` VALUES (93, \'Bachelor of Arts/Master of Nursing\', \'Bachelor Degree\', \'208 weeks\')',
  340 => 'INSERT INTO `course_titles` VALUES (94, \'Bachelor of Aviation (Flying)\', \'Bachelor Degree\', \'156 weeks\')',
  341 => 'INSERT INTO `course_titles` VALUES (95, \'Bachelor of Aviation (Operations Management)\', \'Bachelor Degree\', \'156 \\r\\n\\r\\nweeks\')',
  342 => 'INSERT INTO `course_titles` VALUES (96, \'Bachelor of Banking and International Finance\', \'Bachelor \\r\\n\\r\\nDegree\', \'141 weeks\')',
  343 => 'INSERT INTO `course_titles` VALUES (97, \'Bachelor of Banking and International Finance (Honours)\', \'Bachelor \\r\\n\\r\\nDegree\', \'39 weeks\')',
  344 => 'INSERT INTO `course_titles` VALUES (98, \'Bachelor of Behavioural Health Science\', \'Bachelor Degree\', \'156 \\r\\n\\r\\nweeks\')',
  345 => 'INSERT INTO `course_titles` VALUES (99, \'Bachelor of Behavioural Science (Psychology)\', \'Bachelor Degree\', \'156 \\r\\n\\r\\nweeks\')',
  346 => 'INSERT INTO `course_titles` VALUES (100, \'Bachelor of Behavioural Science (Psychology) (Honours)\', \'Bachelor \\r\\n\\r\\nDegree\', \'52 weeks\')',
  347 => 'INSERT INTO `course_titles` VALUES (101, \'Bachelor of Behavioural Science/Bachelor of Laws\', \'Bachelor \\r\\n\\r\\nDegree\', \'260 weeks\')',
  348 => 'INSERT INTO `course_titles` VALUES (102, \'Bachelor of Behavioural Science/Bachelor of Laws and Legal \\r\\n\\r\\nPractice\', \'Bachelor Degree\', \'286 weeks\')',
  349 => 'INSERT INTO `course_titles` VALUES (103, \'Bachelor of Biotechnology (Honours)\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
  350 => 'INSERT INTO `course_titles` VALUES (104, \'Bachelor of Biotechnology Bachelor of Laws & Legal \\r\\n\\r\\nPractice\', \'Bachelor Degree\', \'312 weeks\')',
  351 => 'INSERT INTO `course_titles` VALUES (105, \'Bachelor of Biotechnology/Bachelor of Laws\', \'Bachelor Degree\', \'286 \\r\\n\\r\\nweeks\')',
  352 => 'INSERT INTO `course_titles` VALUES (106, \'Bachelor of Business\', \'Bachelor Degree\', \'156 weeks\')',
  353 => 'INSERT INTO `course_titles` VALUES (107, \'Bachelor of Business - Honours (Agric Commerce) Orange\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
  354 => 'INSERT INTO `course_titles` VALUES (108, \'Bachelor of Business & Economics (Honours)\', \'Bachelor Degree\', \'39 \\r\\n\\r\\nweeks\')',
  355 => 'INSERT INTO `course_titles` VALUES (109, \'Bachelor of Business (Agricultural Commerce)\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
  356 => 'INSERT INTO `course_titles` VALUES (110, \'Bachelor of Business and Economics\', \'Bachelor Degree\', \'141 weeks\')',
  357 => 'INSERT INTO `course_titles` VALUES (111, \'Bachelor of Business and Economics/Bachelor of Laws and Legal \\r\\n\\r\\nPractice\', \'Bachelor Degree\', \'276 weeks\')',
  358 => 'INSERT INTO `course_titles` VALUES (112, \'Bachelor of Business Economics and Government\', \'Bachelor \\r\\n\\r\\nDegree\', \'156 weeks\')',
  359 => 'INSERT INTO `course_titles` VALUES (113, \'Bachelor of Business/Bachelor of Arts\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
  360 => 'INSERT INTO `course_titles` VALUES (114, \'Bachelor of Business/Bachelor of Environmental \\r\\n\\r\\nManagement\', \'Bachelor Degree\', \'208 weeks\')',
  361 => 'INSERT INTO `course_titles` VALUES (115, \'Bachelor of Business/Bachelor of Government and Public Management \\r\\n\\r\\n\', \'Bachelor Degree\', \'208 weeks\')',
  362 => 'INSERT INTO `course_titles` VALUES (116, \'Bachelor of Business/Bachelor of Information Technology\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
  363 => 'INSERT INTO `course_titles` VALUES (117, \'Bachelor of Business/Bachelor of International Studies\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
  364 => 'INSERT INTO `course_titles` VALUES (118, \'Bachelor of Commerce\', \'Bachelor Degree\', \'156 weeks\')',
  365 => 'INSERT INTO `course_titles` VALUES (119, \'Bachelor of Commerce\', \'Bachelor Degree\', \'141 weeks\')',
  366 => 'INSERT INTO `course_titles` VALUES (120, \'Bachelor of Commerce (Accounting)\', \'Bachelor Degree\', \'156 weeks\')',
  367 => 'INSERT INTO `course_titles` VALUES (121, \'Bachelor of Commerce (Accounting)/Bachelor of Arts\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
  368 => 'INSERT INTO `course_titles` VALUES (122, \'Bachelor of Commerce (Accounting)/Bachelor of Environmental \\r\\n\\r\\nManagement\', \'Bachelor Degree\', \'208 weeks\')',
  369 => 'INSERT INTO `course_titles` VALUES (123, \'Bachelor of Commerce (Accounting)/Bachelor of Government and Public \\r\\n\\r\\nManagement\', \'Bachelor Degree\', \'208 weeks\')',
  370 => 'INSERT INTO `course_titles` VALUES (124, \'Bachelor of Commerce (Accounting)/Bachelor of Information \\r\\n\\r\\nTechnology\', \'Bachelor Degree\', \'208 weeks\')',
  371 => 'INSERT INTO `course_titles` VALUES (125, \'Bachelor of Commerce (Accounting)/Bachelor of International Studies \\r\\n\\r\\n\', \'Bachelor Degree\', \'208 weeks\')',
  372 => 'INSERT INTO `course_titles` VALUES (126, \'Bachelor of Commerce (Accounting)/Bachelor of Laws\', \'Bachelor \\r\\n\\r\\nDegree\', \'260 weeks\')',
  373 => 'INSERT INTO `course_titles` VALUES (127, \'Bachelor of Commerce (Accounting)/Bachelor of Laws and Legal \\r\\n\\r\\nPractice\', \'Bachelor Degree\', \'286 weeks\')',
  374 => 'INSERT INTO `course_titles` VALUES (128, \'Bachelor of Commerce (All Majors) / Bachelor of Law\', \'Bachelor \\r\\n\\r\\nDegree\', \'260 weeks\')',
  375 => 'INSERT INTO `course_titles` VALUES (129, \'Bachelor of Commerce (All specialisations)\', \'Bachelor Degree\', \'156 \\r\\n\\r\\nweeks\')',
  376 => 'INSERT INTO `course_titles` VALUES (130, \'Bachelor of Commerce (Finance)\', \'Bachelor Degree\', \'156 weeks\')',
  377 => 'INSERT INTO `course_titles` VALUES (131, \'Bachelor of Commerce (Finance)/Bachelor of Arts\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
  378 => 'INSERT INTO `course_titles` VALUES (132, \'Bachelor of Commerce (Finance)/Bachelor of Environmental Management \\r\\n\\r\\n\', \'Bachelor Degree\', \'208 weeks\')',
  379 => 'INSERT INTO `course_titles` VALUES (133, \'Bachelor of Commerce (Finance)/Bachelor of Government and Public \\r\\n\\r\\nManagement\', \'Bachelor Degree\', \'208 weeks\')',
  380 => 'INSERT INTO `course_titles` VALUES (134, \'Bachelor of Commerce (Finance)/Bachelor of Information \\r\\n\\r\\nTechnology\', \'Bachelor Degree\', \'208 weeks\')',
  381 => 'INSERT INTO `course_titles` VALUES (135, \'Bachelor of Commerce (Finance)/Bachelor of International Studies \\r\\n\\r\\n\', \'Bachelor Degree\', \'208 weeks\')',
  382 => 'INSERT INTO `course_titles` VALUES (136, \'Bachelor of Commerce (Finance)/Bachelor of Laws\', \'Bachelor \\r\\n\\r\\nDegree\', \'260 weeks\')',
  383 => 'INSERT INTO `course_titles` VALUES (137, \'Bachelor of Commerce (Finance)/Bachelor of Laws and Legal Practice \\r\\n\\r\\n\', \'Bachelor Degree\', \'286 weeks\')',
  384 => 'INSERT INTO `course_titles` VALUES (138, \'Bachelor of Commerce (Honours)\', \'Bachelor Degree\', \'39 weeks\')',
  385 => 'INSERT INTO `course_titles` VALUES (139, \'Bachelor of Commerce (International)\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
  386 => 'INSERT INTO `course_titles` VALUES (140, \'Bachelor of Commerce (Liberal Studies)\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
  387 => 'INSERT INTO `course_titles` VALUES (141, \'Bachelor of Commerce (Liberal Studies) Honours\', \'Bachelor \\r\\n\\r\\nDegree\', \'52 weeks\')',
  388 => 'INSERT INTO `course_titles` VALUES (142, \'Bachelor of Commerce and Bachelor of Arts\', \'Bachelor Degree\', \'260 \\r\\n\\r\\nweeks\')',
  389 => 'INSERT INTO `course_titles` VALUES (143, \'Bachelor of Commerce and Bachelor of Laws\', \'Bachelor Degree\', \'260 \\r\\n\\r\\nweeks\')',
  390 => 'INSERT INTO `course_titles` VALUES (144, \'Bachelor of Commerce and Bachelor of Science\', \'Bachelor \\r\\n\\r\\nDegree\', \'260 weeks\')',
  391 => 'INSERT INTO `course_titles` VALUES (145, \'Bachelor of Commerce Honours\', \'Bachelor Degree\', \'52 weeks\')',
  392 => 'INSERT INTO `course_titles` VALUES (146, \'Bachelor of Commerce in Services Marketing - Tourism and \\r\\n\\r\\nHospitality\', \'Bachelor Degree\', \'208 weeks\')',
  393 => 'INSERT INTO `course_titles` VALUES (147, \'Bachelor of Commerce(Accounting)/Bachelor of Health Sciences \\r\\n\\r\\n\', \'Bachelor Degree\', \'208 weeks\')',
  394 => 'INSERT INTO `course_titles` VALUES (148, \'Bachelor of Commerce/Bachelor of Arts\', \'Bachelor Degree\', \'260 \\r\\n\\r\\nweeks\')',
  395 => 'INSERT INTO `course_titles` VALUES (149, \'Bachelor of Commerce/Bachelor of Banking and International \\r\\n\\r\\nFinance\', \'Bachelor Degree\', \'192 weeks\')',
  396 => 'INSERT INTO `course_titles` VALUES (150, \'Bachelor of Commerce/Bachelor of Economics\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
  397 => 'INSERT INTO `course_titles` VALUES (151, \'Bachelor of Commerce/Bachelor of Environmental \\r\\n\\r\\nManagement\', \'Bachelor Degree\', \'192 weeks\')',
  398 => 'INSERT INTO `course_titles` VALUES (152, \'Bachelor of Commerce/Bachelor of International Studies\', \'Bachelor \\r\\n\\r\\nDegree\', \'192 weeks\')',
  399 => 'INSERT INTO `course_titles` VALUES (153, \'Bachelor of Commerce/Bachelor of Laws and Legal Practice\', \'Bachelor \\r\\n\\r\\nDegree\', \'276 weeks\')',
  400 => 'INSERT INTO `course_titles` VALUES (154, \'Bachelor of Commerce/Bachelor of Science\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
  401 => 'INSERT INTO `course_titles` VALUES (155, \'Bachelor of Commerce/Bachelor of Social Science\', \'Bachelor \\r\\n\\r\\nDegree\', \'260 weeks\')',
  402 => 'INSERT INTO `course_titles` VALUES (156, \'Bachelor of Communication and Information Technology\', \'Bachelor \\r\\n\\r\\nDegree\', \'104 weeks\')',
  403 => 'INSERT INTO `course_titles` VALUES (157, \'Bachelor of Computer Science\', \'Masters Degree (Coursework)\', \'104 \\r\\n\\r\\nweeks\')',
  404 => 'INSERT INTO `course_titles` VALUES (158, \'Bachelor of Computer Science & Technology (Advanced)\\r\\n\\r\\n(pass)\', \'Bachelor Degree\', \'156 weeks\')',
  405 => 'INSERT INTO `course_titles` VALUES (159, \'Bachelor of Computer Science & Technology (Honours)\', \'Bachelor \\r\\n\\r\\nDegree\', \'52 weeks\')',
  406 => 'INSERT INTO `course_titles` VALUES (160, \'Bachelor of Computer Science and Technology\', \'Bachelor Degree\', \'156 \\r\\n\\r\\nweeks\')',
  407 => 'INSERT INTO `course_titles` VALUES (161, \'Bachelor of Construction Management and Property\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
  408 => 'INSERT INTO `course_titles` VALUES (162, \'Bachelor of Creative Arts (Creative Writing)\', \'Bachelor \\r\\n\\r\\nDegree\', \'156 weeks\')',
  409 => 'INSERT INTO `course_titles` VALUES (163, \'Bachelor of Creative Arts (Digital Media)\', \'Bachelor Degree\', \'156 \\r\\n\\r\\nweeks\')',
  410 => 'INSERT INTO `course_titles` VALUES (164, \'Bachelor of Creative Arts (Drama)\', \'Bachelor Degree\', \'156 weeks\')',
  411 => 'INSERT INTO `course_titles` VALUES (165, \'Bachelor of Creative Arts (Honours) (Creative Writing)\', \'Bachelor \\r\\n\\r\\nDegree\', \'52 weeks\')',
  412 => 'INSERT INTO `course_titles` VALUES (166, \'Bachelor of Creative Arts (Honours) (Digital Media)\', \'Bachelor \\r\\n\\r\\nDegree\', \'52 weeks\')',
  413 => 'INSERT INTO `course_titles` VALUES (167, \'Bachelor of Creative Arts (Honours) (Screen Studies/Drama) \\r\\n\\r\\n\', \'Bachelor Degree\', \'52 weeks\')',
  414 => 'INSERT INTO `course_titles` VALUES (168, \'Bachelor of Creative Arts (Screen Studies)\', \'Bachelor Degree\', \'156 \\r\\n\\r\\nweeks\')',
  415 => 'INSERT INTO `course_titles` VALUES (169, \'Bachelor of Cultural Tourism\', \'Bachelor Degree\', \'156 weeks\')',
  416 => 'INSERT INTO `course_titles` VALUES (170, \'Bachelor of Dentistry\', \'Bachelor Degree\', \'208 weeks\')',
  417 => 'INSERT INTO `course_titles` VALUES (171, \'Bachelor of Design\', \'Bachelor Degree\', \'208 weeks\')',
  418 => 'INSERT INTO `course_titles` VALUES (172, \'Bachelor of Design\', \'Bachelor Degree\', \'156 weeks\')',
  419 => 'INSERT INTO `course_titles` VALUES (173, \'Bachelor of Design (Honours)\', \'Bachelor Degree\', \'52 weeks\')',
  420 => 'INSERT INTO `course_titles` VALUES (174, \'Bachelor of Design Computing\', \'Bachelor Degree\', \'156 weeks\')',
  421 => 'INSERT INTO `course_titles` VALUES (175, \'Bachelor of Design Computing (Honours)\', \'Bachelor Degree\', \'52 \\r\\n\\r\\nweeks\')',
  422 => 'INSERT INTO `course_titles` VALUES (176, \'Bachelor of Design in Architecture\', \'Bachelor Degree\', \'156 weeks\')',
  423 => 'INSERT INTO `course_titles` VALUES (177, \'Bachelor of Design in Architecture (Honours)\', \'Bachelor Degree\', \'52 \\r\\n\\r\\nweeks\')',
  424 => 'INSERT INTO `course_titles` VALUES (178, \'Bachelor of Design/Bachelor of Art Education\', \'Bachelor \\r\\n\\r\\nDegree\', \'260 weeks\')',
  425 => 'INSERT INTO `course_titles` VALUES (179, \'Bachelor of Digital Media\', \'Bachelor Degree\', \'208 weeks\')',
  426 => 'INSERT INTO `course_titles` VALUES (180, \'Bachelor of Disability and Community Rehabilitation\', \'Bachelor \\r\\n\\r\\nDegree\', \'192 weeks\')',
  427 => 'INSERT INTO `course_titles` VALUES (181, \'Bachelor of Economic and Social Science\', \'Bachelor Degree\', \'156 \\r\\n\\r\\nweeks\')',
  428 => 'INSERT INTO `course_titles` VALUES (182, \'Bachelor of Economics\', \'Bachelor Degree\', \'156 weeks\')',
  429 => 'INSERT INTO `course_titles` VALUES (183, \'Bachelor of Economics (All Majors)\', \'Bachelor Degree\', \'156 weeks\')',
  430 => 'INSERT INTO `course_titles` VALUES (184, \'Bachelor of Economics (Honours)\', \'Bachelor Degree\', \'52 weeks\')',
  431 => 'INSERT INTO `course_titles` VALUES (185, \'Bachelor of Economics (Liberal Stuides)\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
  432 => 'INSERT INTO `course_titles` VALUES (186, \'Bachelor of Economics (Social Sciences) / Bachelor of \\r\\n\\r\\nLaws\', \'Bachelor Degree\', \'260 weeks\')',
  433 => 'INSERT INTO `course_titles` VALUES (187, \'Bachelor of Economics (Social Sciences) Honours\', \'Bachelor \\r\\n\\r\\nDegree\', \'52 weeks\')',
  434 => 'INSERT INTO `course_titles` VALUES (188, \'Bachelor of Economics and Bachelor of Laws\', \'Bachelor Degree\', \'260 \\r\\n\\r\\nweeks\')',
  435 => 'INSERT INTO `course_titles` VALUES (189, \'Bachelor of Economics and Social Sciences (Honours)\', \'Bachelor \\r\\n\\r\\nDegree\', \'52 weeks\')',
  436 => 'INSERT INTO `course_titles` VALUES (190, \'Bachelor of Economics Honours\', \'Bachelor Degree\', \'52 weeks\')',
  437 => 'INSERT INTO `course_titles` VALUES (191, \'Bachelor of Economics/Bachelor of Arts\', \'Bachelor Degree\', \'260 \\r\\n\\r\\nweeks\')',
  438 => 'INSERT INTO `course_titles` VALUES (192, \'Bachelor of Economics/Bachelor of Law\', \'Bachelor Degree\', \'260 \\r\\n\\r\\nweeks\')',
  439 => 'INSERT INTO `course_titles` VALUES (193, \'Bachelor of Economics/Bachelor of Social Science\', \'Bachelor \\r\\n\\r\\nDegree\', \'260 weeks\')',
  440 => 'INSERT INTO `course_titles` VALUES (194, \'Bachelor of Ecotourism\', \'Bachelor Degree\', \'156 weeks\')',
  441 => 'INSERT INTO `course_titles` VALUES (195, \'Bachelor of Ecotourism (Honours)\', \'Bachelor Degree\', \'52 weeks\')',
  442 => 'INSERT INTO `course_titles` VALUES (196, \'Bachelor of Education\', \'Bachelor Degree\', \'208 weeks\')',
  443 => 'INSERT INTO `course_titles` VALUES (197, \'Bachelor of Education (Early Childhood) (Graduate Entry)\', \'Bachelor \\r\\n\\r\\nDegree\', \'104 weeks\')',
  444 => 'INSERT INTO `course_titles` VALUES (198, \'Bachelor of Education (Early Childhood)/Bachelor of Arts\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
  445 => 'INSERT INTO `course_titles` VALUES (199, \'Bachelor of Education (Honours)\', \'Bachelor Degree\', \'39 weeks\')',
  446 => 'INSERT INTO `course_titles` VALUES (200, \'Bachelor of Education (Junior Primary/Primary)\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
  447 => 'INSERT INTO `course_titles` VALUES (201, \'Bachelor of Education (Junior Primary/Primary) (Graduate Entry) \\r\\n\\r\\n\', \'Bachelor Degree\', \'104 weeks\')',
  448 => 'INSERT INTO `course_titles` VALUES (202, \'Bachelor of Education (Junior Primary/Primary)/Bachelor of \\r\\n\\r\\nArts\', \'Bachelor Degree\', \'208 weeks\')',
  449 => 'INSERT INTO `course_titles` VALUES (203, \'Bachelor of Education (Junior Primary/Primary)/Bachelor of \\r\\n\\r\\nScience\', \'Bachelor Degree\', \'208 weeks\')',
  450 => 'INSERT INTO `course_titles` VALUES (204, \'Bachelor of Education (Middle School)/Bachelor of Arts\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
  451 => 'INSERT INTO `course_titles` VALUES (205, \'Bachelor of Education (Middle School)/Bachelor of Health \\r\\n\\r\\nSciences\', \'Bachelor Degree\', \'208 weeks\')',
  452 => 'INSERT INTO `course_titles` VALUES (206, \'Bachelor of Education (Middle School)/Bachelor of \\r\\n\\r\\nScience\', \'Bachelor Degree\', \'208 weeks\')',
  453 => 'INSERT INTO `course_titles` VALUES (207, \'Bachelor of Education (Middle School)/Health Sciences\', \'Bachelor \\r\\n\\r\\nDegree\', \'192 weeks\')',
  454 => 'INSERT INTO `course_titles` VALUES (208, \'Bachelor of Education (Secondary Education:Humanities)/Bachelor of \\r\\n\\r\\nArts\', \'Bachelor Degree\', \'260 weeks\')',
  455 => 'INSERT INTO `course_titles` VALUES (209, \'Bachelor of Education (Secondary Education:Mathematics)/Bachelor of \\r\\n\\r\\nScience\', \'Bachelor Degree\', \'260 weeks\')',
  456 => 'INSERT INTO `course_titles` VALUES (210, \'Bachelor of Education (Secondary Education:Science)/Bachelor of \\r\\n\\r\\nScience\', \'Bachelor Degree\', \'260 weeks\')',
  457 => 'INSERT INTO `course_titles` VALUES (211, \'Bachelor of Education (Secondary Humanities) B Arts\', \'Bachelor \\r\\n\\r\\nDegree\', \'260 weeks\')',
  458 => 'INSERT INTO `course_titles` VALUES (212, \'Bachelor of Education (Secondary Mathematics) / Bachelor of \\r\\n\\r\\nScience\', \'Bachelor Degree\', \'260 weeks\')',
  459 => 'INSERT INTO `course_titles` VALUES (213, \'Bachelor of Education (Secondary Science)\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
  460 => 'INSERT INTO `course_titles` VALUES (214, \'Bachelor of Education (Secondary) (Graduate Entry)\', \'Masters \\r\\n\\r\\nDegree (Coursework)\', \'104 weeks\')',
  461 => 'INSERT INTO `course_titles` VALUES (215, \'Bachelor of Education (Secondary) / Bachelor of Economics (Social \\r\\n\\r\\nScience)\', \'Bachelor Degree\', \'260 weeks\')',
  462 => 'INSERT INTO `course_titles` VALUES (216, \'Bachelor of Education (Secondary) Human Movement and Health \\r\\n\\r\\nEducation\', \'Bachelor Degree\', \'208 weeks\')',
  463 => 'INSERT INTO `course_titles` VALUES (217, \'Bachelor of Education (Secondary)/Bachelor of Arts\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
  464 => 'INSERT INTO `course_titles` VALUES (218, \'Bachelor of Education (Secondary)/Bachelor of Health Sciences \\r\\n\\r\\n\', \'Bachelor Degree\', \'208 weeks\')',
  465 => 'INSERT INTO `course_titles` VALUES (219, \'Bachelor of Education (Secondary)/Bachelor of Science\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
  466 => 'INSERT INTO `course_titles` VALUES (220, \'Bachelor of Education (Secondary)/Health Sciences\', \'Bachelor \\r\\n\\r\\nDegree\', \'192 weeks\')',
  467 => 'INSERT INTO `course_titles` VALUES (221, \'Bachelor of Education (Secondary:Humanities & Social Sciences)\\r\\n\\r\\nBachelor of Arts\', \'Bachelor Degree\', \'260 weeks\')',
  468 => 'INSERT INTO `course_titles` VALUES (222, \'Bachelor of Education (Secondary:Science) / Bachelor of \\r\\n\\r\\nScience\', \'Bachelor Degree\', \'260 weeks\')',
  469 => 'INSERT INTO `course_titles` VALUES (223, \'Bachelor of Education (Special Education)\', \'Masters Degree \\r\\n\\r\\n(Coursework)\', \'104 weeks\')',
  470 => 'INSERT INTO `course_titles` VALUES (224, \'Bachelor of Education (Upper Primary/lower Secondary)\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
  471 => 'INSERT INTO `course_titles` VALUES (225, \'Bachelor of Engineering\', \'Bachelor Degree\', \'208 weeks\')',
  472 => 'INSERT INTO `course_titles` VALUES (226, \'Bachelor of Engineering - Aerospace Engineering\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
  473 => 'INSERT INTO `course_titles` VALUES (227, \'Bachelor of Engineering - Aerospace Engineering/Bachelor of \\r\\n\\r\\nArts\', \'Bachelor Degree\', \'260 weeks\')',
  474 => 'INSERT INTO `course_titles` VALUES (228, \'Bachelor of Engineering - Aerospace Engineering/Bachelor of \\r\\n\\r\\nScience\', \'Bachelor Degree\', \'260 weeks\')',
  475 => 'INSERT INTO `course_titles` VALUES (229, \'Bachelor of Engineering - Bioinformatics\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
  476 => 'INSERT INTO `course_titles` VALUES (230, \'Bachelor of Engineering - Bioinformatics/Bachelor of \\r\\n\\r\\nArts\', \'Bachelor Degree\', \'260 weeks\')',
  477 => 'INSERT INTO `course_titles` VALUES (231, \'Bachelor of Engineering - Bioinformatics/Bachelor of \\r\\n\\r\\nScience\', \'Bachelor Degree\', \'260 weeks\')',
  478 => 'INSERT INTO `course_titles` VALUES (232, \'Bachelor of Engineering - Ceramic Engineering\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
  479 => 'INSERT INTO `course_titles` VALUES (233, \'Bachelor of Engineering - Chemical Engineering\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
  480 => 'INSERT INTO `course_titles` VALUES (234, \'Bachelor of Engineering - Chemical Engineering/ Master of \\r\\n\\r\\nCommerce\', \'Bachelor Degree\', \'260 weeks\')',
  481 => 'INSERT INTO `course_titles` VALUES (235, \'Bachelor of Engineering - Chemical Engineering/Bachelor of \\r\\n\\r\\nArts\', \'Bachelor Degree\', \'260 weeks\')',
  482 => 'INSERT INTO `course_titles` VALUES (236, \'Bachelor of Engineering - Chemical Engineering/Bachelor of Science \\r\\n\\r\\n- Computer Science\', \'Bachelor Degree\', \'260 weeks\')',
  483 => 'INSERT INTO `course_titles` VALUES (237, \'Bachelor of Engineering - Chemical Engineering/Master of Biomedical \\r\\n\\r\\nEngineering\', \'Masters Degree (Coursework)\', \'260 weeks\')',
  484 => 'INSERT INTO `course_titles` VALUES (238, \'Bachelor of Engineering - Civil Engineering\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
  485 => 'INSERT INTO `course_titles` VALUES (239, \'Bachelor of Engineering - Civil Engineering / Bachelor of \\r\\n\\r\\nEngineering - Mining Engineering\', \'Bachelor Degree\', \'260 weeks\')',
  486 => 'INSERT INTO `course_titles` VALUES (240, \'Bachelor of Engineering - Civil Engineering/Bachelor of \\r\\n\\r\\nArts\', \'Bachelor Degree\', \'260 weeks\')',
  487 => 'INSERT INTO `course_titles` VALUES (241, \'Bachelor of Engineering - Civil Engineering/Bachelor of Engineering \\r\\n\\r\\n- Environmental Engineering\', \'Bachelor Degree\', \'260 weeks\')',
  488 => 'INSERT INTO `course_titles` VALUES (242, \'Bachelor of Engineering - Civil Engineering/Bachelor of \\r\\n\\r\\nLaw\', \'Bachelor Degree\', \'312 weeks\')',
  489 => 'INSERT INTO `course_titles` VALUES (243, \'Bachelor of Engineering - Civil Engineering/Bachelor of \\r\\n\\r\\nScience\', \'Bachelor Degree\', \'260 weeks\')',
  490 => 'INSERT INTO `course_titles` VALUES (244, \'Bachelor of Engineering - Computer Engineering\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
  491 => 'INSERT INTO `course_titles` VALUES (245, \'Bachelor of Engineering - Computer Engineering / Bachelor of \\r\\n\\r\\nArts\', \'Bachelor Degree\', \'260 weeks\')',
  492 => 'INSERT INTO `course_titles` VALUES (246, \'Bachelor of Engineering - Computer Engineering / Bachelor of \\r\\n\\r\\nScience\', \'Bachelor Degree\', \'260 weeks\')',
  493 => 'INSERT INTO `course_titles` VALUES (247, \'Bachelor of Engineering - Computer Engineering / Master of \\r\\n\\r\\nBiomedical Engineering\', \'Masters Degree (Coursework)\', \'260 weeks\')',
  494 => 'INSERT INTO `course_titles` VALUES (248, \'Bachelor of Engineering - Electrical Engineering\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
  495 => 'INSERT INTO `c
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

That's not a MySQL dump file.

What have you attempted so far to make this "search?"
User avatar
Ollie Saunders
DevNet Master
Posts: 3179
Joined: Tue May 24, 2005 6:01 pm
Location: UK

Post by Ollie Saunders »

Try a

Code: Select all

SELECT * FROM `tableName` WHERE `field` LIKE '$value' ...
Post Reply