[mrbiggles]

This is my code and it seems to work for me

<?php 

require "./auth.php"; 
require $xcart_dir."/include/categories.php"; 

$qry = "SELECT * FROM " . $sql_tbl["products"] . " where forsale='Y' order by product"; 
$result = db_query($qry); 

$products = array(); 

while ($result_row = db_fetch_array($result)) { 
  $products[] = $result_row; 
} 

$smarty->assign("main","SEO_listing"); 
$smarty->assign("products",$products); 
func_display("customer/home.tpl", $smarty); 

?>

Regards Adam