Введение - Создать блог

$view_comms_rec = mysql_query ("SELECT view_comms FROM blog");
$view_comms = mysql_fetch_assoc($view_comms_rec);

while($view_comms = mysql_fetch_array($view_comms_rec))
{
    mysql_query("UPDATE blog SET view_comms='".$view_comms['view_comms']."'");
}

SELECT
	COUNT(*)
	FROM
		*ТАБЛИЦА С КОММЕНТАРИЯМИ*
	WHERE
		*поле email* = '*email пользователя*'
;

SELECT
	COUNT(*)
	FROM
		table_comments
	WHERE
		user_email = 'test@mail.ru'
;

SELECT
	comments.id			AS comment_id,
	comments.user_name		AS user_name,
	comments.user_email		AS user_email,
	comments.comment_text	AS comment_text,
	
	(
		SELECT COUNT(comment.id)
			FROM
				table_comments comment
			WHERE
				comment.user_email = comments.user_email
	)	AS comment_qty
	FROM
		table_comments comments
;

$result_index = mysql_query("SELECT * FROM comm WHERE blog='$blog' AND status < '3' ORDER BY id");

$myrow_index = mysql_fetch_array($result_index);

$result_comment = mysql_query("SELECT COUNT comm FROM email WHERE user_email = '$myrow_index['email']' ");

$myrow_index = mysql_fetch_array($result_comments);

$result_comment = mysql_query("SELECT COUNT comm FROM email WHERE user_email = '$myrow_index['email']' ");

$myrow_index = mysql_fetch_array($result_comments);

$result_index = mysql_query("SELECT * FROM comm WHERE blog='$blog' AND status < '3' ORDER BY id");

$myrow_index = mysql_fetch_array($result_index);

$sql = ""
	."SELECT"
		." table_comm.id			AS id,"
		." table_comm.author			AS author,"
		." table_comm.email			AS email,"
		." table_comm.site			AS site,"
		." table_comm.text			AS text,"
		." table_comm.data_comm			AS data_comm,"
		." table_comm.blog			AS blog,"
		." table_comm.comm			AS comm,"
		." table_comm.status			AS status,"
		." table_comm.view			AS view,"
		." table_comm.loock			AS loock,"
		
		." ("
			." SELECT"
				." COUNT(qty_comm.id)"
			." FROM"
				." comm qty_comm"
			." WHERE"
				." table_comm.email = qty_comm.email"
		." ) 					AS qty"
	." FROM"
		." comm table_comm"
	." WHERE 1=1"
		." AND table_comm.blog 		= '".$blog."'"
		." AND table_comm.status 	< '3'"
		
		." ORDER BY table_comm.id"
;

$result_index	= mysql_query($sql);
$myrow_index	= mysql_fetch_array($result_index);

$sql = ""
    ."SELECT"
        ." table_comm.id			AS id,"
        ." table_comm.author			AS author,"
        ." table_comm.email			AS email,"
        ." table_comm.site			AS site,"
        ." table_comm.text			AS text,"
        ." table_comm.date_comm			AS date_comm,"
        ." table_comm.blog			AS blog,"
        ." table_comm.comm			AS comm,"
        ." table_comm.status			AS status,"
        ." table_comm.view			AS view,"
        ." table_comm.loock			AS loock,"
        
        ." ("
            ." SELECT"
                ." COUNT(qty_comm.id)"
            ." FROM"
                ." comm qty_comm"
            ." WHERE"
                ." table_comm.email = qty_comm.email"
        ." ) 					AS qty"
    ." FROM"
        ." comm table_comm"
    ." WHERE 1=1"
        ." AND table_comm.blog 		= '".$blog."'"
        ." AND table_comm.status 	< '3'"
        
        ." ORDER BY table_comm.id"
;

$result_index	= mysql_query($sql);
$myrow_index	= mysql_fetch_array($result_index);

if ($myrow_index['qty'] >= 1 AND $myrow_index['qty'] < 50)
	$rating = 'Новобранец';
