[Repp55]

I'm using php 5.2, mysql 5.0.22 and a Windows 2000 server.
My database is structured like so:

DB:
clfile ,
clfile_name
clfile_size
clfile_type
clfile_title
description
date_entered

cl_association,
cl_assoc_id
cl_file_id
cl_category_id
approved

categories
cl_category_id
cl_category


What I want to do is have all of the categories list out and each file list underneath them in a bullet list without having to use a form to select the categories. I have my code ready to where it will display one category and the files that are in that category but I'm not sure how to get all of them to do the same.

here is my code:

PHP Code:

<?php //view_files.php

$page_title = 'View Files';


        $first = TRUE;
require_once ('../_connect/intranet_connect.php');
$query ="Select cl_category_id FROM cl_categories";
$result = mysql_query($query);
(list ($type) = mysql_fetch_array($result, MYSQL_NUM));
{

$query = "SELECT cl_category FROM cl_categories WHERE cl_category_id=$type";
        
        $result= mysql_query($query);
        list ($category) = mysql_fetch_array($result, MYSQL_NUM)OR die(mysql_error());
        
        $first=TRUE;
        $query = "SELECT c.clfile_id, clfile_name, clfile_title, DATE_FORMAT(date_submitted, '%M %e, %Y') as d , description FROM clfile AS c, cl_association AS ca WHERE c.clfile_id = ca.clfile_id AND ca.cl_category_id=$type AND ca.approved = 'Y' ORDER BY date_submitted DESC";
        
        $result = mysql_query ($query);

        while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
        {
            
                if($first)
                {
                echo "<table border=\"0\" width=\"80%\" cellspacing=\"3\" cellpadding=\"3\" align=\"center\">
                        <tr>
                            <td><strong>$category</strong></td>
                            <Td><strong>Date</strong></td>
                        </tr>";
                        $first = FALSE;
                }
            
                echo "<tr><ul>
                        <td align=\"left\"><li><a href=\"../php/test/download.php?uid={$row['clfile_id']}\">{$row['clfile_title']}</a></td>
                        <td><font color=\"red\">*{$row['d']}*</li></td></a>
                    </tr>\n";
        }
    
            if($first)
                {
                    echo'<p>There are no files</p>';
                }
            else
                {
                    echo '</table>';
                }
}
mysql_close();    

?>

Sorry about the long post. Thank you all for your help!

[Naatan]

So you basically want to do what you just showed us only for all the categories in there?

Im not sure if Im getting you right cus if I am I dont see what the problem is.. just make the category query a while or foreach loop aswell..

[Repp55]

I'm pretty sure you are understanding my problem correctly,
I changed

PHP Code:

(list ($type) = mysql_fetch_array($result, MYSQL_NUM)); 
{ 


to

PHP Code:

while(list ($type) = mysql_fetch_array($result, MYSQL_NUM))
{ 


as a suggestion from someone else and it still returns as the one category. I'm pretty much a noob at PHP so is there something I'm leaving out?
Thanks for the help

[Naatan]

I've never used list() in such a manner, so I don't know for sure if it would work, but I have my doubts, try the following:

PHP Code:

$query ="Select cl_category_id FROM cl_categories";
$result = mysql_query($query);
while ($cat = mysql_fetch_array($result, MYSQL_NUM)) {
  echo $cat['cl_category_id'];
} 


and see if that works for you.

note that instead of $type you use $cat['cl_category_id'] - I would recommend always doing mysql queries like this as if you were to change something in your database you wouldn't have to adjust all of your php code

Also try debugging, start with a single while loop for the categories and see if it prints out all the rows, then insert the other while loop inside and see if they work together nicely.

[Repp55]

Thanks for the help man I got it to work with your post and another one a little down the list.