if ($i % 2 == 0) {
        $style = "style='background-color:Khaki'";
    } else {
        $style = "";
    }
    echo "<tr {$style} >";
    echo "<td><span class='clickspot' onclick='getDesc({$row['manufacturer_id']})'>{$row['manufacturer_name']}<span></td>";
    echo "<td>{$row['manufacturer_id']}</td>";
    echo "<td>{$row['address']}</td>";
    echo "<td><a href='ed.php'>edit</a> -- <a href='searchManufacturer.php?manufacturer_name={$row['manufacturer_name']}'>delete</a></td>";
    echo "</tr>";
    $row = $obj->fetch();
    $i++;
}
if (isset($_REQUEST['manufacturer_name'])) {
    echo $_REQUEST['manufacturer_name'];
    $obj = new manufacturer();
    $manufacturer_name = $_REQUEST['manufacturer_name'];
    if (!$obj->delete_manufacturer($manufacturer_name)) {
        echo "Error deleting" . mysql_error();
    } else {
        header("location:searchManufacturer.php");
    }
}
?>
    
</div>

</body>
</html>
}}}}