[SQL] pobierz, plaintext 
CREATE TABLE cat (
	cat_id Int NOT NULL AUTO_INCREMENT,
	cat_root Int NOT NULL,
	cat_name Varchar(15) NOT NULL,
	cat_desc Varchar(80),
	cat_show Bool,
	UNIQUE (cat_id),
 PRIMARY KEY (cat_id)) ENGINE = MyISAM;
 
CREATE TABLE links (
	link_id Int NOT NULL AUTO_INCREMENT,
	cat_id Int NOT NULL,
	link_date Date NOT NULL,
	link_title Varchar(25) NOT NULL,
	link_desc Varchar(100),
	link_www Char(60) NOT NULL,
	link_ok Bool NOT NULL,
	UNIQUE (link_www),
 PRIMARY KEY (link_id)) ENGINE = MyISAM;
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
 
	{
		$sql = "SELECT Count(*) FROM links WHERE cat_id = $id";
		$this->db->DoSql($sql);
		return mysql_result($this->db->wynik,0,0);
	}
 
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
 
	function Count($id)
	{
		 if($id==0)
			$sql = "SELECT Count(*) FROM cat WHERE cat_root = 0";
		else
			$sql = "SELECT Count(*) FROM cat WHERE cat_root = $id";
 
		$this->db->DoSql($sql);
		return mysql_result($this->db->wynik,0,0);
	}
 
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
 
	function ShowCat($id)
	{
		if($id==0)
			$sql = "SELECT * FROM cat WHERE cat_root = 0";
		else
			$sql = "SELECT * FROM cat WHERE cat_root = $id";
 
		$this->db->DoSql($sql);
		$wynik = $this->db->wynik;
 
		while($w = mysql_fetch_array($wynik))
		{
			$cat_id = $w['cat_id'];
			$cat_root = $w['cat_root'];
			$cat_name = $w['cat_name'];
			$cat_desc = $w['cat_desc'];
 
			echo $this->LinkIt($cat_id,$cat_root);
			echo $cat_name."</a> <b>(</b>".$this->Count($cat_id)."/".$this->CountLinks($cat_id)."<b>)</b><br>";
		}
	}
 
?>
[PHP] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT COUNT(links.cat_id) AS ilosc, cat.id
FROM cat LEFT JOIN links ON (cat.id = links.cat_id)
GROUP BY cat.id
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT COUNT(links.cat_id) AS ilosc, cat.id
FROM cat LEFT JOIN links ON (cat.id = links.cat_id)
GROUP BY cat.id
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT COUNT(links.cat_id) AS ilosc, cat.cat_id
FROM cat LEFT JOIN links ON (cat.cat_id = links.cat_id)
WHERE links.cat_id = $id GROUP BY links.cat_id
[SQL] pobierz, plaintext