Echo MySQLi Inside HTML (Join Function)

[justlukeyou]

Hi,

 

I have by means of complete fluke managed to build a MySQLi join query. However I cant figure out how to echo the results inside HTML.

 

I have echoed $long_name and $name here:

 

/* 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 like to echo it here inside the HTML.

 

<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

}
}

?>

[requinix]

Have you tried, I dunno, copy and pasting the code into that spot?

[justlukeyou]

Oh right,

 

Its alot messier than MySQL.