Startside Leica Noctivid - ny kikkert fra Leica I samarbejde med DOF
Home
DK obs.
VP obs.
Nyheder 
DK listen
Forum
Galleriet
 Artslister 
Steppehøg, 2cy male, Sverige 26. august 2012 Foto: Eigil Ødegaard




Konkurrencer på Netfugl.dk


Tip13 2009

"; gui_header_under("Tip13 2009 statistik", "Tip13 2009 statistics", 95); echo "
"; $sql_tip_coupon = "Select COUNT(*) As number_of_persons, tipcategory.category_text, tipcategory.category_point_a, tipcategory.category_point_b, birdlist.species_id, birdlist." . $page_language . "_name As bird_name From tbl_tip13_2009_list AS tiplist, tbl_bird_species As birdlist, tbl_tip13_2009_arter_category As tipcategory, tbl_tip13_2009_arter As tipspecies Where tiplist.species_id = birdlist.species_id AND tipspecies.species_id = tiplist.species_id AND tipspecies.id_category = tipcategory.id_category Group by tipspecies.species_id Order By number_of_persons desc, birdlist.placement"; $db->query($sql_tip_coupon, "tip_coupon"); echo "
"; if($page_language == 'dk') { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } else { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } $tip_point_a = 0; $tip_point_b = 0; $rowNumber = 0; //Gennemloeber Recordset While ($row2 = $db->row("tip_coupon")) { $rowNumber++; $tip_point_a = $tip_point_a + $row2["category_point_a"]; $tip_point_b = $tip_point_b + $row2["category_point_b"]; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
#ArtKategoriPoint#Personer
#SpeciesCategoryPointTick#Persons
"; echo $rowNumber; echo ""; echo "" . $row2["bird_name"] . ""; echo ""; echo $row2["category_text"]; echo ""; echo "(" . $row2["category_point_a"] . "/" . $row2["category_point_b"] . ")"; echo ""; echo $row2['number_of_persons']; echo "
"; echo "
"; ?>


Odinshane, juvenile, Sverige 30. august 2010 Foto: Daniel Pettersson
 
til toppen copyright © 2002-2005 Netfugl.dk - Danmark
kontakt os: netfugl@netfugl.dk - om os: webmasters - genereret på 0.174 sek.
til toppen