Hi,

I have (some how) managed to build a MySQLi join query. However I cant figure out how to echo the resuls inside HTML.

I have echoed $long_name and $name here

Code:
/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}


$room = mysql_real_escape_string($_GET['room']);

echo $room; 

$query = "SELECT long_name, name
									FROM furniture_groups a
									INNER JOIN productdbase b
									ON a.id = b.product_id
									WHERE `room` = '$room'  LIMIT 15
									";	 	 
								
					if ($result = $mysqli->query($query)) {
					
 while ($row = $result->fetch_assoc()) {
        printf ("%s (%s)\n", $row["long_name"], $row["name"]);
    	


    ?>
But I would to echo it here inside the HTML.

Code:
<div class="productrangeborder">
<div class="productsdetailsborder">
<a href="http://domain.co.uk/products/product/<?php echo $query_row['long_name']; ?>" class='productlink' rel="nofollow" ><?php echo $query_row['name']; ?>
</a>
</div>

</div></div>

<?php

}
}

?>