only getting one row?

[justinh]

<div id=\"navbar\">
         Select A Category
        </div>
       <div id=\"items\">";
       $get_cats = mysql_query("SELECT * FROM tbl_category");
       while($cats = mysql_fetch_array($get_cats)){
       echo "<div id=\"category\" onclick=\"location.href=default.php?catid".$cats['cat_id'].";\"><b>".$cats['cat_name']."</b><br>
       <small>".$cats['cat_description']."</small></div></div></div></body></html>";
       }

 

Theres 5 categories in tbl_category,

 

but for some reason: (only one is showing up)

 

http://www.wmptest.com/clintormscart/default.php

 

hmmm..  any ideas?

[justinh]

ughh sorry guys..

 

took a better look at the page, and noticed they're coming in at the bottom =P

 

my mistake.

[wildteen88]

Actually all five are being displayed. It's your HTML that is causing the problem. The following highlighted code should be outside of your while loop:

<div id=\"navbar\">

        Select A Category

        </div>

      <div id=\"items\">";

      $get_cats = mysql_query("SELECT * FROM tbl_category");

      while($cats = mysql_fetch_array($get_cats)){

      echo "<div id=\"category\" onclick=\"location.href=default.php?catid".$cats['cat_id'].";\"><b>".$cats['cat_name']."</b><br>

      <small>".$cats['cat_description']."</small></div></div></div></body></html>";

      }

 

Fixed code:

 <div id=\"navbar\">
         Select A Category
        </div>
       <div id=\"items\">";

$get_cats = mysql_query("SELECT * FROM tbl_category");
while($cats = mysql_fetch_array($get_cats))
{
    echo "<div id=\"category\" onclick=\"location.href=default.php?catid".$cats['cat_id'].";\"><b>".$cats['cat_name']."</b><br>
             <small>".$cats['cat_description']."</small></div>\n";
}
echo "</div></div></body></html>";

[justinh]

thanks for the reply

 

caught it before you said something though

 

Thanks again. maybe i should get some sleep lol