Къде бъркам?

[nom3r1]

Пробвам се да преработя този classes:

        //Use Database class
        $this->Database = new Database();
        
        if(is_numeric($level)){
            $this->Database->MySQLExec("SELECT * FROM `tasks_levels` WHERE `ID` = '".$level."'");
            if($this->Database->MySQLAffectRows() == 1){
            	
            	$this->Database->MySQLExec("SELECT * FROM `tasks_categories`");
            	
            	$body .= '<h1>Задачи://Категории</h1><div style="float: left; width: 100%; margin-top: 20px;">';
            	
            	while ($Row = $this->Database->MySQLFetchRow()){
                          $result = mysql_query("SELECT * FROM `tasks` WHERE `Category` = '".$Row[ID]."' AND `Level` = '".$level."'"); 
                          $i=0;
                          while ($rec = mysql_fetch_assoc($result)) {
                          $i++;
                          }       
            		$body .='<div class="blockFull"><div class="blockTop"></div>
            	<div class="blockCenter">
            		<span style="float:left; width: 80%;"><a  href="tasks.php?page=tasks&category='.$Row['ID'].'&level='.$level.'">'.$Row['Name'].'</a></span><span style="float:right; margin-right: 10px;">('.$i.' зад.) </span>  
          		</div>
					<div class="blockBottom"></div></div>';	
            	}
            	
            	$body .= '</div>';
            
            } else {
            	$body = message(22, 'text');	
            }
        } else {
            $body = message(22, 'text');
        }
        
        return $body;

Ето и кода:

case "categories" :
$page = "";
pageview($page);
 $level = $_GET['level'];
        if(is_numeric($level)){
		$result45 = mysql_query("SELECT * FROM `tasks_levels` WHERE `ID` = '".$level."'")or die(mysql_error());
		$result25 = mysql_query("SELECT * FROM `tasks_categories`")or die(mysql_error());
        
		echo '<h1>Задачи://Категории</h1><div style="float: left; width: 100%; margin-top: 20px;">';
        while ($row = mysql_fetch_assoc($result25)) {
		
                          $result23 = mysql_query("SELECT * FROM `tasks` WHERE `Category` = '".$Row[ID]."' AND `Level` = '".$level."'"); 
                          $i=0;
                          while ($rec = mysql_fetch_assoc($result23)) {
                          $i++;
                          }
            		echo '<div class="blockFull"><div class="blockTop"></div>
            	<div class="blockCenter">
            		<span style="float:left; width: 80%;"><a  href="tasks.php?page=tasks&category='.$Row['ID'].'&level='.$level.'">'.$Row['Name'].'</a></span><span style="float:right; margin-right: 10px;">('.$i.' зад.) </span>  
          		</div>
					<div class="blockBottom"></div></div>';	
            	}
            	
            	echo '</div>';
            
            }
        }
break;

sql:

CREATE TABLE IF NOT EXISTS `tasks_categories` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `Name` tinytext NOT NULL,
  UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;


INSERT INTO `tasks_categories` (`ID`, `Name`) VALUES
(1, 'Arithmetic Basics'),
(2, 'Logical Basics'),
(3, 'Arithmetic and Logic expressions '),
(4, 'IF conditions'),
(5, 'Multiple choice'),
(6, 'Loops'),
(7, 'Arrays'),
(8, 'Strings'),
(9, 'Subroutines'),
(10, 'Recursions'),
(11, 'Type ''Record'''),
(12, 'Working with files'),
(13, 'General'),
(16, 'Dynamic Structures – Linked list'),
(17, 'Dynamic structures – Stack'),
(18, 'Dynamic structures – Queue '),
(20, 'Olympiads, Competitions, Contests');

CREATE TABLE IF NOT EXISTS `tasks_levels` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `Name` tinytext NOT NULL,
  UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;


INSERT INTO `tasks_levels` (`ID`, `Name`) VALUES
(1, 'ниво А'),
(2, 'ниво Б'),
(3, 'ниво В');

CREATE TABLE IF NOT EXISTS `tasks` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `Description_Pascal` text NOT NULL,
  `Description_C` text NOT NULL,
  `Answer_Pascal` text NOT NULL,
  `Answer_C` text NOT NULL,
  `Author` varchar(50) NOT NULL DEFAULT '',
  `Category` int(10) NOT NULL DEFAULT '0',
  `Level` int(10) NOT NULL DEFAULT '0',
  `vote` int(11) NOT NULL,
  `vote_people` int(11) NOT NULL,
  `publish` enum('0','1') NOT NULL DEFAULT '1',
  UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=471 ;

Fatal error: Cannot break/continue 1 level in home/nom3r1/public_html/tasks.php on line 305

Ред: 305:

break;

 

[FestarBG]

case "categories" :
$page = "";
pageview($page);
$level = $_GET['level'];
if(is_numeric($level)){
$result45 = mysql_query("SELECT * FROM `tasks_levels` WHERE `ID` = '".$level."'")or die(mysql_error());
$result25 = mysql_query("SELECT * FROM `tasks_categories`")or die(mysql_error());

echo '<h1>Задачи://Категории</h1><div style="float: left; width: 100%; margin-top: 20px;">';
while ($row = mysql_fetch_assoc($result25)) {

$result23 = mysql_query("SELECT * FROM `tasks` WHERE `Category` = '".$Row[ID]."' AND `Level` = '".$level."'");
$i=0;
while ($rec = mysql_fetch_assoc($result23)) {
$i++;
}
echo '<div class="blockFull"><div class="blockTop"></div>
<div class="blockCenter">
<span style="float:left; width: 80%;"><a href="tasks.php?page=tasks&category='.$Row['ID'].'&level='.$level.'">'.$Row['Name'].'</a></span><span style="float:right; margin-right: 10px;">('.$i.' зад.) </span>
</div>
<div class="blockBottom"></div></div>';
}

echo '</div>';

}
break;