Advertisement
NFL

Zzz...

NFL
May 2nd, 2012
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.07 KB | None | 0 0
  1. function showCats($dataId) {
  2.     $return = '';
  3.     $dataId = (int) $dataId;
  4.     $subCatsArray = array();
  5.     $catsIds = mysql_query("SELECT DISTINCT(c.name) as cat_name, c.id as cat_id, d.id AS data_id  FROM
  6.        categories c,
  7.        data_category dc,
  8.        data d
  9.        WHERE
  10.        c.id=dc.maincat_id AND d.id=dc.data_id AND d.id='$dataId'");
  11.     if (mysql_num_rows($catsIds) != 0) {
  12.         $return.='<b>Категории:</b>';
  13.         while ($cat = mysql_fetch_object($catsIds)) {
  14.             $return.='<a href="?cat='.$cat->cat_id.'">'.$cat->cat_name.'</a>';
  15.             $subCats = mysql_query("SELECT dc.name AS name, dc.id AS subcat_id FROM data_categories dc
  16.                WHERE dc.id IN(SELECT id FROM data_category WHERE data_id='".$dataId."')");
  17.             while ($subcat = mysql_fetch_object($subCats)) {
  18.                 $subCatsArray[] = '<a href="?cat='.$cat->cat_id.'&subcat='.$subcat->subcat_id.'">'.$subcat->name.'</a>';
  19.             }
  20.             $return.='<br>('.implode(',', $subCatsArray).')';
  21.         }
  22.         return $return;
  23.     }
  24. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement