[pkcidstudio]

Does any one have an idea on generate the following with a select stmt?
EXAMPLE:

HTML Code:

Title
doc 
doc
doc
 
Title
doc
 
Title
doc
doc 
doc

Basically what is shown above is there will be one DISTINCT title and then under it any files associated with that title.

This is what I am doing currently, but it is only displaying 1 file per title.

PHP Code:

<?php

      
      $query = "SELECT * FROM $tbl_name WHERE titlehide='no' GROUP BY title";
      $result = mysql_query($query) or die("Invalid query: $query");
      if(mysql_num_rows($result) == 0)
      echo "No locations exist";
      
      else
      {
       while($row = mysql_fetch_array($result))
       {
       $path = 'http://192.168.0.104/usa/docs/OperationManuals';
       $folder = $row['url'];
       $doc = $row['document'];
        echo "<p><b>".$row['title']."</b><br>";
        echo "<a href='$path/$folder/$doc'>".$row['document']."</a></p>";
       }
      }
     ?>

[tomasgtz]

the problem is the query, you are making a group, so only will bring one row by title.

try to bring all rows and group it, in php... something like this

PHP Code:

$query = "SELECT * FROM $tbl_name WHERE titlehide='no' ORDER BY title";
$result = mysql_query($query) or die("Invalid query: $query");
if(mysql_num_rows($result) == 0)
{
      echo "No locations exist";
}
else
{
   while($row = mysql_fetch_array($result))
   {
       $docs[$row["title"]][] = array('url' => $row['url'], 'doc' => $row["document"]);
   }
}


foreach($docs as $title => $tmp)
{
   echo $title."<br>";
   
   foreach($tmp as $key => $data)
   {
       // etc etc ......
   }
} 

[pkcidstudio]

alright, makes sence. thanks tomasgtz

[pkcidstudio]

Tomasgtz,
I am experiancing the following:

instead of printing the name of the file it is generating a number
title
0
title
0
1
2
3
title
0
2
...
any thoughts of why this is happening?

PHP Code:

<?php
//Select title from a drop down, and allow title deletion (The titlehide flag is set to 1)
//select the titles that are different
$query = "SELECT * FROM $tbl_name WHERE titlehide='no' ORDER BY title";
$result = mysql_query($query) or die("Invalid query: $query");
if(mysql_num_rows($result) == 0)
{
echo "No locations exist";
}
else
{
while($row = mysql_fetch_array($result))
{
$available_titles[$row["title"]][] = array('url' => $row['url'], 'doc' => $row["document"]);
$path = 'http://foo/foo2/bar/bar2';
$folder = $row['url'];
$doc = $row['document'];
}
}
foreach($available_titles as $title => $tmp)
{
echo $title."<br>";
foreach($tmp as $doc => $data)
{
print_r("<a href='$path/$folder/$doc'>".$doc."</a></br>");
}
}
?>

[Nico]

PHP Code:

print_r("<a href='$path/$folder/$doc'>".$doc."</a></br>"); 

Try $data instead of $doc.

[pkcidstudio]

Close, now instead of displaying the file name is displaying
title
Array
title
Array
title
Array
Array
Array
Array
Array

[pkcidstudio]

-SOLVED-
in case any one has been currous on how this one was going to end. here is the completed source.

PHP Code:

      <?php
      //Select title from a drop down, and allow title deletion (The titlehide flag is set to 1)
      //select the titles that are different
      $query = "SELECT * FROM $tbl_name WHERE titlehide='no' ORDER BY title";
      $result = mysql_query($query) or die("Invalid query: $query");
      while($row = mysql_fetch_array($result))
      {      
       $path = 'http://foo/foo2/bar/bar2';
       $available_titles[$row["title"]][] = array('url' => $row['url'], 'doc' => $row["document"]);            
}
      foreach($available_titles as $title => $tmp)
      {
       echo $title."<br>";
       foreach($tmp as $doc => $data)
      {       
       //this is grabbing the information from the array $available_titles to fill these fields.
       // $data + the row = dynamic!
       echo("<a href=\"".$path."/".$data['url']."/".$data['doc']."\">".$data['doc']."</a></br>");
      } 
       echo "<br>";
      }
     ?>