Tutortial system

CREATE TABLE `tutorials` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(225) NOT NULL,
`tutorial` text NOT NULL,
`approved` varchar(2) NOT NULL default '0',
`type` text NOT NULL,
`desc` text NOT NULL,
`views` varchar(20) NOT NULL default '1',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

<?
include("bbcode.php");

if (!$_GET[catagory])
{
$getuser = mysql_query("SELECT * from tutorials where type = '$_GET[catagory]' and approved = '1'");
while ($user = mysql_fetch_array($getuser))
{
echo ("<a href='tutorials.php?catagory=$_GET[catagory]&name=$_GET[name]'>$user[name]</a><br />");
}
}
ELSE
{
$getuser = mysql_query("SELECT * from tutorials where id = '$_GET[id]' and approved = '1'");
$usernum = mysql_num_rows($getuser);
if ($usernum == 0)
{
echo ("You need to select a tutorial");
}
else
{
$profile = mysql_fetch_array($getuser);
$content = bb2html($profile[tutorial]);
echo ("<table border="1" width="100%" cellspacing="0" id="table1" style="border-width: 0px" cellpadding="0" height="16">
<tr>
<td style="border-style: none; border-width: medium" bgcolor="#3399ff" height="14"><b><font color="#FFFFFF" size="1" face="Verdana"><b>$profile[name]</b> - <a href='members?user=$profile[username]'><font color='#FFFFFF'>$profile[username] - ");
if($logged[username] && $logged[userlevel] == 6){

?>
[<a href="mtut.php?act=tedit&tid=<? echo ("$profile[id]"); ?>">Edit</a>]
[<a href="mtut.php?act=tdel&tid=<? echo("$profile[id]"); ?>">Delete</a>]
<?
}
echo("
</font></a></font></b></td>
</tr>
</table>

<br> $content");
$views=stripslashes($profile['views']);

$views++;
mysql_query("UPDATE `tutorials` SET views='$views' WHERE id = '$profile[id]'");

}
}
}
}
}
?>

<?
if($logged[username] && $logged[userlevel] == 6) {
$tut = mysql_query("select * from tutorials where approved = '0'");
$tut = mysql_num_rows($tut);
echo("<a href='atut.php'> Sort tutorials ($tut) ")
}else{
echo(" ");
}
?>