Print a dynamic list of files to seperate divs

jmrouleau

I have a database table of files which fall into different categories. Each category has a numerical value. I want to seperate the files into the correct <div> tags based on their category so I can then show and hide the <div> depending on which category is selected in a dropdown. It sounds easy enough but I can't seem to think right now and Im stuck. 😕

So I would a have a string for each category. To this string I add the file information for each file in that category...and then print the strings...

Let me know if you need more explanation.

bpat1434

How about using GROUP BY in the SQL and then running a sub-query to get the results you want?

<?php

$query1 = "SELECT id FROM `table` GROUP BY id ASC";
$rslt = mysql_query($query1);
while($r = mysql_fetch_array($rslt))
{
  echo '<div>'.$r[0];
  $query2 = "SELECT * FROM `table` WHERE id='".$r['id']."'";
  $rslt2 = mysql_query($query2);
  while($row = mysql_fetch_array($rslt2);
  {
    echo $row[0].' '.$row[1];
  }
  echo '</div>';
}

Something like that.....

jmrouleau

Yea...Im working on something like this but it is more complicated because I have to connect to my database with ADODB so I have to manually put my results in an array.

This is what I have so far but it is giving me issues with offsets. Im not real good with arrays so this might look like a mess :bemused:

<?php 
	$getFiles='SELECT altname, filename, filesize, filetype, filenum FROM files ORDER BY filetype, altname ASC';
	$files=$conn->Execute($getFiles);

if(!$files->EOF){
$x=0;
while(!$files->EOF){
	$altname[$x]=$files->fields[0]->value;
	$filename[$x]=$files->fields[1]->value;
	$filesize[$x]=$files->fields[2]->value;
	$filetype[$x]=$files->fields[3]->value;
	$filenum[$x]=$files->fields[4]->value;
	$files->MoveNext();
	$x=$x+1;
}
$d=0;
$div=array();
for($q=0;$q<$x;$q++){
	if(isset($filetype[$q])){	
		$num=$filetype[$q];
		$div[$num].='
		<tr>
			<td class="file_menu" onClick="selectFile(this,"'.$filename[$q].'",'.$filenum[$q].')"  
			onMouseOver="highlight(this)" onMouseOut="remove(this)" id="'.$filenum[$q].'"><table width="100%"><tr><td>
			<strong>'.$altname[$q].'</strong></td><td align=right>'.$filesize[$q].'</td></tr></table></td>
		</tr>';
	}
	$d=$d+1;
}
for($g=0;$g<$d;$g++){
	if(isset($div[$g])){
		$div[$g].='
	</table>
</div>';
		echo $div[$g];
	}
}

}
?>

Roger_Ramjet

I thnk you are complicating things for yourself with all these arrays. Your first instinct was correct: go through the results and add each file to a string for the relevent div based on type.


$div1='';
$div2='';
$div3='';

while(!$files->EOF){ 
    $altname=$files->fields[0]->value;
    $filename=$files->fields[1]->value;
    $filesize=$files->fields[2]->value;
    $filetype=$files->fields[3]->value;
    $filenum=$files->fields[4]->value;

$str =  '<tr><td class="file_menu" onClick="selectFile(this,"'.$filename.'",'.$filenum.')"  

                onMouseOver="highlight(this)" onMouseOut="remove(this)" id="'.$filenum.'"><table width="100%"><tr><td>
                <strong>'.$altname.'</strong></td><td align=right>'.$filesize.'</td></tr></table></td>
            </tr>'; 

 switch ($filetype) {
 case 'type1' :
       $div1 .= $str;
       break;
 case 'type2' :
       $div2 .= $str;
       break;
 // etc

1 pass through the results building the div strings as you go.