anthelo Posted May 14, 2011 Share Posted May 14, 2011 Hello, What im trying to do is show under each category some pictures... I found this code and change it a little bit, but its still shows only one category and the images... Any suggestions how im gonna change it to show all my category's? <div id="PastProjects">Past Projects</div> <?php $query = mysql_query("SELECT * FROM tbl_pastprojects"); $counter = 0;//Use this as a way to ID data as it comes in. while($row = mysql_fetch_assoc($query)) { $catid[$counter] = $row['IssueId']; $catname[$counter] = $row['Title']; $Counter++; } $NumTimes = count($catid); //Establishing a number of times to run the second loop for($i=0; $i<=$NumTimes; $i++) { $query1 = mysql_query("SELECT * FROM tbl_pastprojects_entries WHERE IssueId = ".$catid[$i].""); $c=0;//Another Counter for SubID's while($row = mysql_fetch_assoc($query1)) { $subid[$i][$c] = $row['Id']; $sname[$i][$c] = $row['Thumb']; $c++; } } //Now all of the Cats are stored in 2 Arrays(1 For name and 1 for ID) and SubCats are in 2 Multi Arrays(1 For name and 1 for ID) ///Generate Display for($j=0; $j<$NumTimes; $j++) { echo("<div id='PastProjectstitle'>"); echo($catname[$j]); echo("</div>"); //Establish Count for sub cats $NumCats = count($subid[$j]);//This counts the second dimension of the array (which is the num of sub categorys for that particular category) echo("<div id='PastProjectsImages'>"); //Loop through each SubCat for($k=0; $k<$NumCats; $k++) { echo("<img src='".$sname[$j][$k]."' />"); } echo("</div>"); } ?> Link to comment https://forums.phpfreaks.com/topic/236386-help-with-while-loop/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.