<?php
    $server = "";
  $db = "";
  $user = "";
  $pass = "";

  $id_connect = mysql_connect($server,$user,$pass);
  if (!$id_connect)
    die('Spojen� s MySQL datab�z� se nezdarilo.');
  $result_db = mysql_select_db($db,$id_connect);
  if (!$result_db)
  {
    echo mysql_errno($id_connect),': ',mysql_error($id_connect),'<br>';
    die('Nepodarilo se vybrat datab�zi .');
  }

    mysql_query("SET CHARACTER SET utf8");

    $sql1 = "SELECT guild.name AS gname, guild.web AS web, character.name AS cname FROM `guild`, `character` WHERE guild.leaderguid = character.guid AND character.race IN (2,5,6,8,10)";

    $id_result = mysql_query($sql1,$id_connect);
    if (!$id_result)
    {
      echo mysql_errno($id_connect),': ',mysql_error($id_connect),'<br />';
      die('Nepodaril se SQL pr�kaz.');
    }

        echo '<table border="0" cellspacing="0" cellpadding="5" align="left">
                    <th>Horde Guildy</th>';

    while(is_array($data = mysql_fetch_array($id_result))) {
            echo '<tr>';
            echo '<td>'.$data['gname'].'<br />';
            echo 'GM: '.$data['cname'].'<br />';
            echo 'web: <a href="'.$data['web'].'" target="_blank">'.$data['web'].'</a>';
            echo '</td></tr>';
            }

        echo '</table>';

    $sql2 = "SELECT guild.name AS gname, guild.web AS web, character.name AS cname FROM `guild`, `character` WHERE guild.leaderguid = character.guid AND character.race IN (1,3,4,7,11)";

    $id_result = mysql_query($sql2,$id_connect);
    if (!$id_result)
    {
      echo mysql_errno($id_connect),': ',mysql_error($id_connect),'<br />';
      die('Nepodaril se SQL pr�kaz.');
    }

        echo '<table border="0" cellspacing="0" cellpadding="5" align="right">
                    <th>Aliance Guildy</th>';

    while(is_array($data = mysql_fetch_array($id_result))) {
            echo '<tr>';
            echo '<td>'.$data['gname'].'<br />';
            echo 'GM: '.$data['cname'].'<br />';
            echo 'web: <a href="'.$data['web'].'" target="_blank">'.$data['web'].'</a>';
            echo '</td></tr>';
            }

        echo '</table>';

        mysql_free_result($id_result);

  mysql_close($id_connect);
?>