Просмотр поста

В общем вот этот быдло код вывода каталогов

$count = mysql_result(mysql_query("SELECT COUNT(*) FROM `chop` WHERE  `refid`='" .
					$id . "'"), 0);
				if ($count)
				{
					$req = mysql_query("SELECT * FROM `chop` WHERE `refid`='$id'");

					while ($res = mysql_fetch_array($req))
					{
						
                        
                        
						$t = mysql_fetch_assoc(mysql_query("SELECT * FROM `chop` WHERE `id`= '" .
							$res['id'] . "' LIMIT 1"));
					$ts = $t['type'];
						if ($ts == 'k')
						{
							$count = mysql_result(mysql_query("SELECT COUNT(*) FROM `tovar` WHERE `refid`='" .
								$t['id'] . "'"), 0);
						}
						else
						{
							$count = mysql_result(mysql_query("SELECT COUNT(*) FROM `chop` WHERE `refid`='" .
								$res['id'] . "'"), 0);
						}



						echo '<a class="menu" href="index.php?id=' . $res['id'] . '"><img src="/images/dir.png" alt="*"/> ' . checkout($res['name'],
							1, 1) . ' [' . $count . ']</a>';
						if ($rights >= 7)
							if ($rights >= 7)
					echo '<a class="delete" href="submit.php?id='.$res['id'] .'">X</a>';
						if (!empty($res['opis']))
						{
							$text = $res['opis'];
							$text = mb_substr($text, 0, 100);
							$text = checkout($text, 1, 1);
							#echo '<div class="sub"><span class="gray">' . $text .
							#	'</span></div>';
						}
						
						++$i;
					}
				}
				else
				{
					echo '<div class="list">Каталог пуст</div>';
				}