SOLVED - Display Product List with Variants

<?php
$myDatabase = JFactory::getDBO();
$query = "SELECT * FROM #__hikashop_product WHERE 1";
$myDatabase->setQuery($query);
$result = $myDatabase->query();
$rows = $myDatabase->loadAssocList();
?>

<table>
	<tr>
		<td>name</td>
		<td>code</td>
	</tr>
<?php
foreach($rows as $row){ 
	if(!strstr($row['product_code'],"N")){
?>
	<tr>
		<td><?php echo $row['product_name']; ?></td>
		<td><?php echo $row['product_code']; ?></td>
	</tr>
<?php }} ?>
</table>

$query = "SELECT * FROM #__hikashop_product WHERE 1";
$myDatabase->setQuery($query);
$result = $myDatabase->query();
$productRows = $myDatabase->loadAssocList();
$myCurrencyHelper = hikashop_get('class.currency');
$myCurrencyHelper->getListingPrices($productRows,hikashop_getZone(),hikashop_getCurrency());
print_r($productRows);

Array ( [0] => Array ( [product_id] => 3177 [product_parent_id] => 3128 [product_name] => random name [product_description] => [product_quantity] => -1 [product_code] => 1234-5678 [product_published] => 1 [product_hit] => 0 [product_created] => 1347941053 [product_sale_start] => 0 [product_sale_end] => 0 [product_delay_id] => 0 [product_tax_id] => 0 [product_type] => variant [product_vendor_id] => 0 [product_manufacturer_id] => 0 [product_url] => [product_weight] => 0.000 [product_keywords] => [product_weight_unit] => kg [product_modified] => 1347941053 [product_meta_description] => [product_dimension_unit] => m [product_width] => 0.000 [product_length] => 0.000 [product_height] => 0.000 [product_max_per_order] => 0 [product_access] => all [product_group_after_purchase] => [product_min_per_order] => 0 [product_contact] => 0 [product_last_seen_date] => 0 [product_sales] => 0 [product_waitlist] => 0 [product_layout] => [product_average_score] => 0 [product_total_vote] => 0 [product_page_title] => [label_color] => multi-color [amount] => ) [1] => Array (...

getListingPrices()