<?
$sql = "SELECT * FROM `lehrg` ORDER BY `prio`";
$result = mysql_query($sql, $conn);
if($result){
	while($lehrg = mysql_fetch_array($result)){
		$res2 = $sql = "SELECT * FROM `lehrg".$lehrg['prio']."` ORDER BY `prio`";
		if($res2){
			echo '	<div id="downl">
						<h1>'.$lehrg['name'].'</h1>'.$sql;
			while($data = mysql_fetch_array($res2)){
				echo '	<div id="downl2">
							<h2>'.$data['name'].'</h2>
							

'.$data['desc'].'</p>
							'.$data['file'].'
						</div>';
			}			
			echo '	</div>';
		}
	}
}

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/groeger/html/kontext/downl_2.php on line 10

CREATE TABLE `lehrg` (
  `id` int(2) NOT NULL auto_increment,
  `name` text NOT NULL,
  `prio` int(2) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;

CREATE TABLE `lehrg6` (
  `id` int(2) NOT NULL auto_increment,
  `name` text NOT NULL,
  `desc` text NOT NULL,
  `file` text NOT NULL,
  `prio` int(2) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `prio` (`prio`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;