Unnamed

<?php
$categories = array();

$resultCategories = mysql_query('
SELECT *
FROM ' . TABLE_CATEGORY . '
');

while ( $category = mysql_fetch_assoc($resultCategories) )
{
	$categories[] = $category;
	
	$resultSubcategories = mysql_query('
	SELECT *
	FROM ' . TABLE_SUBCATEGORY . '
	WHERE category_id = "' . $category['id'] . '"
	LIMIT 2
	');
	
	$categories[count($categories) - 1]['subcategories'] = array();
	
	while ( $subcategory = mysql_fetch_assoc($resultSubcategories) )
		$categories[count($categories) - 1]['subcategories'][] = $subcategory;
}

$smarty->assign('categories', $categories);
?>