Code: Select all
function category() {
global $skinz;
$sql = "SELECT COUNT(cat_id) AS total FROM skinz_images WHERE status='1' ORDER BY cat_id";
$result = mysql_query($sql, $skinz) or die(mysql_error());
$row = mysql_fetch_assoc($result);
$total = $row['total'];
$query = "SELECT * FROM skinz_categories WHERE status='1' ORDER BY cat_name ASC";
$result = mysql_query($query, $skinz) or die(mysql_error());
$row = mysql_fetch_assoc($result);
do
echo "· <a href='cats.php?id=".$row['cat_id']."'>".$row['cat_name']."</a>(".$total.")<br />";
while ($row = mysql_fetch_array($result));
}Any help appreciated.