[Gallery page]

Hi Can some one point me in right direction, My website displays 3 feature ads randomly and I want to show 3 in a row with unlimited rows on one page. how can I do this. the code I have on page is like this:

 

function featured_ads() {

 

//get the featured listings

 

$q1 = "select * from class_catalog, class_categories where class_catalog.CategoryID = class_categories.CategoryID and class_catalog.FeaturedStatus = '1' order by rand() limit 0,3 ";

$r1 = mysql_query($q1) or die(mysql_error());

 

if(mysql_num_rows($r1) > '0')

{

$FeaturedAds .= "<table align=center width=770 cellspacing=0 cellpadding=0 background=\"images/img_17.gif\" border=0><tr>\n\t<td colspan=3 align=left valign=top height=44 align=center valign=top><img src=\"images/img_20a.gif\" height=44 width=770></td>\n</tr>\n\n<tr>\n\t";

 

while($a1 = mysql_fetch_array($r1))

{

$FeaturedAds .= "<td width=255 align=center>\n\n\t\t";

 

$FeaturedAds .= "<table align=center width=220 cellspacing=0 border=1 bordercolor=336699 rules=rows>\n\t\t<tr>\n\t\t";

 

if(!empty($a1[images]))

{

$ShowImage = explode("|", $a1[images]);

$MyText = substr($a1[ProductName], 0, 65)."...";

$FeaturedAds .= "<td width=100 height=96 align=center valign=top><img src=\"images/$ShowImage[0]\" width=100 height=96></td>\n\n\t\t<td width=120 height=96 valign=top><a class=BlackLink href=\"info.php?id=$a1[ProductID]\">$MyText</a></td>\n\t\t</tr>\n\t\t";

}

else

{

$MyText = substr($a1[ProductName], 0, 170)."...";

$FeaturedAds .= "<td width=220 height=100 align=center valign=top><a class=BlackLink href=\"info.php?id=$a1[ProductID]\">$MyText</a></td>\n\t\t</tr>\n\t\t";

}

 

$FeaturedAds .= "</table>\n\n\t";

 

$FeaturedAds .= "</td>\n\n\t";

 

$fa++;

}

 

for($fe = '1'; $fe <= (3 - $fa); $fe++)

{

$FeaturedAds .= "<td width=255> </td>\n\t";

}

 

$FeaturedAds .= "</tr>\n\n";

 

$FeaturedAds .= "<tr>\n\t<td colspan=3 align=center valign=top height=17 align=center valign=top><img src=\"images/img_23.gif\" height=17 width=770></td>\n</tr>\n\n";

 

$FeaturedAds .= "</table>\n\n";

 

return $FeaturedAds;

}

 

}

[Categories add sub catagories]

Hi New to this site can anyone give me short version how to change my website that shows just catagories to display sub catagories..

i know how to set up Mysql ok but just need to know how to add code to include sub cats.  help