<?php
require_once "/home/data/httpd/eclipse-php-classes/system/dbconnection_bugs_ro.class.php";
$dbc 	= new DBConnectionBugs();
$dbh 	= $dbc->connect();
$rs = null;

$sql_info = "SELECT  * FROM components WHERE product_id = 1";

$rs = mysql_query($sql_info, $dbh);


while ($myrow  = mysql_fetch_assoc($rs)) {
foreach($myrow as $key=>$value) {
echo $key . " = " . $value . " , ";
}
echo "<br />";
}

$sql_info = "SELECT  * FROM products";

$rs = mysql_query($sql_info, $dbh);

echo "<h1>Products</h1>";
echo "<table border='1' cellpadding='2' width='80%'>";
echo "<tr><th>ID</th><th>Name</th></tr>";

while ($myrow  = mysql_fetch_assoc($rs)) {
	echo "<tr><td>" . $myrow['id'] . "</td><td>" . $myrow['name'] . "</td></tr>";
	
}
echo "</table>";


$dbc->disconnect();

$rs 		= null;
$dbh 		= null;
$dbc 		= null;


exit();
?>