elseif ($myrow_index['qty'] >= 50 AND $myrow_index['qty'] < 100)
	$rating = 'Стажер';
elseif ($myrow_index['qty'] >= 100 AND $myrow_index['qty'] < 150)
	$rating = 'Баклажан';

		if ($myrow_index['qty'] >= 1 AND $myrow_index['qty'] < 50)
        $rating = 'Новобранец';
        elseif ($myrow_index['qty'] >= 50 AND $myrow_index['qty'] < 100)
        $rating = 'Стажер';
        elseif ($myrow_index['qty'] >= 100 AND $myrow_index['qty'] < 150)
        $rating = 'Баклажан';
		$edd_tamp = str_replace("[rating]",$rating,$edd_tamp);

        if($myrow_index['qty'] >= 1 AND $myrow_index['qty'] < 50){$rating = 'Новобранец';}
        $edd_tamp = str_replace("[rating]",$rating,$edd_tamp);

echo $myrow_index['qty']."<br>";

if ($myrow_index['qty'] >= 1 AND $myrow_index['qty'] < 50)
$rating = 'Новобранец';
elseif ($myrow_index['qty'] >= 50 AND $myrow_index['qty'] < 100)
$rating = 'Стажер';
elseif ($myrow_index['qty'] >= 100 AND $myrow_index['qty'] < 150)
$rating = 'Баклажан';

echo $rating; die();

$myrow_index['qty'] = intval($myrow_index['qty']);

if ($myrow_index['qty'] >= 1 AND $myrow_index['qty'] < 50)
	$rating = 'Новобранец';
elseif ($myrow_index['qty'] >= 50 AND $myrow_index['qty'] < 100)
	$rating = 'Стажер';
elseif ($myrow_index['qty'] >= 100 AND $myrow_index['qty'] < 150)
	$rating = 'Баклажан';

		$commMASS[$i][9] = intval($commMASS[$i][9]);

        if ($commMASS[$i][9] >= 1 AND $commMASS[$i][9] < 50)
        $rating = 'Новобранец';
        elseif ($commMASS[$i][9] >= 50 AND $commMASS[$i][9] < 100)
        $rating = 'Стажер';
        elseif ($commMASS[$i][9] >= 100 AND $commMASS[$i][9] < 150)
        $rating = 'Баклажан';
		
        $edd_tamp = str_replace("{rating}",$rating,$edd_tamp);	

elseif ($commMASS[$i][9] >= 100 AND $commMASS[$i][9] < 150)
        $rating = 'Баклажан';

elseif ($commMASS[$i][9] >= 100)
        $rating = 'Баклажан';

function menu()
{
	$sql = ""
		."SELECT"
			." m.id		AS id,"
			." m.name		AS name,"
			." m.href		AS href,"
			." m.position	AS position,"
			." m.podmenu	AS podmenu,"
			." ("
				."SELECT"
					." COUNT(*)"
				." FROM"
					." blog b"
				." WHERE"
					." b.cat = m.id"
			." )			AS count"
		." FROM"
			." menu m"
	;
	
	$result_index	= mysql_query($sql);//Выводим из базы данных все пункты меню
	$myrow_index	= mysql_fetch_array($result_index);
	
	// логика которую я в данном примере опускаю
}

do//Цикл do while
{
    $commMASS[$i] = array(
		$myrow_index['id'],//0 - ID пункта
        $myrow_index['name'],//1 - Имя пункта
        $myrow_index['href'],//2 - Ссылка (# - нет ссылки; Пустота - Категория; "http://site.ru/page2.html" - Прямая ссылка)
        $myrow_index['podmenu']),//3 - ID родительного пункта
        $myrow_index['count']);//4 - кол-во заметок в категории
    
	$i++;//при каждом цикле меняем элемент многомерного массива на единицу
}
while($myrow_index = mysql_fetch_array($result_index));

