function

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';