Hello,
This is an script for inserting a medicine + quantity in a database through an autocompletion script. But i can’t seem to make it work keep getting weird errors about unavailible variable.
These are the ones i get:
mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\Middenpolder\recepten\medicijntabel.php on line 81
Notice: Undefined variable: product in C:\xampp\htdocs\Middenpolder\recepten\medicijntabel.php on line 85
Thank you for looking
[code]<?php
include “…/includes/header.php”;
?>
$sql2 = “select order_nr
FROM care_stock_sales_order_medicine
WHERE order_nr =(SELECT MAX(order_nr)
FROM care_stock_sales_order_medicine)”;
$result2 = mysql_query($sql2,$con);
while ($rij = mysql_fetch_array($result2)) {
$order = $rij["order_nr"];
}
if (isset($_POST[“invoer”])) {
$quantity = $_POST["hoeveelheid"];
$order_nr = $order;
$medicine = $_POST["medicine"];
$sql3 = "SELECT product_name,product_nr
FROM care_stock_medicine
WHERE product_name = $medicine";
$result3 = mysql_query($sql3,$con);
while ($rij2 = mysql_fetch_array($result3)) {
$product = $rij2["product_nr"];
}
$product_nr = $product;
$sql = "INSERT INTO care_stock_sales_medicines_per_order(product_nr, order_nr, quantity)
VALUES ($product_nr,$order_nr,$quantity)";
$result = mysql_query($sql, $con) or die ("niet gelukt om $sql uit te voeren op $con");
header("Location:recept.php");
}
?>
[/php]
[code]<form action= “<?php echo($_SERVER["PHP_SELF"]);?>” method=“POST” id=“medicine_form” name=“medicine_form”>
| Naam/Product_nr | Aantal |
|---|---|