Producten uitlezen per merk.

<!--Content Block-->
<section class="content-wrapper">
	<div class="content-container container">
		<div class="breadcrum-container">
			<ul>
				<li><a href="#" title="Home">Home</a></li>
				<li>Merken</li>
			</ul>
		</div>
		<div class="col-left">
			<div class="block man-block">
				<div class="block-title">Merken</div>
				<ul>
					<li><a href="?p=category&m=Samsung" title="Samsung">Samsung</a></li>
					<li><a href="?p=category&m=LG" title="LG">LG</a></li>
					<li><a href="?p=category&m=Philips" title="Philips">Philips</a></li>
					<li><a href="?p=category&m=Sony" title="Sony">Sony</a></li>
					<li><a href="?p=category&m=Toshiba" title="Toshiba">Toshiba</a></li>
					<li><a href="?p=category&m=Samsung" title="Panasonic">Panasonic</a></li>
				</ul>
			</div>
		</div>
		<div class="col-main">
			<div class="category-banner"><img src="images/merken.png" title="Merken" alt="Merken" /></div>
			<div class="pager-container">
				<div class="pager">
					<div class="show-items"></div>
					<div class="show-per-page"></div>
				</div>
				<div class="view-by-block">
				
					<div class="short-by">
						
					</div>
				</div>
			</div>
<div class="new-product-block">
<?php
session_start();
$_POST['Naam'];
$_POST['Prijs'];
$rowsover = $rows - ($pagina * $rowsperpagina);
$rowsperpagina = 6;

if(isset($_GET['page']) )
{
   $pagina = $_GET['page'] + 1;
   $offset = $rowsperpagina * $pagina;
}
else
{
   $pagina = 0;
   $offset = 0;
}

$max = 'limit ' .$offset.',' .$rowsperpagina;

echo "<center>";
if($pagina > 0 )
{
	   $last = $pagina - 2;
	   echo "<a href=\"?p=category&page=$last\">Vorige pagina</a> |";
	   echo " <a href=\"?p=category&page=$pagina\">Volgende pagina</a>";
}
	else if( $pagina == 0 )
	{
  		 echo "<a href=\"?p=category&page=$pagina\">Volgende pagina</a>";
	}
		else if( $rowsover < $rowsperpagina )
		{
		   $last = $pagina - 2;
		   echo "<a href=\"?p=category&page=$last\">Vorige pagina</a>";
		}
echo "</center>";
?>
<ul class="product-grid">
<?php
include('connection.php');
$sql = mysql_query("SELECT * FROM `producten` ".$max);
$pad = "database/";
$count = 0;
$count2 = 0;
while($rij = mysql_fetch_array($sql))
{
$afb = $pad.$rij['Afbeelding'];
$count++;
$count2++;
if($count > 3){
echo '<ul class="product-grid">';
$count = 0;
}
?>

				<li>
						<div class="pro-img"><?php echo '<a href=?p=productpage&id='.$rij['prodid'].'><img title="Product" alt="Product" src="'.$afb.'" /></a>'; ?></div>
						<div class="pro-content"><p><?php echo $rij['Naam']; ?></p></div>
						<div class="pro-price">€ <?php echo $rij['Prijs']; ?> </div>
						<div class="pro-btn-block">
							<?php
							if(isset($_GET['page'])){$_SESSION['link']=$_GET['page'];}
							 echo '<a class="add-cart left" href="?p=category&page='.$pagina.'&action=add&id='.$rij['prodid'].'" title="Add to Cart">Add to Cart</a>';
							?>
							<?php echo '<a class="add-cart right" href=?p=productpage&id='.$rij['prodid'].' title="Quick View">Meer informatie</a>' ?></div>
						<div class="pro-link-block">
							<div class="clearfix"></div>
						</div>
					</li>
              <?php	
if($count2 == 3){
	echo '</ul>';
$count2 = 0;
}
}


?>
</ul>

			</div>

-- phpMyAdmin SQL Dump
-- version 4.0.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 27, 2013 at 01:59 PM
-- Server version: 5.5.24-log
-- PHP Version: 5.3.13

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `dbtmtk10`
--

-- --------------------------------------------------------

--
-- Table structure for table `producten`
--

CREATE TABLE IF NOT EXISTS `producten` (
  `prodid` int(11) NOT NULL AUTO_INCREMENT,
  `Merk` varchar(256) NOT NULL,
  `Type` varchar(256) NOT NULL,
  `Naam` varchar(256) NOT NULL,
  `Grootte` varchar(256) NOT NULL,
  `Prijs` float(10,2) NOT NULL,
  `Beschrijving` text NOT NULL,
  `Afbeelding` varchar(256) NOT NULL,
  PRIMARY KEY (`prodid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `producten`
--

INSERT INTO `producten` (`prodid`, `Merk`, `Type`, `Naam`, `Grootte`, `Prijs`, `Beschrijving`, `Afbeelding`) VALUES
(1, 'Samsung', 'LED', 'UE40EH6030 LED tv ', '40', 419.99, 'Met de Samsung UE40EH6030 LED tv geniet je van scherpe beeldkwaliteit voor een goede en betaalbare prijs. Dit schitterende Full HD toestel met comfortabel scherm geeft beelden zeer vloeiend weer mede dankzij een beeldverversing van 200 Hz CMR; wel zo fijn bij het kijken van een voetbalwedstrijd bijvoorbeeld.', 'samsungtv.jpg'),
(7, 'Sony', 'e4ter', 'reyer', '234', 432.00, '235', 'IMG_2040.JPG'),
(16, 'Toshiba', '234', '2353', '2235', 235235.00, '23523', 'id.jpg');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;