Location: PHPKode > scripts > PHP Classified script made easy > php-classified-script-made-easy/Files/index.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<?PHP include("inc/meta.php"); ?>
<title><?PHP include("inc/title.php"); ?></title>
<link href="inc/style.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">
function goto(url)
{
document.location.href=(url);
}
</script>
</head>

<body>
<table width="900" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="70" valign="bottom"><a href="index.php"><img src="images/logo.gif" alt="Petoskey Classifieds - Northern Michigan Classifieds" width="450" height="62" border="0" /></a></td>
    <td class="head"><div align="right" class="style1"><a href="index.php" class="style10">Home</a> <span class="style4">|</span> <a href="buy.php" class="style46">Buy</a> <span class="style4">|</span><a href="sell.php" class="style46"> Sell </a><span class="style4">| </span><span class="style9"><a href="search.php" class="style46">Search</a> <span class="style44">|</span> <a href="help.php" class="style46">Help</a> </span></div></td>
  </tr>
  <tr>
    <td height="226" bgcolor="#F1F5FA" class="top left" onClick="goto('buy.php');"><div align="center"><img src="images/buy.gif" alt="Petoskey Classifieds Listings" width="272" height="178" /></div></td>
    <td bgcolor="#E2ECF5" class="top right" onClick="goto('sell.php');"><div align="center"><img src="images/sell.gif" alt="" width="265" height="180" /></div></td>
  </tr>
  <tr>
    <td height="34" colspan="2" valign="top" class="main-content"><br />
    <table width="100%" height="75" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td width="71%" valign="top" class="left-content"><table width="100%" border="0" cellpadding="0" cellspacing="0">
            <tbody>
              <tr>
                <td valign="bottom"><span class="style34">New Classified Listings</span></td>
              <td width="180" valign="bottom" style="padding-right:5px;"><div align="right"><img src="images/sort.gif" width="80" height="24" /></div></td>
              </tr>
            </tbody>
            </table>
            
            <table width="100%" border="0" cellspacing="0" cellpadding="0" style="border:1px solid #D8D8D8;" class="listings">
              <tr>
                <td height="30" colspan="2" valign="middle" bgcolor="#E2ECF5" style="padding-left:10px;" class="pages">
              
			  <?PHP
			   include("inc/header.php");
 if(isset($_GET['sort'])){$sort = $_GET['sort'];} else { $sort = "date"; }
 if($sort == "date") { $way = "desc";} else { $way = "asc"; }
 $query  = "SELECT * FROM classifieds WHERE authorized = '1' ORDER BY ".$sort." ".$way." limit 20";
 $result = mysql_query($query);
$rows = mysql_num_rows($result);





echo "<div align='left'><a href='buy.php'><img src='images/view-all.gif' border='0' /></a></div>";

echo "</td><td bgcolor='#E2ECF5'><form action='index.php' method='get' name='frmSort' id='frmSort'>
					<input type='hidden' name='page' value='".$pagenum."' />
                  <select name='sort' size='1' onChange='document.frmSort.submit();'>
                    <option label='Order by...' value='-1' selected='selected'>Sort by...</option>
                    <option label='Name' value='title'>Name</option>
                    <option label='Price' value='price'>Price</option>
                    <option label='Date Listed' value='date'>Date Listed</option>
                  </select>
                </form></td></tr>";
				if($rows > 0) {
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$limit++;
$counter++; // increases by one on each iteration of loop

if (is_float($counter/2)) $class = "r2";
else $class = "r1"; 
$description = $row['description'];
$description2 = substr($description,0,130); 
$cat = $row['cat'];
$querya  = "SELECT * FROM categories WHERE id = '$cat' limit 1";
 $resulta = mysql_query($querya);
 while($rowa = mysql_fetch_array($resulta, MYSQL_ASSOC))
{
$catname = $rowa['name'];
}
    echo "
	<tr>
                <td width='16%' class='".$class." thumb'><div align='center'><a href='classified-".$row['adid'].".php'><img src='".$row['picture']."' width='80' height='60' /></a></div></td>
                <td width='67%' height='66' class='".$class." padd'><a href='classified-".$row['adid'].".php' class='style17'>".$row['title']."</a><br />
                  <span class='style36'><em><a href='category-".$cat.".php' style='color:#000000;text-decoration:none;'>".$catname."</a></em><br/>".$description2."...</span></td>
                <td width='17%' class='".$class." price".$class."'><div align='center' class='style28' style='color:#000000;'>$".$row['price']."</div></td>
              </tr>
	
	
	";
}
} else { echo "<div align='center' style='font-family:Geneva, Arial, Helvetica, sans-serif'><h1>There Are No Classified Listings.</h1></div>";}

echo "<div align='left'>";
			  ?>
              <tr>
                <td height="23" bgcolor="#E2ECF5" colspan="3"><div align="center">
                  <table width="185" border="0" align="right" cellpadding="0" cellspacing="3">
                    <tr>
                      <td colspan="2"><div align="center" class="style26">
                        <div align="right"><a href="buy.php"><img src="images/view-all.gif" width="183" height="28" border="0" /></a></div>
                      </div></td>
                      </tr>
                    </table>
                </div></td>
              </tr>
            </table>
            <br />
          <br /></td>
          <td width="29%" valign="top" class="right-content"><?PHP include("inc/right.php"); ?></td>
        </tr>
    </table>    </td></tr>
  <tr>
    <td height="93" colspan="2" valign="top" class="footer">
    <div style="float:right;"><a href="#"><img src="images/backtotop.png" width="59" height="18" border="0" /></a></div>
    <div align="left" class="style23">
      <p><span class="style23"><a href="index.php" class="style49">Home</a> <span class="style44">|</span> <a href="buy.php" class="style49">Buy</a> <span class="style44">|</span><a href="sell.php" class="style49"> Sell </a><span class="style44">| </span><span class="style49"><a href="search.php" class="style49">Search</a> <span class="style44">|</span> <a href="help.php" class="style49">Help</a></span></span></p>
      <p class="style24"> All Rights Reserved 
        <?PHP include("inc/title.php"); ?>
        <br />
      PHP Classifieds App - <a href="http://www.rcoders.com/" style="text-decoration:none;color:#000000;">RCoders</a> Dev </p>
    </div></td>
  </tr>
</table>
</body>
</html>
Return current item: PHP Classified script made easy