[RESOLVED] Display mysql category based on link click?

Kritter5x

H, i'm sorry if this is the wrong forum section, I wasn't sure which would be more appropriate since i'm fairly new to PHP still.

On the index.php page, I have links that say:

Playstation 3
Xbox 360

And when a user clicks those links, I want them to go to the product_display.php page, and display everything from the database with the subcategory "playstation3" or "xbox360", with about a limit of 10 per page.

My database is called products, and subcategory is where each item is labelled as playstation3 or xbox360.

I'm currently using this code to display products on the main page, but I can't limit it by category based on a link click.

$dynamicList="";
$sql = mysql_query("SELECT * FROM products ORDER BY release_date DESC LIMIT 4");
$productCount = mysql_num_rows($sql); //count the output amount
if ($productCount > 0) {
	while ($row = mysql_fetch_array($sql)){
		$id = $row["id"];
		$product_name = $row["product_name"];
		$subcategory = $row["subcategory"];
		$price = $row["price"];
		$release_date = strftime("%b %d, %Y", strtotime($row["release_date"]));
		//$dynamicList .= "$product_name - $subcategory<br />released on: $release_date<br />$price";
		$dynamicList .= '<div id="gamebox">
              <div id="gameimage"><a href="product.php?id=' . $id . '"><img src="inventory_images/' . $id . '.jpg" alt="' . $product_name . '" width="98" height="140" border="0" /></a></div>
              <p><b>' . $product_name . ' - ' . $subcategory . '</b></p>
              <p>Released: ' . $release_date . '</p>
              <br />
              <br />
              <p>$ ' . $price . '</p>
			  <p><a href="product.php?id=' . $id . '">View Product</a></p>
            </div>';
	}
} else {
	$product_list = "You have no products listed in your store yet";
}
mysql_close();
}

Any help would be greatly appreciated, thanks.

watdaflip

Just pass the subcategory with the id in the link. Grab the data on the product_display.php page, set a WHERE condition in the query. ie

SELECT * FROM products WHERE subcateogry='[passed value']' LIMIT 0, 10

I may have misunderstood the question, but I'm not seeing the problem.

Kritter5x

I want to display different things on the same page depending on the link clicked.

So you click PS3 on the index page, and it takes you to product_display.php, and displays the PS3 games. Then you click 360 on index, and it takes you to product_display.php and displays all 360 games.

I realize it might seem simple, but I'm just not sure on the specifics of what I put in a link and how I put it on the page etc