Search the Community

Hi there, I am trying to get images uploaded from a gallery to be organized under the author's id (displaying their name from the users table). I don't know if there are supposed to be different results (result1 result2 result3) either.... Thank you! Here is what the requirements are: $result1 = mysql_query("SELECT DISTINCT author_id FROM mugallery"); while ($row = mysql_fetch_array($result1)){ // nested query 1 { } // nested query 2 { } } // end outside query Inside this outside query, we will have 2 nested queries: 1. User data: One that uses the author_id from the mugallery table, and matches it to the user_id field of the users table. We can then retrieve first and last name of the author. • While we have the author name, create a <div> to contain them and echo out the name as a heading of sorts. 2. Gallery data: Another that retrieves all thumbnails from the gallery, but only WHERE the author_id matches the particular author in the current iteration of the loop from the outside query. Here is my code thus far: $result1 = mysql_query("SELECT DISTINCT author_id FROM mugallery"); while ($row = mysql_fetch_array($result1)){ $result2 = mysql_query("SELECT * FROM mugallery JOIN users ON mubdata.author_id = users.user_id "); while ($row = mysql_fetch_array($result2)){ $title = $row['title'] ; $description = $row['description']; $filename = $row['filename']; $imageid = $row['imageid']; $author_id = $row['author_id']; //echo $title . " | " .$description . " | " .$filename . " | " .$imageid; echo $author_id; }// end nested query 1 $result3 = mysql_query("SELECT * FROM mugallery WHERE author_id = !!!!! What to put here??!!!!!!!! "); while ($row = mysql_fetch_array($result3)){ $thisThumbHeader = " \n<div class=\"thumb\">"; $thisTitleToDisplay = "\n<div class=\"title\">$title</div>"; $titledescription = $title . ": " . $description; $thisImageCodePre = "<a href=\"display.php?imageid=$imageid\">"; $thisImageCode ="<img src=\"uploads/thumbs120/$filename\" /></a>"; $thisImageToDisplay = "\n<div class=\"image\">$thisImageCodePre$thisImageCode</div>"; $thisThumbFooter = " \n</div>"; $thisThumbToDisplay = $thisThumbHeader . $thisTitleToDisplay .$thisImageToDisplay.$thisDescriptionToDisplay .$thisThumbFooter ; echo $thisThumbToDisplay ; }// end nested query 2 } // end outside query