Untitled

<form name = 'form' method = 'post' action =''>
    <select name = "medicine" onChange = "this.form.submit();">
        <?php
            $query =  mysql_query("SELECT  medicine, meddesc, exp_date FROM farm1_medicine_inventory");
            while($row=mysql_fetch_array($query)){
                echo "<option value = '".$row['medicine']."'>".$row['medicine']."</option>";
            }
        ?>
    </select>
</form>

<?

    //start a session
    session_start();
    error_reporting(0);
        $user  = $_SESSION['username'];
    if ($user) {
?><?php
    }

else {
    die ("You are not logged in sir!");
    }

?>
<?php
    // create the parameters needed to connect to the mysql database server
    $host = 'localhost';
    $username = 'root';
    $password = '';
    $db = 'flockperformance';
    $table_name='farm1_medicine';

    // create the connection; if an error occurs display the error
    $connection = mysql_connect($host, $username, $password) or die(mysql_error());

    // select the database to use; if an error occurs display the error
    //$db = mysql_select_db($db) or die(mysql_error());
    $db = mysql_select_db($db) or die("Could not open a connection to the database server");

    // get the value of p


    if (isset($_REQUEST['submit']))
    {
        $id = $_REQUEST['id'];
        $dateused = date('Y-M-j');
        $medicine = $_REQUEST['medicine'];
        $meddesc = $_REQUEST['meddesc'];
        $exp_date = $_REQUEST['exp_date'];
        $quantity = $_REQUEST['quantity'];

    if(!$dateused OR !$medicine OR !$meddesc OR !$quantity){
        $message = "fill";
            }else {


        $query = "insert into $table_name set
                            medicine = '$medicine',
                            meddesc = '$meddesc',
                            exp_date = '$exp_date',
                            quantity = '$quantity',
                            dateused = '$dateused'
                            ";

                        $get= mysql_query("SELECT * FROM farm1_medicine_inventory where medicine = '$medicine'");
                        $getqty=mysql_fetch_assoc($get);
                        $newqty=$getqty['quantity']-$quantity;
                        $update=mysql_query("UPDATE farm1_medicine_inventory SET quantity='$newqty' where medicine = '$medicine'");
                    echo $newqty;

                $qry=mysql_query($query);

                    $message = "
                            <p align='center'><em><strong>$medicine and $quantity</strong></em>
                            was successfully added...</p>
                           ";

    }}
/*
    if ($p == 'Insert New')
    {
        // set the insert new flag to true
        $insertNew = true;
    }
*/
?>
<html>
<title>Add Records</title>
<body bgcolor='orange'>
<font face='tahoma'>
&nbsp
<h1 align='center'>ADD Records - Farm 1</h1>
<h2 align='center'><em>Add a New Record to the Table</em></h2>
<form name='F1' method='post' action=''>

    <!-- <input type='submit' name='p' value='Insert New'>
    <?
        $insertNew = true;
    ?>
<!-------------------------------------------------------------------------------------->
<?
    if ($insertNew) // if the value of insertNew is true
    {
    ?>
    <hr>
    <br>
    <table align='center' width='75%' border cellspacing='2' cellpadding='2' bgcolor='white'>


        <tr>
            <td align='center'><font face='tahoma' size='2'><b>Date Used</td>
            <td align='center'><? echo date('Y-M-j');?></td>
        </tr>
        <tr>
            <td align='center'><font face='tahoma' size='2'><b>Medicine</td>
            <td align="center">
                <form name = 'form' method = 'post' action =''>
                <select name = "medicine" onChange = "this.form.submit();">
            <?php
                $query =  mysql_query("SELECT  medicine, meddesc, exp_date FROM farm1_medicine_inventory");
                while($row=mysql_fetch_array($query)){
                echo "<option value = '".$row['medicine']."'>".$row['medicine']."</option>";
            }
            ?>
            </select>
            </form>
            </td>
        </tr>

        <tr>
            <td align='center'><font face='tahoma' size='2'><b>Medicine Description</td>
            <td align='center'><input name='meddesc'
            value = '<? $query =  mysql_query("SELECT  medicine, meddesc, exp_date FROM farm1_medicine_inventory");
            $row=mysql_fetch_array($query);
            echo "" . $row['meddesc'] . "";
            ?>' size='75%' maxlength='50'>
            </td>
        </tr>

        <tr>
            <td align='center'><font face='tahoma' size='2'><b>Expiration Date:</td>
            <td align='center'><input name='exp_date' size='75%' maxlength='50'></td>
        </tr>

        <tr>
            <td align='center'><font face='tahoma' size='2'><b>Quantity:</td>
            <td align='center'><input name='quantity' size='75%' maxlength='50'></td>
        </tr>

        <tr>
            <td align='center'><input type='submit' name='submit' value='Save New Entry'></td>
            <td align = 'center'><?

            echo "$message";

            ?></td>
        </tr>
    </table>
    <br>
    <hr>

    <?
    }
    ?>
<!-------------------------------------------------------------------------------------->
</form>
</font>
</body>
</html>