Code: Select all
$query = "SELECT jcode, designation, responsibilities, city, posted FROM listing WHERE listing.status = 'yes' ORDER BY $order_by";
$result = mysql_db_query($database, $query, $connection) or die ("Error in query: $query1. " . mysql_error());
list($jcode) = mysql_fetch_row($result);
if(mysql_num_rows($result)) {
$rank = 1;
while($row = mysql_fetch_row($result))
{
print("</tr><tr>");
if($color == "#FFFFFF") {
$color = "#DFDFDF";
} else {
$color = "#FFFFFF";
}
print("<td width="5px" bgcolor="$color"><center><small>");
print("<font face="Verdana">$rank</font></small></center></td>");
print("<td width="75px" bgcolor="$color"><left><small>");
print("<font face="Verdana"><a href=?cmd=$jcode>$row[1]</font></a></small></center></td>");
print("<td width="235px" bgcolor="$color"><small>");
print("<font face="Verdana">$row[2]</font></small></center></td>");
print("<td width="75px" bgcolor="$color"><left><small>");
print("<font face="Verdana">$row[3]</font></small></left></td>");
print("<td width="85px" bgcolor="$color"><left><small>");
print("<font face="Verdana">$row[4]</font></small></left></td>");
$rank++;
}
}
}