$sql = "SELECT * from ghost_files, ghost_category where files_category = " . $categoryid. " and category_rec_id=files_category and files_approve = 'YES'"; $select = mysql_query($sql) or die("Couldn`t execute query $sql"); $num=mysql_numrows($select); $i=0; if ($num > 0){ $category_name=mysql_result($select,$i,"category_name"); } ?>
|