mysqli_set_charset($ccoonn, "utf8");
$sql = "SELECT * FROM category";
$result = mysqli_query($ccoonn ,$sql);
echo"<center>";
echo"<table border=1>";
while($info = mysqli_fetch_array( $result ))
{
echo"<tr>";
$name=$info['name'];
echo"<td>";
echo $name;
echo"</td>";
echo"</tr>";
}
echo"</table>";
echo"</center>";
mysqli_set_charset($ccoonn, "utf8");
$sql = "SELECT * FROM category";
$result = mysqli_query($ccoonn ,$sql);
echo"<center>";
echo"<table border=1>";
while($info = mysqli_fetch_array( $result ))
{
echo"<tr>";
$name=$info['name'];
$number=$info['number'];
echo"<td>";
echo $name;
//$$$$$$$$$$$$$$$$$$$$$$
$sql2 = "SELECT * FROM forums WHERE cat=$number";
$result2 = mysqli_query($ccoonn ,$sql2);
while($info2 = mysqli_fetch_array( $result2 ))
{
echo"<br>";
$name=$info2['name'];
echo $name;
}
//$$$$$$$$$$$$$$$$$$$$$$
echo"</td>";
echo"</tr>";
}
echo"</table>";
echo"</center>";
//$$$$$$$$$$$$$$$$$$$$$$
$sql2 = "SELECT * FROM forums WHERE cat=$number";
$result2 = mysqli_query($ccoonn ,$sql2);
while($info2 = mysqli_fetch_array( $result2 ))
{
echo"<br>";
$name=$info2['name'];
echo $name;
}
//$$$$$$$$$$$$$$$$$$$$$$
$sql2 = "SELECT * FROM forums WHERE cat=$number";
$name=$info2['name'];
echo"<a href='http://saalek110.is-great.net/forum/forum.php'>".$name."</a>";
$forum_number=htmlspecialchars($_GET["number"]);
echo $forum_number;
mysqli_set_charset($ccoonn, "utf8");
$sql = "SELECT * FROM topics WHERE forum=$forum_number";
$result = mysqli_query($ccoonn ,$sql);
echo"<center>";
echo"<table border=1>";
while($info = mysqli_fetch_array( $result ))
{
echo"<tr>";
$name=$info['name'];
$number=$info['number'];
echo"<td>";
echo $name;
echo"</td>";
echo"</tr>";
}
echo"</table>";
echo"</center>";