listings in cat

slimjim

Table structure
Table cats
id || Category Name

Table List
id || name || Category id

I am trying to make it so that it looks like this :

Category Name 1
name
name
name
name

Category Name 2
name
name
name
name

Category Name 3
name
name
name
name

ANy idea how to show each category, and a list under each with out having it show the category name next to each listing ?

frikikip

You mean something like this:
(P.S. I wrote this without ANY testing and error checking, so use it on your own risk)

<?php
// Mysql connect shizzl here

$result = mysql_query("SELECT Item.id, Item.name, Cat.name as catName FROM Item LEFT JOIN Cat ON Item.catId = Cat.id ORDER BY Cat.name DESC") or die("Bad query");

$oldCatName = "";

while($row = mysql_fetch_array($result)) {

if($row["catName"] != $oldCatName) {

	echo "<h1>".$row["catName"]."</h1>\n";
	$oldCatName = $row["catName"];
}

echo $row["name"]."<br />\n";
}
?>

frikikip

You could also get all categories first, then get all items and order them by categoryID, name. After you have all items you can create an 2d array grouped by category id.

(P.S. Again without ANY testing and error checking)

<?php
// Mysql connect shizzl here

// Get all items per categorie
$itemResult = mysql_query("SELECT * FROM Item ORDER BY catId, name") or die("Bad item query");
$itemPerCat = array();
while($row = mysql_fetch_array($itemResult)) {

$itemPerCat[$row["catId"]][] = $row;
}

// Get the categories an print the lists
$catResult = mysql_query("SELECT * FROM Cat ORDER BY name DESC") or die("Bad cat query");
while($row = mysql_fetch_array($catResult )) {

echo "<h1>".$row["name"]."</h1>\n";

if(isset($itemPerCat[$row["id"]])) {

	foreach($itemPerCat[$row["id"]] as $item) {

		echo $item["name"]."<br />\n";
	}
}
}
?>

This method has the advantage that you are more flexible when it comes to sorting of categories, etc. However there is also a lot of overhead (2 queries, more loops).