[RESOLVED] How can I display results of an array in individual rows.

[facarroll]

I've got my code working OK in that the correct results are drawn from the database. What I have here in the code is an array consisting of an image, accompanied by its title and thirdly a link to activate a quiz associated with the image. Everything works fine, except that I have an unknown number of sets of data (image, title and link) which I want to display so that each set of data takes up a new row.
The code I have here places all of the results into the same row.
Any suggestions are most welcome.

 <?php
// Query the database
$query1 = mysql_query("SELECT title FROM topics WHERE managerId='".$managerId."' AND egroup1='"."1"."' ORDER BY title ASC"); 
$query2 = mysql_query("SELECT url_small FROM topics WHERE managerId='".$managerId."' AND egroup1='"."1"."' ORDER BY title ASC"); 
$query3 = mysql_query("SELECT title FROM topics WHERE managerId='".$managerId."' AND egroup1='"."1"."' ORDER BY title ASC");
while($row1 = mysql_fetch_array($query3))
{
$linkname .= $row1['title']."<br />\n";
}
?>
                  <table>
                    <tr>
                      <td>
                      <?php
                      while ($row2 = mysql_fetch_array($query2)) 
                      { 
                      $thumbnail.= $row2['url_small'];
                      echo "<img src='wood_tool_images/{$row2['url_small']}' alt='' /><br />\n";
                      }
                      ?>
                      </td>
                      <td height="200">
                      <?php
                      echo $linkname 
                      ?>
                      </td>
                      <td>
                      <?php
                      while ($row1 = mysql_fetch_array($query1)) 
                      { 
                      $quizname.= $row1['title'];
                      echo "<a href='../{$row1['title']} Safety Quiz/{$row1['title']} Safety Quiz.php'>Take This Quiz</a><br />\n";
                      }
                      ?>
                      </td>
                     </tr>
                  </table>

[johanafm]

Either create a new table row for each iteration of row data, or if you really wish to stay inside the same table cell, wrap each row in a div element.

[facarroll]

I understand your advice generally, but can you explain in a little more detail. I'm really stuck at the moment.

[johanafm]

while ($row = mysql_fetch...) {
	echo '<tr><td>';
	# as before
	echo '</td></tr>';
}

[facarroll]

I think this is what you were suggesting. It isn't producing the result I want. This amendment presents the three different arrays completely displayed as one entity in one column.
I want the code to produce one tool image, one tool name and a clickable link, all displayed in one row.
Because the database queries result in an array, I have all of the array data arriving at once. This is not what I want. I want to be able to display one image, with one title alongside and one link also alongside. This is then repeated as a new row with another set of data, repeated until all the data is presented.
Should I be doing this all some other way.

<?php
// Query the database
$query1 = mysql_query("SELECT title FROM topics WHERE managerId='".$managerId."' AND egroup1='"."1"."' ORDER BY title ASC"); 
$query2 = mysql_query("SELECT url_small FROM topics WHERE managerId='".$managerId."' AND egroup1='"."1"."' ORDER BY title ASC"); 
$query3 = mysql_query("SELECT title FROM topics WHERE managerId='".$managerId."' AND egroup1='"."1"."' ORDER BY title ASC");
while($row1 = mysql_fetch_array($query3))
{
$linkname .= $row1['title']."<br />\n";
}
?>
                  <table>
                    <tr>
                      <td>
                      <?php
                      while ($row2 = mysql_fetch_array($query2)) 
                      { 
                      echo '<tr><td>';
                      $thumbnail.= $row2['url_small'];
                      echo "<img src='wood_tool_images/{$row2['url_small']}' /><br />\n";
                      echo '</td></tr>';
                      }
                      ?>
                      </td>
                      <td>
                      <?php
                      echo $linkname 
                      ?>
                      </td>
                      <td>
                      <?php
                      while ($row1 = mysql_fetch_array($query1)) 
                      { 
                      echo '<tr><td>';
                      $quizname.= $row1['title'];
                      echo "<a href='../{$row1['title']} Safety Quiz/{$row1['title']} Safety Quiz.php'>Take This Quiz</a><br />\n";
                      echo '</td></tr>';
                      }
                      ?>
                      </td>
                     </tr>
                  </table>

[johanafm]

facarroll;10965724 wrote:

                      <?php
# each row will be in a cell on its own row
                      while ($row2 = mysql_fetch_array($query2)) 
                      { 
                      echo '<tr><td>';
                      $thumbnail.= $row2['url_small'];
                      echo "<img src='wood_tool_images/{$row2['url_small']}' /><br />\n";
                      echo '</td></tr>';
                      }
                      ?>
                      </td>
                      <td>
                      <?php
# if you wish for this to be in the row above, that's where it has to go...
                      echo $linkname 
                      ?>

[facarroll]

I have it working well now. Thanks to you.