rendered paste body<?
if (!$_GET['item']) {
if ($_GET['id']){
$c = mysql_fetch_array(mysql_query("SELECT * FROM categorys WHERE id = '".$_GET['id']."'"));
echo $c['title'];
?>
<table border="1" cellspacing="0" cellpadding="0" bordercolor="#CCCCCC" style="border-collapse: collapse" width="80%">
<tr class="sheader">
<td width="35%">Title</td>
<td width="45%">Short Description</td>
<td width="25%">Date</td>
<td align="center" width="5%">Download</td>
</tr>
<?php
if(!isset($_GET['page'])){
$page = 1;
} else {
$page = $_GET['page'];
}
$max_results = "40";
$from = (($page * $max_results) - $max_results);
$get = mysql_query("SELECT * FROM downloads WHERE cid = '".$_GET['id']."' ORDER BY id ASC LIMIT $from, $max_results");
while ($d = mysql_fetch_array($get)){
if ($d['id'] % 2 != 0) {
?>
<tr class="smain1" >
<td><? echo $d['title']; ?></td>
<td><? echo $d['sdesc']; ?></td>
<td><? echo $d['date']; ?></td>
<td align="center"><a href="?item=<? echo $d['id']; ?>" alt="">Download</a></td>
</tr>
<?php
} else {
?>
<tr class="smain2" >
<td><? echo $d['title']; ?></td>
<td><? echo $d['sdesc']; ?></td>
<td><? echo $d['date']; ?></td>
<td align="center"><a href="?item=<? echo $d['id']; ?>" alt="">Download</a></td>
</tr>
<p>
<?php
}
}
echo"</table>";
} else {
?>
<table border="1" cellspacing="0" cellpadding="0" bordercolor="#CCCCCC" style="border-collapse: collapse" width="80%">
<tr class="sheader">
<td width="47%">Category</td>
<td width="58%">Short Description</td>
<td align="center" width="5%">Downloads</td>
</tr>
<?php
$get = mysql_query("SELECT * FROM downloads WHERE type= 'main"' ORDER BY id ASC");
while ($c = mysql_fetch_array($get)){
if ($c['id'] % 2 != 0) {
?>
<tr class="smain1" >
<td><? echo $d['title']; ?></td>
<td><? echo $c['desc']; ?></td>
<td><? echo $d['num']; ?></td>
</tr>
<?php
} else {
?>
<tr class="smain2" >
<td><? echo $d['title']; ?></td>
<td><? echo $c['desc']; ?></td>
<td><? echo $d['num']; ?></td>
</tr>
<p>
<?php
}
}
}
} else {
$get = mysql_query("SELECT * FROM downloads WHERE id = '".$_GET['item']."'");
$num = mysql_num_rows($get);
if ($num == '0') {
?>
Item cannot be found.
<?php
} else {
$d = mysql_fetch_array($get);
?>
<table width="422" height="272" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="3"><img src="images/archive_01.png" width="422" height="26" alt="" /></td>
</tr>
<tr>
<td width="24" background="images/archive_02.png"> </td>
<td width="377" align="center" valign="top" background="images/archive_03.png" class="style3"><p><?php echo $d['title']; ?></p>
<p class="style7"> <?php echo $d['desc']; ?></p>
<p class="style6">Date Submitted: <?php echo $d['date']; ?></p>
<p class="style6">By: <?php echo $d['by']; ?></p>
<p class="style6"> </p>
<p class="style6"><a href="<?php echo $d['link']; ?>" alt="">DOWNLOAD</a></p>
<p class="style6"> </p></td>
<td width="21" background="images/archive_04.png"> </td>
</tr>
<tr>
<td colspan="3"><img src="images/archive_05.png" width="422" height="21" alt="" /></td>
</tr>
</table>
<?php
}
}
?>