");
#execute the query
$rs = mysql_query($sql);
// $num = mysql_num_rows ($rs);
// echo ("num row is $num
");
if (mysql_num_rows ($rs) == 0)
{
$count = 0;
}
else
{
// Need to to load
$row = mysql_fetch_array( $rs );
$count = intval($row["count(*)"]);
}
} // end else
return $count;
} // function
// load category counts
// Load counts
$cat3=getCatCounts($city, 3);
$cat4=getCatCounts($city, 4);
$cat5=getCatCounts($city, 5);
$cat6=getCatCounts($city, 6);
$cat7=getCatCounts($city, 7);
$cat8=getCatCounts($city, 8);
$cat9=getCatCounts($city, 9);
$cat10=getCatCounts($city, 10);
$cat11=getCatCounts($city, 11);
$cat12=getCatCounts($city, 12);
$cat13=getCatCounts($city, 13);
$cat14=getCatCounts($city, 14);
$cat15=getCatCounts($city, 15);
$cat16=getCatCounts($city, 16);
$cat17=getCatCounts($city, 17);
$cat18=getCatCounts($city, 18);
$cat19=getCatCounts($city, 19);
$cat20=getCatCounts($city, 20);
$cat21=getCatCounts($city, 21);
$cat22=getCatCounts($city, 22);
$cat23=getCatCounts($city, 23);
$cat24=getCatCounts($city, 24);
$cat25=getCatCounts($city, 25);
$cat26=getCatCounts($city, 26);
$cat27=getCatCounts($city, 27);
$cat29=getCatCounts($city, 29);
$cat30=getCatCounts($city, 30);
$cat31=getCatCounts($city, 31);
$cat32=getCatCounts($city, 32);
$cat33=getCatCounts($city, 33);
$cat34=getCatCounts($city, 34);
$cat35=getCatCounts($city, 35);
$cat36=getCatCounts($city, 36);
$cat37=getCatCounts($city, 37);
$cat38=getCatCounts($city, 38);
$cat39=getCatCounts($city, 39);
$cat40=getCatCounts($city, 40);
$cat42=getCatCounts($city, 42);
$cat43=getCatCounts($city, 43);
$cat44=getCatCounts($city, 44);
$cat45=getCatCounts($city, 45);
$cat46=getCatCounts($city, 46);
$cat47=getCatCounts($city, 47);
$cat48=getCatCounts($city, 48);
$cat49=getCatCounts($city, 49);
$cat50=getCatCounts($city, 50);
$cat51=getCatCounts($city, 51);
$cat52=getCatCounts($city, 52);
$cat53=getCatCounts($city, 53);
$cat55=getCatCounts($city, 55);
$cat56=getCatCounts($city, 56);
$cat57=getCatCounts($city, 57);
$cat58=getCatCounts($city, 58);
$cat59=getCatCounts($city, 59);
$cat60=getCatCounts($city, 60);
$cat61=getCatCounts($city, 61);
$cat62=getCatCounts($city, 62);
$cat63=getCatCounts($city, 63);
$cat64=getCatCounts($city, 64);
$cat65=getCatCounts($city, 65);
$cat66=getCatCounts($city, 66);
$cat67=getCatCounts($city, 67);
$cat68=getCatCounts($city, 68);
$cat69=getCatCounts($city, 69);
$cat70=getCatCounts($city, 70);
$cat72=getCatCounts($city, 72);
$cat73=getCatCounts($city, 73);
$cat74=getCatCounts($city, 74);
$cat75=getCatCounts($city, 75);
$cat76=getCatCounts($city, 76);
$cat77=getCatCounts($city, 77);
$cat78=getCatCounts($city, 78);
$cat79=getCatCounts($city, 79);
$cat80=getCatCounts($city, 80);
$cat81=getCatCounts($city, 81);
$cat82=getCatCounts($city, 82);
$cat83=getCatCounts($city, 83);
$cat84=getCatCounts($city, 84);
$cat85=getCatCounts($city, 85);
$cat86=getCatCounts($city, 86);
$cat87=getCatCounts($city, 87);
$cat89=getCatCounts($city, 89);
$cat90=getCatCounts($city, 90);
$cat91=getCatCounts($city, 91);
$cat92=getCatCounts($city, 92);
$cat93=getCatCounts($city, 93);
$cat94=getCatCounts($city, 94);
$cat95=getCatCounts($city, 95);
$cat96=getCatCounts($city, 96);
$cat97=getCatCounts($city, 97);
$cat98=getCatCounts($city, 98);
$cat99=getCatCounts($city, 99);
$cat100=getCatCounts($city, 100);
$cat101=getCatCounts($city, 101);
$cat102=getCatCounts($city, 102);
$cat104=getCatCounts($city, 104);
$cat105=getCatCounts($city, 105);
$cat106=getCatCounts($city, 106);
$cat107=getCatCounts($city, 107);
$cat108=getCatCounts($city, 108);
$cat109=getCatCounts($city, 109);
$cat110=getCatCounts($city, 110);
$cat111=getCatCounts($city, 111);
$cat112=getCatCounts($city, 112);
$cat113=getCatCounts($city, 113);
$cat114=getCatCounts($city, 114);
$cat115=getCatCounts($city, 115);
$cat116=getCatCounts($city, 116);
$cat117=getCatCounts($city, 117);
$cat119=getCatCounts($city, 119);
$cat120=getCatCounts($city, 120);
$cat121=getCatCounts($city, 121);
$cat122=getCatCounts($city, 122);
$cat123=getCatCounts($city, 123);
$cat124=getCatCounts($city, 124);
$cat125=getCatCounts($city, 125);
$cat126=getCatCounts($city, 126);
$cat127=getCatCounts($city, 127);
$cat128=getCatCounts($city, 128);
$cat129=getCatCounts($city, 129);
$cat130=getCatCounts($city, 130);
$cat131=getCatCounts($city, 131);
$cat132=getCatCounts($city, 132);
$cat133=getCatCounts($city, 133);
$cat134=getCatCounts($city, 134);
$cat135=getCatCounts($city, 135);
$cat136=getCatCounts($city, 136);
$cat137=getCatCounts($city, 137);
$cat138=getCatCounts($city, 138);
$cat139=getCatCounts($city, 139);
$cat141=getCatCounts($city, 141);
$cat142=getCatCounts($city, 142);
$cat142=getCatCounts($city, 143);
$cat144=getCatCounts($city, 144);
$cat145=getCatCounts($city, 145);
$cat146=getCatCounts($city, 146);
$cat147=getCatCounts($city, 147);
$cat148=getCatCounts($city, 148);
$cat149=getCatCounts($city, 149);
$cat150=getCatCounts($city, 150);
$cat151=getCatCounts($city, 151);
$cat152=getCatCounts($city, 152);
$cat153=getCatCounts($city, 153);
$cat154=getCatCounts($city, 154);
$cat155=getCatCounts($city, 155);
$cat156=getCatCounts($city, 156);
$cat157=getCatCounts($city, 157);
$cat158=getCatCounts($city, 158);
$cat159=getCatCounts($city, 159);
$cat160=getCatCounts($city, 160);
$cat161=getCatCounts($city, 161);
$cat162=getCatCounts($city, 162);
$cat163=getCatCounts($city, 163);
$cat164=getCatCounts($city, 164);
$cat165=getCatCounts($city, 165);
$cat166=getCatCounts($city, 166);
$cat167=getCatCounts($city, 167);
$cat168=getCatCounts($city, 168);
$cat169=getCatCounts($city, 169);
$cat171=getCatCounts($city, 171);
$cat172=getCatCounts($city, 172);
$cat173=getCatCounts($city, 173);
$cat174=getCatCounts($city, 174);
$cat175=getCatCounts($city, 175);
$cat176=getCatCounts($city, 176);
$cat177=getCatCounts($city, 177);
$cat178=getCatCounts($city, 178);
$cat179=getCatCounts($city, 179);
$cat180=getCatCounts($city, 180);
$cat181=getCatCounts($city, 181);
$cat182=getCatCounts($city, 182);
$cat183=getCatCounts($city, 183);
$cat184=getCatCounts($city, 184);
$cat185=getCatCounts($city, 185);
$cat186=getCatCounts($city, 186);
$cat187=getCatCounts($city, 187);
$cat188=getCatCounts($city, 188);
$cat189=getCatCounts($city, 189);
$cat190=getCatCounts($city, 190);
$cat191=getCatCounts($city, 191);
$cat192=getCatCounts($city, 192);
$cat193=getCatCounts($city, 193);
$cat194=getCatCounts($city, 194);
$cat195=getCatCounts($city, 195);
$cat196=getCatCounts($city, 196);
$cat197=getCatCounts($city, 197);
$cat198=getCatCounts($city, 198);
$cat200=getCatCounts($city, 200);
$cat201=getCatCounts($city, 201);
$cat202=getCatCounts($city, 202);
$cat203=getCatCounts($city, 203);
$cat204=getCatCounts($city, 204);
$cat205=getCatCounts($city, 205);
$cat206=getCatCounts($city, 206);
$cat207=getCatCounts($city, 207);
$cat208=getCatCounts($city, 208);
$cat209=getCatCounts($city, 209);
$cat210=getCatCounts($city, 210);
$cat211=getCatCounts($city, 211);
$cat212=getCatCounts($city, 212);
$cat213=getCatCounts($city, 213);
$cat214=getCatCounts($city, 214);
$cat215=getCatCounts($city, 215);
$cat216=getCatCounts($city, 216);
$cat217=getCatCounts($city, 217);
$cat218=getCatCounts($city, 218);
$cat219=getCatCounts($city, 219);
$cat220=getCatCounts($city, 220);
$cat221=getCatCounts($city, 221);
$cat222=getCatCounts($city, 222);
$cat223=getCatCounts($city, 223);
$cat229=getCatCounts($city, 229);
$cat248=getCatCounts($city, 248);
$cat249=getCatCounts($city, 249);
$cat250=getCatCounts($city, 250);
$cat251=getCatCounts($city, 251);
$cat252=getCatCounts($city, 252);
$cat253=getCatCounts($city, 253);
$cat254=getCatCounts($city, 254);
$cat255=getCatCounts($city, 255);
$cat256=getCatCounts($city, 256);
$cat257=getCatCounts($city, 257);
$cat258=getCatCounts($city, 258);
$cat259=getCatCounts($city, 259);
$cat260=getCatCounts($city, 260);
$cat261=getCatCounts($city, 261);
$cat262=getCatCounts($city, 262);
$cat263=getCatCounts($city, 263);
$cat264=getCatCounts($city, 264);
$cat265=getCatCounts($city, 265);
$cat266=getCatCounts($city, 266);
$cat267=getCatCounts($city, 267);
$cat268=getCatCounts($city, 268);
$cat269=getCatCounts($city, 269);
$cat270=getCatCounts($city, 270);
$cat271=getCatCounts($city, 271);
$cat272=getCatCounts($city, 272);
$cat273=getCatCounts($city, 273);
$cat274=getCatCounts($city, 274);
$cat275=getCatCounts($city, 275);
$cat276=getCatCounts($city, 276);
$cat277=getCatCounts($city, 277);
$cat278=getCatCounts($city, 278);
$cat279=getCatCounts($city, 279);
$cat280=getCatCounts($city, 280);
$cat281=getCatCounts($city, 281);
$cat280=getCatCounts($city, 282);
$cat283=getCatCounts($city, 283);
$cat284=getCatCounts($city, 284);
$cat285=getCatCounts($city, 285);
$cat286=getCatCounts($city, 286);
$cat287=getCatCounts($city, 287);
$cat288=getCatCounts($city, 288);
$cat289=getCatCounts($city, 289);
$cat290=getCatCounts($city, 290);
$cat291=getCatCounts($city, 291);
$cat292=getCatCounts($city, 292);
$cat293=getCatCounts($city, 293);
$cat294=getCatCounts($city, 294);
$cat295=getCatCounts($city, 295);
$cat296=getCatCounts($city, 296);
$cat297=getCatCounts($city, 297);
$cat298=getCatCounts($city, 298);
$cat299=getCatCounts($city, 299);
$cat300=getCatCounts($city, 300);
$cat301=getCatCounts($city, 301);
$cat302=getCatCounts($city, 302);
$cat303=getCatCounts($city, 303);
$cat304=getCatCounts($city, 304);
$cat305=getCatCounts($city, 305);
$cat306=getCatCounts($city, 306);
$cat307=getCatCounts($city, 307);
$cat308=getCatCounts($city, 308);
$cat309=getCatCounts($city, 309);
$cat310=getCatCounts($city, 310);
$cat311=getCatCounts($city, 311);
$cat312=getCatCounts($city, 312);
$cat313=getCatCounts($city, 313);
$cat314=getCatCounts($city, 314);
$cat315=getCatCounts($city, 315);
$cat316=getCatCounts($city, 316);
$cat317=getCatCounts($city, 317);
$cat318=getCatCounts($city, 318);
$cat319=getCatCounts($city, 319);
$cat320=getCatCounts($city, 320);
$cat321=getCatCounts($city, 321);
$cat322=getCatCounts($city, 322);
$cat323=getCatCounts($city, 323);
$cat324=getCatCounts($city, 324);
$cat325=getCatCounts($city, 325);
$cat326=getCatCounts($city, 326);
$cat327=getCatCounts($city, 327);
$cat328=getCatCounts($city, 328);
$cat329=getCatCounts($city, 329);
$cat330=getCatCounts($city, 330);
$cat331=getCatCounts($city, 331);
$cat332=getCatCounts($city, 332);
$cat333=getCatCounts($city, 333);
$cat334=getCatCounts($city, 334);
$cat335=getCatCounts($city, 335);
$cat336=getCatCounts($city, 336);
$cat337=getCatCounts($city, 337);
$cat338=getCatCounts($city, 338);
$cat339=getCatCounts($city, 339);
$cat340=getCatCounts($city, 340);
$cat341=getCatCounts($city, 341);
$cat342=getCatCounts($city, 342);
$cat343=getCatCounts($city, 343);
$cat344=getCatCounts($city, 344);
$cat345=getCatCounts($city, 345);
$cat346=getCatCounts($city, 346);
$cat347=getCatCounts($city, 347);
$cat348=getCatCounts($city, 348);
$cat349=getCatCounts($city, 349);
$cat350=getCatCounts($city, 350);
$cat351=getCatCounts($city, 351);
$cat352=getCatCounts($city, 352);
$cat353=getCatCounts($city, 353);
$cat354=getCatCounts($city, 354);
$cat355=getCatCounts($city, 355);
$cat356=getCatCounts($city, 356);
$cat357=getCatCounts($city, 357);
$cat358=getCatCounts($city, 358);
$cat359=getCatCounts($city, 359);
$cat360=getCatCounts($city, 360);
$cat361=getCatCounts($city, 361);
$cat362=getCatCounts($city, 362);
$cat363=getCatCounts($city, 363);
$cat364=getCatCounts($city, 364);
$cat365=getCatCounts($city, 365);
$cat366=getCatCounts($city, 366);
$cat367=getCatCounts($city, 367);
$cat368=getCatCounts($city, 368);
$cat369=getCatCounts($city, 369);
$cat370=getCatCounts($city, 370);
$cat371=getCatCounts($city, 371);
$cat372=getCatCounts($city, 372);
$cat373=getCatCounts($city, 373);
$cat374=getCatCounts($city, 374);
$cat375=getCatCounts($city, 375);
$cat376=getCatCounts($city, 376);
$cat377=getCatCounts($city, 377);
$cat378=getCatCounts($city, 378);
$cat379=getCatCounts($city, 379);
$cat380=getCatCounts($city, 380);
$cat381=getCatCounts($city, 381);
$cat382=getCatCounts($city, 382);
$cat383=getCatCounts($city, 383);
$cat384=getCatCounts($city, 384);
$cat385=getCatCounts($city, 385);
$cat386=getCatCounts($city, 386);
$cat387=getCatCounts($city, 387);
$cat388=getCatCounts($city, 388);
$cat389=getCatCounts($city, 389);
$cat390=getCatCounts($city, 390);
$cat391=getCatCounts($city, 391);
$cat392=getCatCounts($city, 392);
$cat393=getCatCounts($city, 393);
$cat394=getCatCounts($city, 394);
$cat395=getCatCounts($city, 395);
$cat396=getCatCounts($city, 396);
$cat397=getCatCounts($city, 397);
$cat398=getCatCounts($city, 398);
$cat399=getCatCounts($city, 399);
$cat400=getCatCounts($city, 400);
$cat401=getCatCounts($city, 401);
$cat402=getCatCounts($city, 402);
$cat403=getCatCounts($city, 403);
$cat404=getCatCounts($city, 404);
$cat405=getCatCounts($city, 405);
$cat406=getCatCounts($city, 406);
$cat407=getCatCounts($city, 407);
$cat408=getCatCounts($city, 408);
$cat409=getCatCounts($city, 409);
$cat410=getCatCounts($city, 410);
$cat411=getCatCounts($city, 411);
$cat412=getCatCounts($city, 412);
$cat413=getCatCounts($city, 413);
$cat414=getCatCounts($city, 414);
$cat415=getCatCounts($city, 415);
$cat416=getCatCounts($city, 416);
$cat417=getCatCounts($city, 417);
$cat418=getCatCounts($city, 418);
$cat419=getCatCounts($city, 419);
?>