Jump to content

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

paulsinclair

By paulsinclair
in PHP Coding Help

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.

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)) {

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>
        <?
    }
        ?>

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[]

Archived

This topic is now archived and is closed to further replies.

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.