"; ?>  "; $queryOpen = "SELECT `primary` FROM `amazonvOrders` WHERE orderID = '$orderID'"; $resultOpen = mysql_query($queryOpen); $rowOpen = mysql_fetch_array($resultOpen, MYSQL_NUM); $primary = $rowOpen[0]; $queryP = "SELECT orderID FROM `amazonvOrders` WHERE `primary` < $primary && `orderID` != '$orderID' ORDER BY `primary` DESC LIMIT 1"; //echo $queryP; $resultP = mysql_query($queryP); $row = mysql_fetch_array($resultP, MYSQL_NUM); if ( $row[0] != NULL ) { $orderidP = $row[0]; echo "« Previous Order    "; } $queryN = "SELECT orderID FROM `amazonvOrders` WHERE `primary` > $primary && `orderID` != '$orderID' ORDER BY `primary` ASC LIMIT 1"; //echo $queryN; $resultN = mysql_query($queryN); $row = mysql_fetch_array($resultN, MYSQL_NUM); if ( $row[0] != NULL ) { $orderidN = $row[0]; echo "Next Order »"; } ?>  "; echo "Invoice"; echo ""; echo ""; echo "Packing Slip"; echo ""; echo ""; table_header_orders_amazonv("Amazon Vendor Order Information","#293b74"); $result = mysql_query("SELECT * FROM `amazonvOrders` WHERE orderID = '$orderID' LIMIT 1"); display_amazonv_order_data_full($result); table_header_cart("Edit Order Details","#AE0011"); $result = mysql_query("SELECT * FROM `amazonvOrders` WHERE orderID = '$orderID' GROUP BY `primary`"); $totalOrder = display_amazonv_vieworder_data($result,$tax,$shipMethod,$shipCost,$orderID); /* $result = mysql_query("SELECT * FROM `returns` WHERE orderid = '$orderid' GROUP BY `productid`"); if (mysql_num_rows($result) > 0) { table_header_returns("Returned Items","#000000"); display_vieworder_data_return_items($result,$orderid); } */ ?>