Untitled

<html>
	<?php
		$dbhost = 'localhost';
		$dbuser = 'ktce8911_ktcDB';
		$dbpass = '3Pl6t[(gS5';
		$conn = mysql_connect($dbhost, $dbuser, $dbpass);
		if(! $conn )
		{
		  die('Could not connect: ' . mysql_error());
		}  ?>

		<div class="pc8-catalog-container">
			<div class="pc8-category">
				<h2 class="pc8-catmarg">Accessories</h2>
			</div>
			<div class="pc8-category-description"></div>

			<div class="pc8-subcategory">
				<h3 class="pc8-indent pc8-catmarg">Bar End</h3>
			</div>
			<div class="pc8-subcategory-description pc8-indent"></div>

		<?php
			$sql = "SELECT product_name, product_image, product_description, product_link
			FROM ktc_pc8_products WHERE Category = 'Accessories' AND Subcategory = 'Bar End'
			ORDER BY product_name ASC";

			mysql_select_db('ktce8911_ktcdb');
			$retval = mysql_query( $sql, $conn );
			if(! $retval )
			{
			  die('Could not get data: ' . mysql_error());
			}

			while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
			{
		?>
			<div class="pc8-product">
				<div class="pc8-product-image" style="width:25%">
					<img class="pc8-resize" src="<?php echo $row['product_image']; ?>">
				</div>
				<div class="pc8-product-text" style="width:70%">
					<h3 class="pc8-nospace pc8-product-title"><?php echo "{$row['product_name']}"; ?></h3>
				<p class="pc8-nospace"></p>
				<p class="pc8-margtop"></p>
				<?php echo stripslashes("{$row['product_description']}"); ?>
				<p></p>
			</div>
		</div>
	<?php } ?>

	<div class="pc8-subcategory">
		<h3 class="pc8-indent pc8-catmarg">Throttle Gas</h3>
	</div>
	<div class="pc8-subcategory-description pc8-indent"></div>

	<?php
			$sql = "SELECT product_name, product_image, product_description, product_link
			FROM ktc_pc8_products WHERE Category = 'Accessories' AND Subcategory = 'Throttle Gas'
			ORDER BY product_name ASC";

			mysql_select_db('ktce8911_ktcdb');
			$retval = mysql_query( $sql, $conn );
			if(! $retval )
			{
			  die('Could not get data: ' . mysql_error());
			}

			while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
			{
		?>
			<div class="pc8-product">
				<div class="pc8-product-image" style="width:25%">
					<img class="pc8-resize" src="<?php echo $row['product_image']; ?>">
				</div>
				<div class="pc8-product-text" style="width:70%">
					<h3 class="pc8-nospace pc8-product-title"><?php echo "{$row['product_name']}"; ?></h3>
				<p class="pc8-nospace"></p>
				<p class="pc8-margtop"></p>
				<?php echo stripslashes("{$row['product_description']}"); ?>
				<p></p>
			</div>
		</div>
	<?php } ?>

	<div class="pc8-subcategory">
		<h3 class="pc8-indent pc8-catmarg">Suspension</h3>
	</div>
	<div class="pc8-subcategory-description pc8-indent"></div>

	<?php
			$sql = "SELECT product_name, product_image, product_description, product_link
			FROM ktc_pc8_products WHERE Category = 'Accessories' AND Subcategory = 'Suspension'
			ORDER BY product_name ASC LIMIT 0,1";

			mysql_select_db('ktce8911_ktcdb');
			$retval = mysql_query( $sql, $conn );
			if(! $retval )
			{
			  die('Could not get data: ' . mysql_error());
			}

			while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
			{
		?>
			<div class="pc8-product">
				<div class="pc8-product-image" style="width:25%">
					<img class="pc8-resize" src="<?php echo $row['product_image']; ?>">
				</div>
				<div class="pc8-product-text" style="width:70%">
					<h3 class="pc8-nospace pc8-product-title"><?php echo "{$row['product_name']}"; ?></h3>
				<p class="pc8-nospace"></p>
				<p class="pc8-margtop"></p>
				<?php echo stripslashes("{$row['product_description']}"); ?>
				<p></p>
			</div>
		</div>
	<?php } ?>

	</div>

<?php if (function_exists("pagination")) {
    pagination($additional_loop->max_num_pages);
} ?>

<div class="main_paging">
	<div class="number">Page</div>
	<div class="number">1</div>
	<div class="number"><a href="http://ktcracing.com/products-2/">2 </a></div>
	<div class="number"><a href="http://ktcracing.com/products-3/">3 </a></div>
	<div class="number"><a href="http://ktcracing.com/products-4/">4 </a></div>
	<div class="number"><a href="http://ktcracing.com/products-5/">5 </a></div>
	<div class="number"><a href="http://ktcracing.com/products-6/">6 </a></div>
	<div class="number"><a href="http://ktcracing.com/products-7/">7 </a></div>
	<div class="number"><a href="http://ktcracing.com/products-8/">8 </a></div>
	<div class="number"><a href="http://ktcracing.com/products-9/">9 </a></div>
	<div class="number"><a href="http://ktcracing.com/products-10/">10 </a></div>
	<div class="number"><a href="http://ktcracing.com/products-11/">11 </a></div>
	<div class="number"><a href="http://ktcracing.com/products-12/">12 </a></div>
	<div class="number"><a href="http://ktcracing.com/products-13/">13 </a></div>
	<div class="number"><a href="http://ktcracing.com/products-14/">14 </a></div>
	<div class="number"><a href="http://ktcracing.com/products-15/">15 </a></div>
	<div class="number"><a href="http://ktcracing.com/products-16/">16 </a></div>
	<div class="number"><a href="http://ktcracing.com/products-17/">17 </a></div>
	<div class="number"><a href="http://ktcracing.com/products-18/">18 </a></div>
	<div class="number"><a href="http://ktcracing.com/products-19/">19 </a></div>
	<div class="number"><a href="http://ktcracing.com/products-20/">20 </a></div>
	<div class="number"><a href="http://ktcracing.com/products-21/">21 </a></div>
	<div class="number"><a href="http://ktcracing.com/products-22/">22 </a></div>
	<div class="number"><a href="http://ktcracing.com/products-23/">23 </a></div>
	<div class="number"><a href="http://ktcracing.com/products-24/">24 </a></div>
	<div class="number"><a href="http://ktcracing.com/products-25/">25 </a></div>
	<div class="number"><a href="http://ktcracing.com/products-26/">26 </a></div>
</div>

		<?php
			mysql_close($conn);
		?>
</html>