include './htdocs/db_config.php';
include './htdocs/db_open.php';
$query = "select * from coc, img WHERE coc.fkimg = img.img_id ";
$result = mysql_query($query);
echo "<table>\n<tr><th>ID</th><th>Manufactuer</th><th>Model</th><th>Image Date</th><th>Image</th><th>Available</th><th>Inventory Status</th></tr>\n";
$i = 1;
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo "<tr ". isodd($i) .">";
echo "<td>" . $row['coc_id']."</td>";
echo "<td>" . $row['coc_man']."</td>"; 
echo "<td>". $row['coc_model']. "</td>"; 
echo "<td>". $row['coc_imgdate']."</td>"; 
echo "<td>". $row['img_name']. "</td>"; 
echo "<td>";if ($row['coc_aval'] == 0) { echo "Not Avaialbe";}else{echo "Available";}echo "</td>";
echo "<td>"; if($row['coc_invstatus']== 0){echo "OUT";}else{echo "IN";}echo "</td>";
echo "</tr>\n";
$i++;
}
echo "</table>\n";
include './htdocs/db_close.php';