<?
include ("header.php");
?>

<div id="columns">
    <div class="col1">
        <div class="box1">
            <div class="box-title1"><h3>News</h3></div>
                <div class="sepcol1">
                  <?    $sql = "SELECT * FROM products";
                        $result = mysql_query($sql);
                        while ($row = mysql_fetch_array($result)) {
                  ?>
                        <div class="prolist1">
                        <ul>
                            <li>Product ID: <?=$row['pro_id']?></li>
                            <li>Product Name: <?=$row['pro_name']?></li>
                            <li>Product Price: <?=$row['pro_price']?></li>

                            <li>Product Picture:
                            <? header('Content-type: image/jpg');
                                echo $row['pro_pic']; ?></li>
                        </ul>
                        </div>
                    <? }?>
                          <p>&nbsp;</p>
                         </div>

                </div>
                <div class="sepcol2">
                  <p>hahahhadsafdsaf</p>
                  <p>&nbsp;</p>
                  <p>saf</p>
                  <p>sa</p>
                  <p>fds</p>
                  <p>af</p>
                  <p>dsaf</p>
                  <p>dsa</p>
                  <p>fds</p>
                  <p>asafdsa</p>
                </div>
                <div class="sepcol3">
                  <p>dasfdafdsadsafdsadsafdsafdsafdsafdsafdsafdsafds</p>
                  <p>sa</p>
                  <p>fdsa</p>
                  <p>f</p>
                  <p>dsaf</p>
                  <p>dsa</p>
                  <p>f</p>
                  <p>asf</p>
                  <p>dsa</p>
                  <p>f</p>
                </div>
                <div class="sepcol4">hahahdsafdsa</div>
      </div>
    </div>
    <div class="col2">
        <div class="box2">
            <div class="box-title2"><h3>Categories</h3></div>
                <div class="categories">
                    <ul>
                        <?
                            $strSQL = ("SELECT * FROM categories");
                            $result = mysql_query($strSQL);

                            while ($row = mysql_fetch_array($result)) {
                        ?>
                            <li><a href="cats.php?id=<?=$row['cat_id']?>"><?=$row['cat_name']?></a></li>
                        <? } ?>
                    </ul>
                </div>
        </div>
    </div>


<? include ("footer.php"); ?>