divide query result, please help

[vanvoquan]

Hi everyone. I have this code that suppose to divide the query result 3 columns in a row. Like this :

Shoes  Hats  Jeans

Shorts  Shirts  Belts

But for some reason this one doesn't work. It gave me everything in a single row. Like this: Shoes Hats jeans Shorts Shirts Belts. I noticed that before I put this two 2 lines of code, it's working fine. It didn't give me any error messages or anythings. Can someone point me out what did I did wrong?

 

This is two lines I put in:

$vuong_query = tep_db_query("select categories_id from " . TABLE_GENDER_CATEGORIES . " where parent_id = 1");
while ($product_check = tep_db_fetch_array($vuong_query)) {

 

This is the whole piece of code:

  <tr>
    <td><table width = "100%" border="1" bordercolor="maroon">
      <tr>
<?php
$vuong_query = tep_db_query("select categories_id from " . TABLE_GENDER_CATEGORIES . " where parent_id = 1");
while ($product_check = tep_db_fetch_array($vuong_query)) {

	$categories_querys = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . $product_check['categories_id'] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");
    

    $number_of_categories = tep_db_num_rows($categories_querys);

    $rows = 0;
    while ($categories = tep_db_fetch_array($categories_querys)) {
      $rows++;
      $cPath_new = tep_get_path($categories['categories_id']);
      $width = (int)(100 / MAX_DISPLAY_CATEGORIES_PER_ROW) . '%';
      echo '	        <td align="center" class="smallText" width="' . $width . '" valign="top"><a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . tep_image(DIR_WS_IMAGES . $categories['categories_image'], $categories['categories_name'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . '<br>' . $categories['categories_name'] . '</a></td>' . "\n";
      if ((($rows / MAX_DISPLAY_CATEGORIES_PER_ROW) == floor($rows / MAX_DISPLAY_CATEGORIES_PER_ROW)) && ($rows != $number_of_categories)) {
	echo '	      </tr>' . "\n";
	echo '	      <tr>' . "\n";
      }
    }
}
    ?>
      </tr>
       	    </table>
          </td>
        </tr>

 

Thanks anyone for helping me out.

Vanvoquan