0 ){ echo "

Record already exist. Please check your entry and try again. Thank You!




"; }else { $sql="INSERT INTO `medicines` (`medicine_id`,`medicine_desc`, `medicine_price`, `type`, `UoM`,`encoded_by`) VALUES('','$medname','$price','$medtype','$UoM','$user')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ echo "

New record has been added to database.




"; } } } $checkAccess = $user_data['add_new_medicine']; if($checkAccess == '0'){ secalert(); }else{ ?> "; echo ""; }else{ echo "
MEDICINE MASTERFILE                      Search Item:
"; echo ""; $q=mysql_query("SELECT * FROM `medicines` WHERE `medicine_desc` LIKE '%$searchtext%' || `item_code` LIKE '%$searchtext%'"); $row=mysql_fetch_array($q); $total=mysql_num_rows($q); $dis=10; $total_page=ceil($total/$dis); $page_cur=(isset($_GET['page']))?$_GET['page']:1; $k=($page_cur-1)*$dis; $page_cur = mysql_real_escape_string($page_cur); $qq=mysql_query("SELECT * FROM `medicines` WHERE `medicine_desc` LIKE '%$searchtext%' || `item_code` LIKE '%$searchtext%'"); echo ""; echo ""; while($row = mysql_fetch_array($qq)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo ""; echo "
Item I.D Item Code Item Description Item Type UoM Price Stock On-Hond -
" . $row['medicine_id'] . "" . $row['item_code'] . "" . $row['medicine_desc'] . "" . $row['type'] . "" . $row['UoM'] . "" . $row['medicine_price'] . ""; $itemID = $row['medicine_id']; $onHand = mysql_result(mysql_query("SELECT `item_qty` FROM `inventory` WHERE `item_id`='$itemID'"),0); echo $onHand; echo "Update
"; echo "
"; echo ""; echo ""; echo ""; echo "

Item Information:


     Description:
     

     Category:    
     

"; echo "

     Unit Price:
     


"; } ?>