$db_s_id = param("scid");
	my $sth = $dbh->prepare (qq{ SELECT * FROM `prods` WHERE ? IN (sub_cat1,sub_cat2,sub_cat3) AND `u` = "1"});
	$sth->execute($db_s_id);
	my $_cell_cnt = 0;
	while($row = $sth->fetchrow_hashref()) {
		$_cell_cnt++;
		$_srp_price = $row->{srp};
		$_table_data .= qq~
			<tr valign="middle">
				<td align="center">
					<a href="javascript:;" onclick="window.open('$_imgurl/ShowPic.cgi?pid=$row->{pid}','POPUP','status=no,menu=no,location=no,resizable=yes,scrollbars=yes,width=400,height=400,top=25,left=25'); return false" onmouseover="window.status='Opens in New window'; return true" onmouseout="window.status=''; return true">~;
	if(-e "/home/<<user_replaced>>/www/images/prod_images/$row->{pid}.gif") {
		$_table_data .= qq~<img src="$_imgurl/images/prod_images/$row->{pid}.gif" width="75" alt="$row->{name}" border="0">~;
	} else {
		$_table_data .= qq~<img src="$_imgurl/images/no_image.gif" width="75" alt="No Image Yet Available. Sorry." border="0">~;
	}
	$_table_data .= qq~</a>
				</td>
				<td align="center">
					<a href="javascript:;" onclick="window.open('$_url?pg=$in{pg}&view=showFullItem&pid=$row->{pid}&nw=1$inc_sess_id','FULLVIEW','status=no,menu=no,location=no,resizable=yes,scrollbars=yes,width=400,height=400,top=25,left=25'); return false" onmouseover="window.status='Opens in New window'; return true" onmouseout="window.status=''; return true">$row->{name}</a><br>~;
	if($row->{instock} && ($row->{instock} == 1)) {
		$_stock_message = "In Stock";
		$_table_data .= qq~[<a href="$_surl?pg=products&view=cart&do=add_prod&pid=$row->{pid}$inc_sess_id">Add to Cart</a>] ~;
	} else {
		$_stock_message = qq~<font class="stand_out">Out of Stock</font>~;
	}
	if($_logged_in && ($_logged_in == 1)) {
		$_table_data .= qq~[<a href="$_url?pg=products&view=wish_list&do=add&id=$row->{pid}$inc_sess_id">Add to Wish List</a>]~;
	}
	$_table_data .= qq~<br>
		$row->{desc}<br>
		Item Number: $row->{pid}~;
	if($row->{itemSize} && ($row->{itemSize} ne "")) {
		$_table_data .= qq~ .:. Size: $row->{itemSize}~;
	}
	$_table_data .= qq~
		$_stock_message~;
	if($row->{uom} && ($row->{uom} ne "")) {
		$_table_data .= qq~ .:. Unit of Measure: $row->{uom}~;
	}
	$_table_data .= qq~
				</td>
				<td align="center" valign="top" style="padding-top: 5px">
					~ . escapeHTML(sprintf("%.2f", "$_srp_price")) . qq~
				</td>
			</tr>
			~;
	}
	$sth->finish();