if($year != "")
{
$link = mysql_connect($gMainDbHost, $gMainDbUser, $gMainDbPass) or die("Could not connect");
$status = mysql_select_db($gMainDbName, $link) or die("Could not select $gMainDbName");
mysql_query("SET CHARACTER SET 'utf8'", $link);
$query1 = "SELECT kil, fnamn, lnamn, ibild, bild, sexmastare from kilar WHERE d6ar=".$year." ORDER by sexmastare DESC, d6pryo DESC, lnamn ASC;";
$query2 = "SELECT kil, fnamn, lnamn, ibild, bild, sexmastare from kilar WHERE d6ar=".($year+1)." AND d6pryo=1 ORDER by sexmastare DESC";
$result1 = mysql_query($query1,$link) or print("Error querying the db");
$result2 = mysql_query($query2,$link) or print("Error querying the db");
$row = mysql_fetch_array($result1);
$antal = mysql_num_rows($result1);
// Closing connection
@mysql_close($link);
for($i = 1; $i <= $antal; $i++)
{
print("| | ");
print("".$row['fnamn']." ".$row['lnamn']);
if($row['sexmastare'])
{
print(" Sexmästare | ");
}
else
{
print(" Sexmästerist");
}
if($row['ibild'])
{
print(" | ");
}
else
{
print(" | ");
}
print(" ");
$row = mysql_fetch_array($result1);
}
$row = mysql_fetch_array($result2);
$antal = mysql_num_rows($result2);
for($i=1;$i<=$antal;$i++)
{
print("| | ");
print("".$row['fnamn']." ".$row['lnamn']);
print(" Pryo | ");
if($row['ibild'])
{
print(" | ");
}
else
{
print(" | ");
}
print(" ");
$row = mysql_fetch_array($result2);
}
?>
|
$pic = "bilder/d6/" . $year . ".gif";
if(file_exists($pic))
{
print(" ");
}
?>
|
}
else
{
print("