Product Finder : Boiling Billy

Boiling Billy Product Finder

NOTE: To find the correct Boiling Billy water unit for you pleae answer the following five questions. Help notes are provided on the right and results will appear at the bottom of the page.

PRODUCT FINDER
Unit Size:			Select the max number of people who may use the unit at any one time.
Unit Type:			Select the type of water desired (optional)
Installation Type:			Select above sink or undersink installation (optional)
Cover:			Select cover type required (above sink units only)
Filtered:			Select "Yes" if filtered water is required (optional)

= $min_cups AND cups_boiling <= $max_cups AND cups_boiling != 0) OR (cups_chilled >= $min_cups AND cups_chilled <= $max_cups AND cups_chilled != 0)) "; } if($unit_type != "all") { $query = $query . " AND unit_type = '$unit_type' "; } if($installation_type != "all") { $query = $query . " AND installation_type = '$installation_type' "; } if($cover != "all") { $query = $query . " AND cover = '$cover' "; } if($filtered != "all") { $query = $query . " AND filtered = '$filtered' "; } $result = mysql_query($query); $num_rows = mysql_num_rows($result); echo '

Your Search Returned ' . $num_rows . ' Product Matches

'; if($num_rows != "0") { echo'

For pricing please select the products you wish to be quoted on and press "Get Quote"

For more information on a product please click on the product name.

'; } $i = "1"; while ($row = mysql_fetch_array($result)) { echo ''; echo ''; echo ''; $i++; } echo '

*

P/Code

Capacity

Installation
Type

Unit
Type

Product Series

Cups
(HOT)

Cups
(COLD)

Filtered

Cover

' . $row['product_code'] . '

' . $row['capacity'] . ' Litre

' . $row['installation_type'] . '

' . $row['unit_type'] . '

' . $row['series_name'] . '

' . $row['cups_boiling'] . '

' . $row['cups_chilled'] . '
'; if($row['filtered'] == "1") {echo '';} elseif($row['filtered'] == "0") {echo '';} echo '
' . $row['cover'] . '

'; mysql_close(); } ?>

Return to top