|  | $sql_info = "SELECT  * FROM components WHERE product_id = 1"; | 
|  |  | 
|  | $rs = mysql_query($sql_info, $dbh); | 
|  | <?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 = 2"; | 
|  |  | 
|  | $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>"; | 
|  |  | 
|  |  | 
|  | while ($myrow  = mysql_fetch_assoc($rs)) { | 
|  | foreach($myrow as $key=>$value) { | 
|  | echo $key . " = " . $value . " , "; | 
|  | } | 
|  | echo "<br />"; | 
|  | } | 
|  |  | 
|  |  | 
|  | $dbc->disconnect(); | 
|  |  | 
|  | $rs 		= null; | 
|  | $dbh 		= null; | 
|  | $dbc 		= null; | 
|  |  | 
|  |  | 
|  |  | 
|  | exit(); | 
|  | ?> |