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>"); } ?> Quote Link to comment https://forums.phpfreaks.com/topic/236386-help-with-while-loop/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.