Jump to content

testing to see if a value (int) is in an array. Help

paulsinclair

By paulsinclair
in PHP Coding Help

 Share

Recommended Posts

paulsinclair Newbie

paulsinclair

Posted
Posted

Hi.  I am trying to test to see if a particular record id (int) is included in array.

 

This is the code I am using

 

                            $sql2 = "SELECT `id` FROM `orderitems` WHERE `orderid` = '" . $orderid . "'";
                            $orderlist = mysql_query($sql2) or trigger_error(mysql_error() . '<br />Query was:' . $sql2);
                            $orderarray = array();
                            while ($orderitem = mysql_fetch_array($orderlist));
                            (
                            $orderarray[] = $orderitem['id'];
                            )
                            $prodid=$row['prodid'];
                            if (in_array($prodid, $orderarray)) {
                                echo "<td> In.</td>";
                            } else {
                                echo "<td> Out.</td>";
                            }

 

Every case is outputting "Out" even though some should pass.  I have verified that the variables are outputting the correct thing, but am not sure about the array.

 

I am just a beginner, so i am hoping there is something really obvious I am doing wrong.

 

 

Thanks for reading this.

Link to comment
Share on other sites
paulsinclair Newbie

paulsinclair

Posted
  • Author
Posted

Here is the earlier code, but I have verified that $prodid is being correctly created.

 

                        switch ($pricing) {
                            case 2; {
                                    $sql = "SELECT `prodid`, `description`, `wholesale` AS `price` FROM `products` WHERE `prodtype` = '" . $prodtype . "'";
                                    break;
                                }
                            default; {
                                    $sql = "SELECT `prodid`, `description`, `retailprice` AS `price` FROM `products` WHERE `prodtype` = '" . $prodtype . "'";
                                    break;
                                }
                        }
                        $products = mysql_query($sql) or trigger_error(mysql_error() . '<br />Query was:' . $sql);

                        while ($row = mysql_fetch_array($products)) {

Link to comment
Share on other sites
paulsinclair Newbie

paulsinclair

Posted
  • Author
Posted

OK.  I thought I was making it easier but will do.  Thank you.

 

<?
include("include/session.php");

if (!$session->logged_in) {
    header("Location: index.php");
} else {
    include("header.php");
?>
    <HTML>
        <HEAD>
        <?
        echo "<title>" . PROJECT_NAME . "</title>";
        $req_user = trim($session->username);
        $req_user_info = $database->getUserInfo($req_user);
        $userlevel = $req_user_info['userlevel'];

        echo "<link href=\"" . $stylesheet . "\" rel=\"stylesheet\" type=\"text/css\">";
        ?>
    </HEAD>
    <BODY>

        <?
        $dealer = $req_user_info['dealer'];
        $dealer_info = $database->getdealerInfo($dealer);
        $client = $req_user_info['client'];
        $client_info = $database->getClientInfo($client);
        $stylesheet = $client_info['css'];
        $prodtype_info = $database->getProdTypeInfo($_REQUEST['prodtype']);
        $product_info = $database->getProductInfo($_REQUEST['prodid']);
        $custid = mysql_real_escape_string($_REQUEST['custid']);
        $cust_info = $database->getCustomerInfo($custid);
        $pricing = $cust_info['pricing'];
        $req_user = trim($session->username);
        $req_user_info = $database->getUserInfo($req_user);
        $username = $req_user_info['username'];
        $orderid = mysql_real_escape_string($_REQUEST['orderid']);
        $layoutid = mysql_real_escape_string($_REQUEST['layout']);
        $order_info = $database->getOrderInfo($orderid);
        $todaydisplay = date('d-m-Y');
        $today = date('Y-m-d');
        $camper_info = $database->getCamperInfo($order_info[camper]);

        echo "<H2><p align=\"center\">Order for " . $cust_info['customername'] . " - " . $camper_info['description'] . "</p></H2>";
        include("include/cust_buttons.php");
        switch ($_REQUEST['action']) { // Action Selection Start
            case "select";
                {
                    $sql = "INSERT INTO `orders` (`orderid`, `client`, `custid`, `created`, `createdby` , `updatedby`, `status`) VALUES (NULL, '" . $client . "', '" . $custid . "', '" . $today . "', \"" . $username . "\", \"" . $username . "\", '1');";
                    $executed = mysql_query($sql) or trigger_error(mysql_error() . '<br />Query was:' . $sql);
                    if ($executed) {
                        $orderid = mysql_insert_id();
                    }
                    $followupperiod = $client_info['quote_expiry_warning'];
                    $followupdt = time() + $followupperiod * 24 * 60 * 60; //quote expiry followup days from client record.
                    $followupdt = strftime("%Y-%m-%d", $followupdt);
                    $database->addActivity(1, "Quote # '" . $orderid . "' created", 1, $client, $custid, $today, $username, $followupdt);
                    break;
                }
            case "updatelayout"; {
                    $database->updateOrderField($orderid, 'layout', $layoutid);
                    break;
                }
            case "insertmisc"; {
                    $description = mysql_real_escape_string($_REQUEST['description']);
                    $price = mysql_real_escape_string($_REQUEST['price']);
                    $prodid = 999999;
                    $sql = "INSERT INTO `orderitems` (`id`, `orderid`, `productid`, `description`, `price`, `created`, `createdby`, `qty`) VALUES (NULL, '" . $orderid . "', '" . $prodid . "', '" . $description . "', '" . $price . "', '" . $today . "', \"" . $username . "\", '1')";
                    $executed = mysql_query($sql) or trigger_error(mysql_error() . '<br />Query was:' . $sql);
                    if ($executed) {
                        
                    }
                    $sql = "SELECT `price`, `discprice`, `lineitems` FROM `orders` WHERE `orderid` = '" . $orderid . "'";
                    $orders = mysql_query($sql) or trigger_error(mysql_error() . '<br />Query was:' . $sql);

                    while ($row = mysql_fetch_array($orders)) {
                        $cum_price = $row['price'];
                        $cum_disc_price = $row['discprice'];
                        $totalitems = $row['lineitems'];
                    }
//  **Problem with the price and the cumulative price.  Poss confusion with discount price.
                    $totalprice = $cum_price + $price;
                    $totaldiscprice = $cum_disc_price + $price;
                    $totalitems = $totalitems + 1;
                    $database->updateOrderField($orderid, 'price', $totalprice);
                    $database->updateOrderField($orderid, 'discprice', $totaldiscprice);
                    $database->updateOrderField($orderid, 'lineitems', $totalitems);
                    break;
                }
            case "displaycategory"; {
//       Display all products in the selected category as a form to select an item.
                    if ($prodtype_info['misc'] == 1) {
                        echo "<form action=create_order.php method=post>";
                        echo "<table border=0 cellpadding=0 cellspacing=0 align=center>";
                        echo "<tr><td><input type=hidden size=20 name=action value=\"insertmisc\"></td></tr>";
                        echo "<tr><td><input type=hidden size=20 name=custid value='" . $custid . "'></td></tr>";
                        echo "<tr><td><input type=hidden size=20 name=orderid value='" . $orderid . "'></td></tr>";
                        echo "<tr><td><b>Description:</b></td><td><input type=text size=30 name=description></td></tr>";
                        echo "<tr><td><b>Price:</b></td><td><input type=text size=10 name=price></td></tr>";
                        echo "<tr><td></td><td><input type=submit border=0 value=\"Submit\"></td></tr>";
                        echo "</table>";
                        echo "</form>";
                        echo "<br>";
                    } else {
                        echo "<br>";
                        echo "<table border=0 cellpadding=0 cellspacing=0 align=center>";
                        $prodtype = $_REQUEST['prodtype'];
                        //         echo "Pricing is ".$pricing."<br>";
                        switch ($pricing) {
                            case 2; {
                                    $sql = "SELECT `prodid`, `description`, `wholesale` AS `price` FROM `products` WHERE `prodtype` = '" . $prodtype . "'";
                                    break;
                                }
                            default; {
                                    $sql = "SELECT `prodid`, `description`, `retailprice` AS `price` FROM `products` WHERE `prodtype` = '" . $prodtype . "'";
                                    break;
                                }
                        }
                        $products = mysql_query($sql) or trigger_error(mysql_error() . '<br />Query was:' . $sql);

                        while ($row = mysql_fetch_array($products)) {
                            echo "<tr><td><a href=\"create_order.php?action=additem&orderid=" . $orderid . "&custid=" . $custid . "&prodid=" . $row['prodid'] . "\">" . $row['description'] . "</a></td><td><img src=images/blank.gif width=20 height=10></td><td class=tabclearright>" . $row['price'] . "</td>";
                            $sql2 = "SELECT `id` FROM `orderitems` WHERE `orderid` = '" . $orderid . "'";
                            $orderlist = mysql_query($sql2) or trigger_error(mysql_error() . '<br />Query was:' . $sql2);
                            $orderarray = array();
                            while ($orderitem = mysql_fetch_array($orderlist));
                            (
                            $orderarray[] = $orderitem['id'];
                            )
                            $prodid=$row['prodid'];
                            if (in_array($prodid, $orderarray)) {
                                echo "<td> In.</td>";
                            } else {
                                echo "<td> Out.</td>";
                            }
                            echo "</tr>";
                        }
                        echo "<tr><td><img src=images/blank.gif width=20 height=10></td></tr>";
                        echo "<tr><td class=tabclearcenter><a href=\"create_order.php?action=select&custid=" . $custid . "\">Back</a></td><td><img src=images/blank.gif width=20 height=10></td><td class=tabclearright>" . $row['retailprice'] . "</td></tr>";

                        echo "</table>";
                    }
                    exit;
                }  //  Loop through all items in selection  - END
            case "additem"; {
//       Insert Line item to database
//       Find price of item and add price to entry.

                    $prodid = $_REQUEST['prodid'];
                    $sql = "SELECT `retailprice`,`wholesale` FROM `products` WHERE `prodid` = '" . $prodid . "'";
                    $products = mysql_query($sql) or trigger_error(mysql_error() . '<br />Query was:' . $sql);

                    while ($row = mysql_fetch_array($products)) {
                        switch ($pricing) {
                            case 2; {
                                    $price = $row['wholesale'];
                                    break;
                                }
                            default; {
                                    $price = $row['retailprice'];
                                    break;
                                }
                        }
                    }
                    $sql = "INSERT INTO `orderitems` (`id`, `orderid`, `productid`, `price`, `created`, `createdby`, `qty`) VALUES (NULL, '" . $orderid . "', '" . $prodid . "', '" . $price . "', '" . $today . "', \"" . $username . "\", '1')";
                    $executed = mysql_query($sql) or trigger_error(mysql_error() . '<br />Query was:' . $sql);
                    if ($executed) {

                        $prodtype_info = $database->getProdTypeInfo($product_info['prodtype']);
                        if ($prodtype_info['camper'] == 1) {
                            $sql = "select camper_components.productid  from camper_components,campers where campers.camperid = camper_components.camperid and campers.productid = '" . $prodid . "'";
                            $stditems = mysql_query($sql) or trigger_error(mysql_error() . '<br />Query was:' . $sql);

                            while ($row = mysql_fetch_array($stditems)) {
                                $stdproduct_info = $database->getProductInfo($row['productid']);

                                $sql = "INSERT INTO `orderitems` (`id`, `orderid`, `productid`, `price`, `created`, `createdby`, `qty`, `std`) VALUES (NULL, '" . $orderid . "', '" . $stdproduct_info['prodid'] . "', '0', '" . $today . "', \"" . $username . "\", '1', '1')";
                                $executed = mysql_query($sql) or trigger_error(mysql_error() . '<br />Query was:' . $sql);
                                if ($executed) {
                                    
                                }
                            }
                            $camper_info = $database->getCamper_ProdInfo($prodid);
                            $database->updateOrderField($orderid, 'camper', $camper_info['camperid']);
                        }
                    }

                    $cum_price = $order_info['price'];
                    $cum_disc_price = $order_info['discprice'];
                    $totalitems = $order_info['lineitems'];

                    $totalprice = $cum_price + $price;
                    $totaldiscprice = $cum_disc_price + $price;
                    $totalitems = $totalitems + 1;
                    $database->updateOrderField($orderid, 'price', $totalprice);
                    $database->updateOrderField($orderid, 'discprice', $totaldiscprice);
                    $database->updateOrderField($orderid, 'lineitems', $totalitems);
                    $order_info = $database->getOrderInfo($orderid);

                    break;
                }
            case "delitem"; {
                    // Need to update order header record and delete line item.

                    $orderitemid = $_REQUEST['orderitemid'];
                    $product_info = $database->getProductInfo($_REQUEST['prodid']);
                    $retailprice = $product_info['retailprice'];
                    $sql = "DELETE FROM `orderitems` WHERE `id` = '" . $orderitemid . "'";
                    $executed = mysql_query($sql) or trigger_error(mysql_error() . '<br />Query was:' . $sql);
                    if ($executed) {

                        $prodtype_info = $database->getProdTypeInfo($product_info['prodtype']);
                        if ($prodtype_info['camper'] == 1) {
                            $sql1 = "delete from orderitems where std = 1 and orderid = '" . $orderid . "'";
                            //echo $sql1;
                            $executed = mysql_query($sql1) or trigger_error(mysql_error() . '<br />Query was:' . $sql);
                            if ($executed) {
                                $database->updateOrderField($orderid, 'camper', 0);
                            }
                        }
                    }
                    $cum_price = $order_info['price'];
                    $cum_disc_price = $order_info['discprice'];
                    $totalitems = $order_info['lineitems'];
                    $totalprice = $cum_price - $retailprice;
                    $totaldiscprice = $cum_disc_price - $retailprice;
                    $totalitems = $totalitems - 1;
                    $database->updateOrderField($orderid, 'price', $totalprice);
                    $database->updateOrderField($orderid, 'discprice', $totaldiscprice);
                    $database->updateOrderField($orderid, 'lineitems', $totalitems);
                    $order_info = $database->getOrderInfo($orderid);
                    break;
                }
            case "listorder"; {

                    break;
                }
            case "updateorderitem"; {
                    $orderitemid = mysql_real_escape_string($_REQUEST['orderitemid']);
                    $sql = "UPDATE `orderitems` SET `price` = '" . $_REQUEST['price'] . "', `qty` = '" . $_REQUEST['qty'] . "'  WHERE `id` = '" . $orderitemid . "'";
                    $executed = mysql_query($sql) or trigger_error(mysql_error() . '<br />Query was:' . $sql);
                    if ($executed) {
                        include("include/recalc_order.php");
                    }

                    //update order total.

                    break;
                }
            case "editorderitem"; {

                    $custid = mysql_real_escape_string($_REQUEST['custid']);
                    $orderid = mysql_real_escape_string($_REQUEST['orderid']);
                    $orderitemid = mysql_real_escape_string($_REQUEST['orderitemid']);
                    $sql = "SELECT `id`, `orderid`, `products`.`description` AS `description`, `price`, `qty` FROM `orderitems`,`products` WHERE `orderitems`.`productid` = `products`.`prodid` AND `id` = '" . $orderitemid . "'";
                    $result = mysql_query($sql) or trigger_error(mysql_error() . '<br />Query was:' . $sql);
                    while ($row = mysql_fetch_array($result)) {
                        echo "<form action=create_order.php method=get>";
                        echo "<table border=0 cellpadding=0 cellspacing=0 align=center>";
                        echo "<tr><td></td><td></td></tr>";
                        echo "<tr><td></td><td><input type=hidden size=20 name=action value=\"updateorderitem\"></td></tr>";
                        echo "<tr><td></td><td><input type=hidden size=20 name=custid value='" . $custid . "'></td></tr>";
                        echo "<tr><td></td><td><input type=hidden size=20 name=orderid value='" . $orderid . "'></td></tr>";
                        echo "<tr><td></td><td><input type=hidden size=20 name=orderitemid value='" . $orderitemid . "'></td></tr>";
                        echo "<tr><td><b>Description:</b></td><td>" . $row['description'] . "</td></tr>";
                        echo "<tr><td><b>Price:</b></td><td><input type=text size=20 name=price value=\"" . $row['price'] . "\"></td></tr>";
                        echo "<tr><td><b>Qty:</b></td><td><input type=text size=10 name=qty value=\"" . $row['qty'] . "\"></td></tr>";
                        echo "<tr><td></td><td><input type=submit border=0 value=\"Submit\"></td></tr>";
                        echo "</table>";
                        echo "</form>";
                        echo "<br>";
                    }
                    exit;
                }
            case "editorder"; {
//       Create form to add discount and validate, and change the status of a order.

                    echo "<H2><p align=\"center\">Edit order #" . $_REQUEST['orderid'] . "</p></H2>";
                    $client_info = $database->getClientInfo($client);
                    $layout = $order_info['layout'];
                    $layout_info = $database->getlayoutInfo($layout);
                    echo "<form action=create_order.php method=post>";
                    echo "<table border=0 cellpadding=0 cellspacing=0 align=center>";
                    echo "<tr><th><input type=hidden size=20 name=action value=\"update\">";
                    echo "<tr><th><input type=hidden size=20 name=custid value='" . $custid . "'>";
                    echo "<tr><th><input type=hidden size=20 name=orderid value='" . $orderid . "'></td></tr>";
                    echo "<tr><th rowspan=\"16\"><a href=\"select_camper_layout.php?custid=" . $custid . "&orderid=" . $orderid . "\"><img src=images/blank.gif width=20 height=10><img src=camper_layouts/" . $layout_info['file_location'] . " width=180 height=300 border = 2 alt=\"Select Layout\"></a><img src=images/blank.gif width=20 height=10>";
                    echo "<tr><td><b> Sales Rep:</b></td><td> <select name=\"salesrep\">";
                    $selectedsalesrep = $order_info['salesrep'];
                    $sql = "SELECT `id`, `lastname` FROM `salesreps` WHERE `client` = " . $client . " ORDER BY `lastname`;";
                    $salesreps = mysql_query($sql) or trigger_error(mysql_error() . '<br />Query was:' . $sql);
                    while ($salesrep = mysql_fetch_array($salesreps)) {

                        if ($salesrep['id'] == $selectedsalesrep) {
                            echo "<option selected value='" . $salesrep['id'] . "'>" . $salesrep['lastname'] . "</option>";
//                        echo "<option selected value='".$type['id']."'>Selected</option>";
                        } else {
                            echo "<option value='" . $salesrep['id'] . "'>" . $salesrep['lastname'] . "</option>";
                        }
                    }
                    echo "<tr><td><b> Quote #:</b></td><td>" . $order_info['quoteid'];
                    echo "<tr><td><b> Created by:</b></td><td>" . $order_info['createdby'];
                    echo "<tr><td></td><td><input type=hidden size=20 name=price value='" . $order_info['price'] . "'></td></tr>";
                    echo "<tr><td><b>Price:</b></td><td>" . $order_info['price'] . "</td></tr>";
                    echo "<tr><td><b>Discount:</b></td><td><input type=text size=30 name=discount value=\"" . $order_info['discount'] . "\"></td></tr>";
                    echo "<tr><td><b>Discount Price:</b></td><td>" . $order_info['discprice'] . "</td></tr>";
                    echo "<tr><td><b>Line Items:</b></td><td>" . $order_info['lineitems'] . "</td></tr>";
                    echo "<tr><td><b>Show Standard:</b></td><td> <select name=\"showdetail\">";
                    switch ($order_info['showdetail']) {
                        ;
                        case 0; {
                                echo "<option selected value='0'>No</option>";
                                echo "<option value='1'>Yes</option></td></tr>";
                            }
                        case 1; {
                                echo "<option value='0'>No</option>";
                                echo "<option selected value='1'>Yes</option></td></tr>";
                            }
                    }
                    echo "<tr><td><b>Status:</b></td><td> <select name=\"status\">";
                    $selectedstatus = $order_info['status'];

                    $sql = "SELECT `id`, `description` FROM `od_status` WHERE `status` = '1' ORDER BY `description`;";
                    $statuses = mysql_query($sql) or trigger_error(mysql_error() . '<br />Query was:' . $sql);
                    while ($status = mysql_fetch_array($statuses)) {

                        if ($status['id'] == $selectedstatus) {
                            echo "<option selected value='" . $status['id'] . "'>" . $status['description'] . "</option>";
//                        echo "<option selected value='".$type['id']."'>Selected</option>";
                        } else {
                            echo "<option value='" . $status['id'] . "'>" . $status['description'] . "</option>";
                        }
                    }
                    echo "<tr><td><b>Stage:</b></td><td> <select name=\"stage\">";
                    $selectedstage = $order_info['stage'];

                    $sql = "SELECT `id`, `factory_description` FROM `stage`  ORDER BY `seqno`;";
                    $stages = mysql_query($sql) or trigger_error(mysql_error() . '<br />Query was:' . $sql);

                    while ($stage = mysql_fetch_array($stages)) {

                        if ($stage['id'] == $selectedstage) {
                            echo "<option selected value='" . $stage['id'] . "'>" . $stage['factory_description'] . "</option>";
                        } else {
                            echo "<option value='" . $stage['id'] . "'>" . $stage['factory_description'] . "</option>";
                        }
                    }
                    echo "<tr><td><b>Expected Delivery Date:</b></td><td><input type=text size=30 name=exp_delivery value=\"" . $order_info['exp_delivery'] . "\"></td></tr>";
                    echo "<tr><td><b>Actual Delivery Date:</b></td><td><input type=text size=30 name=act_delivery value=\"" . $order_info['act_delivery'] . "\"></td></tr>";
                    echo "<tr><td><b>Customer Reference:</b></td><td><input type=text size=30 name=custref value=\"" . $order_info['custref'] . "\"></td></tr>";
                    echo "<tr><td><b>VIN:</b></td><td><input type=text size=30 name=VIN value=\"" . $order_info['VIN'] . "\"></td></tr>";
                    echo "<tr><td></td><td><input type=submit border=0 value=\"Submit\"></td></tr>";
                    echo "</table>";
                    echo "</form>";
                    echo "<br>";
                    exit;
                }
            case "update"; {
                    $sql = "SELECT `status` FROM `orders` WHERE `orderid` = '" . $orderid . "'";
//          echo $sql;
                    $orders = mysql_query($sql) or trigger_error(mysql_error() . '<br />Query was:' . $sql);

                    while ($row = mysql_fetch_array($orders)) {
                        $currentstatus = $row['status'];
                    }
                    $discount = mysql_real_escape_string($_REQUEST['discount']);
                    $showstd = mysql_real_escape_string($_REQUEST['showdetail']);
                    $price = $_REQUEST['price'];
                    $stage = $_REQUEST['stage'];
                    if ($price > 0) {
                        $discrate = $discount / $price;
                    } else {
                        $discrate = 0;
                    }
                    if ($discrate < 0.10) {
                        $discprice = $price - $discount;
                    }
                    $orderid = $_REQUEST['orderid'];
//             echo "Order is ".$orderid;
                    $sql = "UPDATE `orders` SET `discount` = '" . $discount . "', `discprice` = '" . $discprice . "', `showdetail` = '" . $showstd . "', `status` = '" . $_REQUEST['status'] . "',  `stage` = '" . $_REQUEST['stage'] . "', `exp_delivery` = '" . $_REQUEST['exp_delivery'] . "',`act_delivery` = '" . $_REQUEST['act_delivery'] . "',`custref` = '" . $_REQUEST['custref'] . "',`VIN` = '" . $_REQUEST['VIN'] . "',`updatedby`  = '" . $username . "'  WHERE `orderid` = '" . $orderid . "'";
//             echo $sql;
                    $executed = mysql_query($sql) or trigger_error(mysql_error() . '<br />Query was:' . $sql);
                    if ($executed) {
                        
                    }
                    if ($_REQUEST['action'] <> $currentstatus) {
                        switch ($_REQUEST['status']) { // Status Selection Start
                            //Open
                            case 1; {
                                    
                                }
                            // Order Taken
                            case 2; {
                                    
                                }
                            // Withdrawn
                            case 3; {
                                    
                                }
                            // Expired
                            case 4; {
                                    
                                }
                            // Paid
                            case 6; {
                                    $followupperiod = $client_info['quote_followup'];
                                    $followupdate = time() + $followupperiod * 24 * 60 * 60; //quote followup days from client record.
                                    $followupdate = strftime("%Y-%m-%d", $followupdate);
                                    $sql = "INSERT INTO `activities` (`actid`, `client`, `custid`, `created`, `createdby`, `acttype`,`comments`,`followedup`) VALUES (NULL, '" . $client . "', '" . $custid . "', '" . $today . "', '" . $username . "', '2',\"Order # " . $orderid . " Paid\",'1');";
                                    $executed = mysql_query($sql) or trigger_error(mysql_error() . '<br />Query was:' . $sql);
                                    if ($executed) {

                                    }
                                    break;
                                }
                        }  //End Switch on Status
                    }  // End If Current status has changed
                }  // End Switch on Update
                break;
        }  // End Update
        include ("include/display_order.php");
//        include ("display_production_sheet.php");

        echo "<br>";
        echo "<table border=0 cellpadding=0 cellspacing=0 align=center>";
        $sql = "SELECT `id`, `description` FROM `prodtype` WHERE `client` = " . $client . " ORDER BY `id`;";
        $prodtypes = mysql_query($sql) or trigger_error(mysql_error() . '<br />Query was:' . $sql);
        while ($row = mysql_fetch_array($prodtypes)) {
            echo "<tr><td><a href=\"create_order.php?action=displaycategory&orderid=" . $orderid . "&custid=" . $custid . "&prodtype=" . $row['id'] . "\">" . $row['description'] . "</a></td></tr>";
        }
        echo "</table>";
        echo "<br>";

        include ("include/footer.php");
        ?>
    </BODY>
</HTML>
        <?
    }
        ?>

Link to comment
Share on other sites
ras1986 Newbie

ras1986

Posted
Posted

you have error at your while()...

try changing

while ($orderitem = mysql_fetch_array($orderlist)
                                );
                            (
                            $orderarray[] = $orderitem['id'];
                            )

to this

while ($orderitem = mysql_fetch_array($orderlist)){                       
                            $orderarray[] = $orderitem['id'];
                            }

you are closing the while loop before the $orderitem['id'] can be stored in $orderarray[]

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.