/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright © 2002 - 2006 Nick Jones
| http://www.php-fusion.co.uk/
+----------------------------------------------------+
| Released under the terms & conditions of v2 of the
| GNU General Public License. For details refer to
| the included gpl.txt file or visit http://gnu.org
+----------------------------------------------------*/
require_once "../maincore.php";
require_once THEMES."templates/header.php";

$query = "SELECT * FROM match_showminion WHERE sm_pet='8625regular' ORDER BY sm_name";
$result = mysql_query($query) or die("There was a problem with the SQL query: " . mysql_error());
opentable("View Matches");
echo "<table border='0' cellspacing='5' class='matchtable'>";
echo "<tr>";
echo "<td align='center' colspan='4'><h1><img src='/images/pets/8625_regular.gif' alt='8625 Regular'><br>
#8625 Regular</h1>";
echo "<hr></td></tr>";
if($result && mysql_num_rows($result) > 0)
{
    $i = 0;
    $max_columns = 4;
    while($row = mysql_fetch_array($result))        
   {
       // make the variables easy to deal with
       extract($row);

       // open row if counter is zero
       if($i == 0)
          echo "<tr>";

       // make sure we have a valid product
       if($sm_id != "" && $sm_id != null)
          echo "<td align='center' valign='top' width='25%'><img src='/images/minions/$sm_imageurl' alt='$sm_name' border='0'><p><strong>$sm_name</strong><p></td>";
    
       // increment counter - if counter = max columns, reset counter and close row
       if(++$i == $max_columns) 
       {
           echo "</tr>";
           $i=0;
       }  // end if 
   } // end while
} // end if results

 else {
  echo "<td align='center' colspan='4'><img src='/layout/images/match_unavail01.png' alt='Not Available' border='0'></td>";

}


echo "</tr></table>";
closetable();
include 'layout/matchbottom.php';
require_once THEMES."templates/footer.php";
?>