function station($stat, $commMASS, $temp, $BC)
{
	for($i=0;isset($commMASS[$i]);$i++)//глобальный цикл for
		if($commMASS[$i][3] == $stat)//если podmenu пункта равно переменной stat
    	{
			// логика которую я в данном примере опускаю
        	
			//Замены идентификаторов на переменные из базы данных
        	if($commMASS[$i][2] == "")
				// тут вставляю кол-во заметок в скобках
				$href = "<a href=\"index.php?cat=".$commMASS[$i][0]."\">".$commMASS[$i][1]." (".$commMASS[$i][4].")</a>";	//если нет ссылки то генерируем категорию
        	else//если поле href не пусто
        	{
            	if($commMASS[$i][2] != "#")
					$href = "<a href=\"".$commMASS[$i][2]."\">".$commMASS[$i][1]."</a>";//если поле href не содержит значок "#" значит генерируем прямую ссылку
            	else
					$href = $commMASS[$i][1];//если содержит значок "#" значит пункт является не ссылкой, поэтому выводим только имя
        	}
			
			// логика которую я в данном примере опускаю
		}
		
	// логика которую я в данном примере опускаю

}

<?php 
function leftmenu()
{
	$result_index = mysql_query("SELECT * FROM cat LIMIT 41");
	$myrow_index = mysql_fetch_array($result_index);
	if($myrow_index != "")//Проверяем есть ли в базе данных записи
	{
	$sm_read = file_get_contents("templates/tpl_leftmenu.html");
	preg_match("#\[_divcat\](.*?)\[_divcat\]#s",$sm_read,$div_cat);
	do{
	   
	   
		$edd_tamp = $div_cat[1];  
		
		//Замены идентификаторов на переменные из базы данных
		if($myrow_index[href] == "") $href = "?cat=".$myrow_index[id];
		else $href = $myrow_index[href];
		
		$edd_tamp = str_replace("[_link]", $myrow_index[name],$edd_tamp);
		$edd_tamp = str_replace("[_href]", $href,$edd_tamp);
		$edd_tamp = str_replace("[_nnews]", $count_news,$edd_tamp);
		
		
		$leftmenu .= $edd_tamp;
	}
	while($myrow_index = mysql_fetch_array($result_index));
	$leftmenu = preg_replace("#\[_divcat\].*?\[_divcat\]#s",$leftmenu,$sm_read);
	}
	else $leftmenu = "";
	return $leftmenu;

}

function leftmenu()
{
	$sql = ""
        ."SELECT"
            ." c.id			AS id,"
            ." c.name		AS name,"
            ." c.href		AS href,"
            ." ("
                ."SELECT"
                    ." COUNT(*)"
                ." FROM"
                    ." blog b"
                ." WHERE"
                    ." b.cat = c.id"
            ." )			AS count"
        ." FROM"
            ." cat c"
        ." LIMIT 41"
    ;
	
	$result_index	= mysql_query($sql);
	$myrow_index	= mysql_fetch_array($result_index);
	
	if($myrow_index != "")//Проверяем есть ли в базе данных записи
	{
		$sm_read = file_get_contents("templates/tpl_leftmenu.html");
		
		preg_match("#\[_divcat\](.*?)\[_divcat\]#s", $sm_read, $div_cat);
		
		do{
			$edd_tamp = $div_cat[1];  

			//Замены идентификаторов на переменные из базы данных
			$href 		= ($myrow_index['href'] == "") ? "?cat=".$myrow_index['id'] : $myrow_index['href'];

			$edd_tamp 	= str_replace("[_link]", 	$myrow_index['name'].( ($myrow_index['count'] > 0) ? " (".$myrow_index['count'].")" : "" ),	$edd_tamp);
			$edd_tamp 	= str_replace("[_href]",	$href,																						$edd_tamp);
			$edd_tamp 	= str_replace("[_nnews]",	$count_news,																				$edd_tamp);


			$leftmenu .= $edd_tamp;
		}
		while($myrow_index = mysql_fetch_array($result_index));
		
		$leftmenu = preg_replace("#\[_divcat\].*?\[_divcat\]#s",$leftmenu,$sm_read);
	}
	else
		$leftmenu = "";
	
	return $leftmenu;
}