$sql = "SELECT * from ghost_category order by category_name";
$select = mysql_query($sql) or die("Couldn`t execute query $sql");
$num=mysql_numrows($select);
$i=0;
?>
include('./inc/indexlogin.inc');?>
|
while ($i < $num) {
$category=mysql_result($select,$i,"category_name");
$id=mysql_result($select,$i,"category_rec_id");
$category_description=mysql_result($select,$i,"category_description");
$sql1 = "SELECT * from ghost_files where files_category =" . $id . " and files_approve = 'YES'";
$select1 = mysql_query($sql1) or die("Couldn`t execute query $sql");
$num1=mysql_numrows($select1);
?>
[
]
|
$i++;}?>