Today I needed made a multiple select, more than one SELECT command in the same table, but the result should comes together and I also needed apply one condition for ORDER in all result.
Firstly I tried read if CakePHP has supports for it, but CakePHP doesn’t has, so I pass to try a MySQL query solution for that, and that solution is the command UNION.
For example:
Table people
id
name
age
If for example we want show 30 person with age equal 20 and more 20 with the age equal 10.
With the union condition this is simple.
1 2 3 | (SELECT * FROM people WHERE age=20 LIMIT 30) UNION (SELECT * FROM people WHERE age=10 LIMIT 20); |
So how you can check, it’s pretty simple, make your two queries and apply the command UNION, if you want to apply one order or another thing in the result you should put it in the end
1 2 3 4 | (SELECT * FROM people WHERE age=20 LIMIT 30) UNION (SELECT * FROM people WHERE age=10 LIMIT 20) ORDER BY name ASC; |
Worth remembering, the fields that result will come should be equal, this in the case that you are not using the same table, but two tables distinct with different fields between these.
In the case of CakePHP framework, apply the query method of your model for example:
1 2 3 4 5 | $nodes = $this->Node->query(' (SELECT Node.* FROM nodes AS Node WHERE type=3 ORDER BY date DESC LIMIT 30) UNION (SELECT Node.* FROM nodes AS Node WHERE type!=3 ORDER BY date DESC LIMIT 200) ORDER BY date DESC;'); |
Hoje postei no ar um experimento(projeto) o Xavante na Web, para testar algumas tecnologias são elas HTML5, CSS3, Jquery e o phpQuery, junto com a integração de algumas API’s, hoje 09.08 de agosto a do twitter já está no ar, e a do Flickr e Youtube, virão em seguida visto que as duas já foram codificadas bastando o cacheamento das mesmas.
Para o mesmo foi gasto 3 horas de desenvolvimento, mais 1 hora de acertos que com sua publicação ficou beirando as 5 horas, usando PHP 5.2, MySQL 5 e CakePHP 1.3.
O Xavante na Web, nada mais é que um agregador de notícias, assuntos, imagens vídeos relacionados ao Grêmio Esportivo Brasil, meu time de coração!
Pretendo nele ir aplicando novas técnicas, e por em prática HTML5 e CSS3 que venho estudando, para o mesmo criei uma Classe PHP para fazer a parte de Crawler, que após eu ter uma suite de teste dela pretendo publicar por aqui, por hora é isso.
More than one time I needed looking for a list of all countries in SQL to use in CakePHP projects, so this time that I need once more I resolved create that post to share the SQL adapted with the CakePHP rules. The SQL with the list of countries I got from that site.
Get the SQL file here or copy the code below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 | CREATE TABLE `countries` ( `id` int(11) NOT NULL AUTO_INCREMENT, `iso` char(2) NOT NULL, `name` varchar(80) NOT NULL, `printable_name` varchar(80) NOT NULL, `iso3` char(3) DEFAULT NULL, `numcode` smallint(6) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=240 DEFAULT CHARSET=utf8; INSERT INTO countries VALUES (NULL, 'AF','AFGHANISTAN','Afghanistan','AFG','004'); INSERT INTO countries VALUES (NULL, 'AL','ALBANIA','Albania','ALB','008'); INSERT INTO countries VALUES (NULL, 'DZ','ALGERIA','Algeria','DZA','012'); INSERT INTO countries VALUES (NULL, 'AS','AMERICAN SAMOA','American Samoa','ASM','016'); INSERT INTO countries VALUES (NULL, 'AD','ANDORRA','Andorra','AND','020'); INSERT INTO countries VALUES (NULL, 'AO','ANGOLA','Angola','AGO','024'); INSERT INTO countries VALUES (NULL, 'AI','ANGUILLA','Anguilla','AIA','660'); INSERT INTO countries VALUES (NULL, 'AQ','ANTARCTICA','Antarctica',NULL,NULL); INSERT INTO countries VALUES (NULL, 'AG','ANTIGUA AND BARBUDA','Antigua and Barbuda','ATG','028'); INSERT INTO countries VALUES (NULL, 'AR','ARGENTINA','Argentina','ARG','032'); INSERT INTO countries VALUES (NULL, 'AM','ARMENIA','Armenia','ARM','051'); INSERT INTO countries VALUES (NULL, 'AW','ARUBA','Aruba','ABW','533'); INSERT INTO countries VALUES (NULL, 'AU','AUSTRALIA','Australia','AUS','036'); INSERT INTO countries VALUES (NULL, 'AT','AUSTRIA','Austria','AUT','040'); INSERT INTO countries VALUES (NULL, 'AZ','AZERBAIJAN','Azerbaijan','AZE','031'); INSERT INTO countries VALUES (NULL, 'BS','BAHAMAS','Bahamas','BHS','044'); INSERT INTO countries VALUES (NULL, 'BH','BAHRAIN','Bahrain','BHR','048'); INSERT INTO countries VALUES (NULL, 'BD','BANGLADESH','Bangladesh','BGD','050'); INSERT INTO countries VALUES (NULL, 'BB','BARBADOS','Barbados','BRB','052'); INSERT INTO countries VALUES (NULL, 'BY','BELARUS','Belarus','BLR','112'); INSERT INTO countries VALUES (NULL, 'BE','BELGIUM','Belgium','BEL','056'); INSERT INTO countries VALUES (NULL, 'BZ','BELIZE','Belize','BLZ','084'); INSERT INTO countries VALUES (NULL, 'BJ','BENIN','Benin','BEN','204'); INSERT INTO countries VALUES (NULL, 'BM','BERMUDA','Bermuda','BMU','060'); INSERT INTO countries VALUES (NULL, 'BT','BHUTAN','Bhutan','BTN','064'); INSERT INTO countries VALUES (NULL, 'BO','BOLIVIA','Bolivia','BOL','068'); INSERT INTO countries VALUES (NULL, 'BA','BOSNIA AND HERZEGOVINA','Bosnia and Herzegovina','BIH','070'); INSERT INTO countries VALUES (NULL, 'BW','BOTSWANA','Botswana','BWA','072'); INSERT INTO countries VALUES (NULL, 'BV','BOUVET ISLAND','Bouvet Island',NULL,NULL); INSERT INTO countries VALUES (NULL, 'BR','BRAZIL','Brazil','BRA','076'); INSERT INTO countries VALUES (NULL, 'IO','BRITISH INDIAN OCEAN TERRITORY','British Indian Ocean Territory',NULL,NULL); INSERT INTO countries VALUES (NULL, 'BN','BRUNEI DARUSSALAM','Brunei Darussalam','BRN','096'); INSERT INTO countries VALUES (NULL, 'BG','BULGARIA','Bulgaria','BGR','100'); INSERT INTO countries VALUES (NULL, 'BF','BURKINA FASO','Burkina Faso','BFA','854'); INSERT INTO countries VALUES (NULL, 'BI','BURUNDI','Burundi','BDI','108'); INSERT INTO countries VALUES (NULL, 'KH','CAMBODIA','Cambodia','KHM','116'); INSERT INTO countries VALUES (NULL, 'CM','CAMEROON','Cameroon','CMR','120'); INSERT INTO countries VALUES (NULL, 'CA','CANADA','Canada','CAN','124'); INSERT INTO countries VALUES (NULL, 'CV','CAPE VERDE','Cape Verde','CPV','132'); INSERT INTO countries VALUES (NULL, 'KY','CAYMAN ISLANDS','Cayman Islands','CYM','136'); INSERT INTO countries VALUES (NULL, 'CF','CENTRAL AFRICAN REPUBLIC','Central African Republic','CAF','140'); INSERT INTO countries VALUES (NULL, 'TD','CHAD','Chad','TCD','148'); INSERT INTO countries VALUES (NULL, 'CL','CHILE','Chile','CHL','152'); INSERT INTO countries VALUES (NULL, 'CN','CHINA','China','CHN','156'); INSERT INTO countries VALUES (NULL, 'CX','CHRISTMAS ISLAND','Christmas Island',NULL,NULL); INSERT INTO countries VALUES (NULL, 'CC','COCOS (KEELING) ISLANDS','Cocos (Keeling) Islands',NULL,NULL); INSERT INTO countries VALUES (NULL, 'CO','COLOMBIA','Colombia','COL','170'); INSERT INTO countries VALUES (NULL, 'KM','COMOROS','Comoros','COM','174'); INSERT INTO countries VALUES (NULL, 'CG','CONGO','Congo','COG','178'); INSERT INTO countries VALUES (NULL, 'CD','CONGO, THE DEMOCRATIC REPUBLIC OF THE','Congo, the Democratic Republic of the','COD','180'); INSERT INTO countries VALUES (NULL, 'CK','COOK ISLANDS','Cook Islands','COK','184'); INSERT INTO countries VALUES (NULL, 'CR','COSTA RICA','Costa Rica','CRI','188'); INSERT INTO countries VALUES (NULL, 'CI','COTE D\'IVOIRE','Cote D\'Ivoire','CIV','384'); INSERT INTO countries VALUES (NULL, 'HR','CROATIA','Croatia','HRV','191'); INSERT INTO countries VALUES (NULL, 'CU','CUBA','Cuba','CUB','192'); INSERT INTO countries VALUES (NULL, 'CY','CYPRUS','Cyprus','CYP','196'); INSERT INTO countries VALUES (NULL, 'CZ','CZECH REPUBLIC','Czech Republic','CZE','203'); INSERT INTO countries VALUES (NULL, 'DK','DENMARK','Denmark','DNK','208'); INSERT INTO countries VALUES (NULL, 'DJ','DJIBOUTI','Djibouti','DJI','262'); INSERT INTO countries VALUES (NULL, 'DM','DOMINICA','Dominica','DMA','212'); INSERT INTO countries VALUES (NULL, 'DO','DOMINICAN REPUBLIC','Dominican Republic','DOM','214'); INSERT INTO countries VALUES (NULL, 'EC','ECUADOR','Ecuador','ECU','218'); INSERT INTO countries VALUES (NULL, 'EG','EGYPT','Egypt','EGY','818'); INSERT INTO countries VALUES (NULL, 'SV','EL SALVADOR','El Salvador','SLV','222'); INSERT INTO countries VALUES (NULL, 'GQ','EQUATORIAL GUINEA','Equatorial Guinea','GNQ','226'); INSERT INTO countries VALUES (NULL, 'ER','ERITREA','Eritrea','ERI','232'); INSERT INTO countries VALUES (NULL, 'EE','ESTONIA','Estonia','EST','233'); INSERT INTO countries VALUES (NULL, 'ET','ETHIOPIA','Ethiopia','ETH','231'); INSERT INTO countries VALUES (NULL, 'FK','FALKLAND ISLANDS (MALVINAS)','Falkland Islands (Malvinas)','FLK','238'); INSERT INTO countries VALUES (NULL, 'FO','FAROE ISLANDS','Faroe Islands','FRO','234'); INSERT INTO countries VALUES (NULL, 'FJ','FIJI','Fiji','FJI','242'); INSERT INTO countries VALUES (NULL, 'FI','FINLAND','Finland','FIN','246'); INSERT INTO countries VALUES (NULL, 'FR','FRANCE','France','FRA','250'); INSERT INTO countries VALUES (NULL, 'GF','FRENCH GUIANA','French Guiana','GUF','254'); INSERT INTO countries VALUES (NULL, 'PF','FRENCH POLYNESIA','French Polynesia','PYF','258'); INSERT INTO countries VALUES (NULL, 'TF','FRENCH SOUTHERN TERRITORIES','French Southern Territories',NULL,NULL); INSERT INTO countries VALUES (NULL, 'GA','GABON','Gabon','GAB','266'); INSERT INTO countries VALUES (NULL, 'GM','GAMBIA','Gambia','GMB','270'); INSERT INTO countries VALUES (NULL, 'GE','GEORGIA','Georgia','GEO','268'); INSERT INTO countries VALUES (NULL, 'DE','GERMANY','Germany','DEU','276'); INSERT INTO countries VALUES (NULL, 'GH','GHANA','Ghana','GHA','288'); INSERT INTO countries VALUES (NULL, 'GI','GIBRALTAR','Gibraltar','GIB','292'); INSERT INTO countries VALUES (NULL, 'GR','GREECE','Greece','GRC','300'); INSERT INTO countries VALUES (NULL, 'GL','GREENLAND','Greenland','GRL','304'); INSERT INTO countries VALUES (NULL, 'GD','GRENADA','Grenada','GRD','308'); INSERT INTO countries VALUES (NULL, 'GP','GUADELOUPE','Guadeloupe','GLP','312'); INSERT INTO countries VALUES (NULL, 'GU','GUAM','Guam','GUM','316'); INSERT INTO countries VALUES (NULL, 'GT','GUATEMALA','Guatemala','GTM','320'); INSERT INTO countries VALUES (NULL, 'GN','GUINEA','Guinea','GIN','324'); INSERT INTO countries VALUES (NULL, 'GW','GUINEA-BISSAU','Guinea-Bissau','GNB','624'); INSERT INTO countries VALUES (NULL, 'GY','GUYANA','Guyana','GUY','328'); INSERT INTO countries VALUES (NULL, 'HT','HAITI','Haiti','HTI','332'); INSERT INTO countries VALUES (NULL, 'HM','HEARD ISLAND AND MCDONALD ISLANDS','Heard Island and Mcdonald Islands',NULL,NULL); INSERT INTO countries VALUES (NULL, 'VA','HOLY SEE (VATICAN CITY STATE)','Holy See (Vatican City State)','VAT','336'); INSERT INTO countries VALUES (NULL, 'HN','HONDURAS','Honduras','HND','340'); INSERT INTO countries VALUES (NULL, 'HK','HONG KONG','Hong Kong','HKG','344'); INSERT INTO countries VALUES (NULL, 'HU','HUNGARY','Hungary','HUN','348'); INSERT INTO countries VALUES (NULL, 'IS','ICELAND','Iceland','ISL','352'); INSERT INTO countries VALUES (NULL, 'IN','INDIA','India','IND','356'); INSERT INTO countries VALUES (NULL, 'ID','INDONESIA','Indonesia','IDN','360'); INSERT INTO countries VALUES (NULL, 'IR','IRAN, ISLAMIC REPUBLIC OF','Iran, Islamic Republic of','IRN','364'); INSERT INTO countries VALUES (NULL, 'IQ','IRAQ','Iraq','IRQ','368'); INSERT INTO countries VALUES (NULL, 'IE','IRELAND','Ireland','IRL','372'); INSERT INTO countries VALUES (NULL, 'IL','ISRAEL','Israel','ISR','376'); INSERT INTO countries VALUES (NULL, 'IT','ITALY','Italy','ITA','380'); INSERT INTO countries VALUES (NULL, 'JM','JAMAICA','Jamaica','JAM','388'); INSERT INTO countries VALUES (NULL, 'JP','JAPAN','Japan','JPN','392'); INSERT INTO countries VALUES (NULL, 'JO','JORDAN','Jordan','JOR','400'); INSERT INTO countries VALUES (NULL, 'KZ','KAZAKHSTAN','Kazakhstan','KAZ','398'); INSERT INTO countries VALUES (NULL, 'KE','KENYA','Kenya','KEN','404'); INSERT INTO countries VALUES (NULL, 'KI','KIRIBATI','Kiribati','KIR','296'); INSERT INTO countries VALUES (NULL, 'KP','KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF','Korea, Democratic People\'s Republic of','PRK','408'); INSERT INTO countries VALUES (NULL, 'KR','KOREA, REPUBLIC OF','Korea, Republic of','KOR','410'); INSERT INTO countries VALUES (NULL, 'KW','KUWAIT','Kuwait','KWT','414'); INSERT INTO countries VALUES (NULL, 'KG','KYRGYZSTAN','Kyrgyzstan','KGZ','417'); INSERT INTO countries VALUES (NULL, 'LA','LAO PEOPLE\'S DEMOCRATIC REPUBLIC','Lao People\'s Democratic Republic','LAO','418'); INSERT INTO countries VALUES (NULL, 'LV','LATVIA','Latvia','LVA','428'); INSERT INTO countries VALUES (NULL, 'LB','LEBANON','Lebanon','LBN','422'); INSERT INTO countries VALUES (NULL, 'LS','LESOTHO','Lesotho','LSO','426'); INSERT INTO countries VALUES (NULL, 'LR','LIBERIA','Liberia','LBR','430'); INSERT INTO countries VALUES (NULL, 'LY','LIBYAN ARAB JAMAHIRIYA','Libyan Arab Jamahiriya','LBY','434'); INSERT INTO countries VALUES (NULL, 'LI','LIECHTENSTEIN','Liechtenstein','LIE','438'); INSERT INTO countries VALUES (NULL, 'LT','LITHUANIA','Lithuania','LTU','440'); INSERT INTO countries VALUES (NULL, 'LU','LUXEMBOURG','Luxembourg','LUX','442'); INSERT INTO countries VALUES (NULL, 'MO','MACAO','Macao','MAC','446'); INSERT INTO countries VALUES (NULL, 'MK','MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF','Macedonia, the Former Yugoslav Republic of','MKD','807'); INSERT INTO countries VALUES (NULL, 'MG','MADAGASCAR','Madagascar','MDG','450'); INSERT INTO countries VALUES (NULL, 'MW','MALAWI','Malawi','MWI','454'); INSERT INTO countries VALUES (NULL, 'MY','MALAYSIA','Malaysia','MYS','458'); INSERT INTO countries VALUES (NULL, 'MV','MALDIVES','Maldives','MDV','462'); INSERT INTO countries VALUES (NULL, 'ML','MALI','Mali','MLI','466'); INSERT INTO countries VALUES (NULL, 'MT','MALTA','Malta','MLT','470'); INSERT INTO countries VALUES (NULL, 'MH','MARSHALL ISLANDS','Marshall Islands','MHL','584'); INSERT INTO countries VALUES (NULL, 'MQ','MARTINIQUE','Martinique','MTQ','474'); INSERT INTO countries VALUES (NULL, 'MR','MAURITANIA','Mauritania','MRT','478'); INSERT INTO countries VALUES (NULL, 'MU','MAURITIUS','Mauritius','MUS','480'); INSERT INTO countries VALUES (NULL, 'YT','MAYOTTE','Mayotte',NULL,NULL); INSERT INTO countries VALUES (NULL, 'MX','MEXICO','Mexico','MEX','484'); INSERT INTO countries VALUES (NULL, 'FM','MICRONESIA, FEDERATED STATES OF','Micronesia, Federated States of','FSM','583'); INSERT INTO countries VALUES (NULL, 'MD','MOLDOVA, REPUBLIC OF','Moldova, Republic of','MDA','498'); INSERT INTO countries VALUES (NULL, 'MC','MONACO','Monaco','MCO','492'); INSERT INTO countries VALUES (NULL, 'MN','MONGOLIA','Mongolia','MNG','496'); INSERT INTO countries VALUES (NULL, 'MS','MONTSERRAT','Montserrat','MSR','500'); INSERT INTO countries VALUES (NULL, 'MA','MOROCCO','Morocco','MAR','504'); INSERT INTO countries VALUES (NULL, 'MZ','MOZAMBIQUE','Mozambique','MOZ','508'); INSERT INTO countries VALUES (NULL, 'MM','MYANMAR','Myanmar','MMR','104'); INSERT INTO countries VALUES (NULL, 'NA','NAMIBIA','Namibia','NAM','516'); INSERT INTO countries VALUES (NULL, 'NR','NAURU','Nauru','NRU','520'); INSERT INTO countries VALUES (NULL, 'NP','NEPAL','Nepal','NPL','524'); INSERT INTO countries VALUES (NULL, 'NL','NETHERLANDS','Netherlands','NLD','528'); INSERT INTO countries VALUES (NULL, 'AN','NETHERLANDS ANTILLES','Netherlands Antilles','ANT','530'); INSERT INTO countries VALUES (NULL, 'NC','NEW CALEDONIA','New Caledonia','NCL','540'); INSERT INTO countries VALUES (NULL, 'NZ','NEW ZEALAND','New Zealand','NZL','554'); INSERT INTO countries VALUES (NULL, 'NI','NICARAGUA','Nicaragua','NIC','558'); INSERT INTO countries VALUES (NULL, 'NE','NIGER','Niger','NER','562'); INSERT INTO countries VALUES (NULL, 'NG','NIGERIA','Nigeria','NGA','566'); INSERT INTO countries VALUES (NULL, 'NU','NIUE','Niue','NIU','570'); INSERT INTO countries VALUES (NULL, 'NF','NORFOLK ISLAND','Norfolk Island','NFK','574'); INSERT INTO countries VALUES (NULL, 'MP','NORTHERN MARIANA ISLANDS','Northern Mariana Islands','MNP','580'); INSERT INTO countries VALUES (NULL, 'NO','NORWAY','Norway','NOR','578'); INSERT INTO countries VALUES (NULL, 'OM','OMAN','Oman','OMN','512'); INSERT INTO countries VALUES (NULL, 'PK','PAKISTAN','Pakistan','PAK','586'); INSERT INTO countries VALUES (NULL, 'PW','PALAU','Palau','PLW','585'); INSERT INTO countries VALUES (NULL, 'PS','PALESTINIAN TERRITORY, OCCUPIED','Palestinian Territory, Occupied',NULL,NULL); INSERT INTO countries VALUES (NULL, 'PA','PANAMA','Panama','PAN','591'); INSERT INTO countries VALUES (NULL, 'PG','PAPUA NEW GUINEA','Papua New Guinea','PNG','598'); INSERT INTO countries VALUES (NULL, 'PY','PARAGUAY','Paraguay','PRY','600'); INSERT INTO countries VALUES (NULL, 'PE','PERU','Peru','PER','604'); INSERT INTO countries VALUES (NULL, 'PH','PHILIPPINES','Philippines','PHL','608'); INSERT INTO countries VALUES (NULL, 'PN','PITCAIRN','Pitcairn','PCN','612'); INSERT INTO countries VALUES (NULL, 'PL','POLAND','Poland','POL','616'); INSERT INTO countries VALUES (NULL, 'PT','PORTUGAL','Portugal','PRT','620'); INSERT INTO countries VALUES (NULL, 'PR','PUERTO RICO','Puerto Rico','PRI','630'); INSERT INTO countries VALUES (NULL, 'QA','QATAR','Qatar','QAT','634'); INSERT INTO countries VALUES (NULL, 'RE','REUNION','Reunion','REU','638'); INSERT INTO countries VALUES (NULL, 'RO','ROMANIA','Romania','ROM','642'); INSERT INTO countries VALUES (NULL, 'RU','RUSSIAN FEDERATION','Russian Federation','RUS','643'); INSERT INTO countries VALUES (NULL, 'RW','RWANDA','Rwanda','RWA','646'); INSERT INTO countries VALUES (NULL, 'SH','SAINT HELENA','Saint Helena','SHN','654'); INSERT INTO countries VALUES (NULL, 'KN','SAINT KITTS AND NEVIS','Saint Kitts and Nevis','KNA','659'); INSERT INTO countries VALUES (NULL, 'LC','SAINT LUCIA','Saint Lucia','LCA','662'); INSERT INTO countries VALUES (NULL, 'PM','SAINT PIERRE AND MIQUELON','Saint Pierre and Miquelon','SPM','666'); INSERT INTO countries VALUES (NULL, 'VC','SAINT VINCENT AND THE GRENADINES','Saint Vincent and the Grenadines','VCT','670'); INSERT INTO countries VALUES (NULL, 'WS','SAMOA','Samoa','WSM','882'); INSERT INTO countries VALUES (NULL, 'SM','SAN MARINO','San Marino','SMR','674'); INSERT INTO countries VALUES (NULL, 'ST','SAO TOME AND PRINCIPE','Sao Tome and Principe','STP','678'); INSERT INTO countries VALUES (NULL, 'SA','SAUDI ARABIA','Saudi Arabia','SAU','682'); INSERT INTO countries VALUES (NULL, 'SN','SENEGAL','Senegal','SEN','686'); INSERT INTO countries VALUES (NULL, 'CS','SERBIA AND MONTENEGRO','Serbia and Montenegro',NULL,NULL); INSERT INTO countries VALUES (NULL, 'SC','SEYCHELLES','Seychelles','SYC','690'); INSERT INTO countries VALUES (NULL, 'SL','SIERRA LEONE','Sierra Leone','SLE','694'); INSERT INTO countries VALUES (NULL, 'SG','SINGAPORE','Singapore','SGP','702'); INSERT INTO countries VALUES (NULL, 'SK','SLOVAKIA','Slovakia','SVK','703'); INSERT INTO countries VALUES (NULL, 'SI','SLOVENIA','Slovenia','SVN','705'); INSERT INTO countries VALUES (NULL, 'SB','SOLOMON ISLANDS','Solomon Islands','SLB','090'); INSERT INTO countries VALUES (NULL, 'SO','SOMALIA','Somalia','SOM','706'); INSERT INTO countries VALUES (NULL, 'ZA','SOUTH AFRICA','South Africa','ZAF','710'); INSERT INTO countries VALUES (NULL, 'GS','SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS','South Georgia and the South Sandwich Islands',NULL,NULL); INSERT INTO countries VALUES (NULL, 'ES','SPAIN','Spain','ESP','724'); INSERT INTO countries VALUES (NULL, 'LK','SRI LANKA','Sri Lanka','LKA','144'); INSERT INTO countries VALUES (NULL, 'SD','SUDAN','Sudan','SDN','736'); INSERT INTO countries VALUES (NULL, 'SR','SURINAME','Suriname','SUR','740'); INSERT INTO countries VALUES (NULL, 'SJ','SVALBARD AND JAN MAYEN','Svalbard and Jan Mayen','SJM','744'); INSERT INTO countries VALUES (NULL, 'SZ','SWAZILAND','Swaziland','SWZ','748'); INSERT INTO countries VALUES (NULL, 'SE','SWEDEN','Sweden','SWE','752'); INSERT INTO countries VALUES (NULL, 'CH','SWITZERLAND','Switzerland','CHE','756'); INSERT INTO countries VALUES (NULL, 'SY','SYRIAN ARAB REPUBLIC','Syrian Arab Republic','SYR','760'); INSERT INTO countries VALUES (NULL, 'TW','TAIWAN, PROVINCE OF CHINA','Taiwan, Province of China','TWN','158'); INSERT INTO countries VALUES (NULL, 'TJ','TAJIKISTAN','Tajikistan','TJK','762'); INSERT INTO countries VALUES (NULL, 'TZ','TANZANIA, UNITED REPUBLIC OF','Tanzania, United Republic of','TZA','834'); INSERT INTO countries VALUES (NULL, 'TH','THAILAND','Thailand','THA','764'); INSERT INTO countries VALUES (NULL, 'TL','TIMOR-LESTE','Timor-Leste',NULL,NULL); INSERT INTO countries VALUES (NULL, 'TG','TOGO','Togo','TGO','768'); INSERT INTO countries VALUES (NULL, 'TK','TOKELAU','Tokelau','TKL','772'); INSERT INTO countries VALUES (NULL, 'TO','TONGA','Tonga','TON','776'); INSERT INTO countries VALUES (NULL, 'TT','TRINIDAD AND TOBAGO','Trinidad and Tobago','TTO','780'); INSERT INTO countries VALUES (NULL, 'TN','TUNISIA','Tunisia','TUN','788'); INSERT INTO countries VALUES (NULL, 'TR','TURKEY','Turkey','TUR','792'); INSERT INTO countries VALUES (NULL, 'TM','TURKMENISTAN','Turkmenistan','TKM','795'); INSERT INTO countries VALUES (NULL, 'TC','TURKS AND CAICOS ISLANDS','Turks and Caicos Islands','TCA','796'); INSERT INTO countries VALUES (NULL, 'TV','TUVALU','Tuvalu','TUV','798'); INSERT INTO countries VALUES (NULL, 'UG','UGANDA','Uganda','UGA','800'); INSERT INTO countries VALUES (NULL, 'UA','UKRAINE','Ukraine','UKR','804'); INSERT INTO countries VALUES (NULL, 'AE','UNITED ARAB EMIRATES','United Arab Emirates','ARE','784'); INSERT INTO countries VALUES (NULL, 'GB','UNITED KINGDOM','United Kingdom','GBR','826'); INSERT INTO countries VALUES (NULL, 'US','UNITED STATES','United States','USA','840'); INSERT INTO countries VALUES (NULL, 'UM','UNITED STATES MINOR OUTLYING ISLANDS','United States Minor Outlying Islands',NULL,NULL); INSERT INTO countries VALUES (NULL, 'UY','URUGUAY','Uruguay','URY','858'); INSERT INTO countries VALUES (NULL, 'UZ','UZBEKISTAN','Uzbekistan','UZB','860'); INSERT INTO countries VALUES (NULL, 'VU','VANUATU','Vanuatu','VUT','548'); INSERT INTO countries VALUES (NULL, 'VE','VENEZUELA','Venezuela','VEN','862'); INSERT INTO countries VALUES (NULL, 'VN','VIET NAM','Viet Nam','VNM','704'); INSERT INTO countries VALUES (NULL, 'VG','VIRGIN ISLANDS, BRITISH','Virgin Islands, British','VGB','092'); INSERT INTO countries VALUES (NULL, 'VI','VIRGIN ISLANDS, U.S.','Virgin Islands, U.s.','VIR','850'); INSERT INTO countries VALUES (NULL, 'WF','WALLIS AND FUTUNA','Wallis and Futuna','WLF','876'); INSERT INTO countries VALUES (NULL, 'EH','WESTERN SAHARA','Western Sahara','ESH','732'); INSERT INTO countries VALUES (NULL, 'YE','YEMEN','Yemen','YEM','887'); INSERT INTO countries VALUES (NULL, 'ZM','ZAMBIA','Zambia','ZMB','894'); INSERT INTO countries VALUES (NULL, 'ZW','ZIMBABWE','Zimbabwe','ZWE','716'); |
jQuery tip: Filter the selector DOM
That jQuery works with selectors using the patterns of CSS3 everybody know, and that apply in all dom you also know, but sometimes when you are using jquery you just want to filter a piece of DOM, not all DOM, and also apply some filter selector inside that DOM, here is the the tip:
1 2 3 4 5 | //some DOM var myHtml = $('<div><ul><li>1</li><li>2</li><li>sdasdasdasd</li></ul></div>'); //pass the myHtml by reference for the selector of jquery! var ul = $('ul', myHtml); |
The code can explain by his self, but describing a little bit more, we have some DOM and we want use the selector just in this piece of dom, we apply our selector in the first parameter and in the second we pass our DOM and that is it! The jQuery will inspect just the DOM that you specific.