//exit;
//echo $sql;
$result = mysql_query($sql);
if (mysql_num_rows($result) != 0) {
    $row = mysql_fetch_array($result);
    $ordernumber = $row["order_id"];
    $username = $row["user_name"];
    if ($row['vorder_currency'] != $sellerCurrency and $row['vorder_currency'] != "USD") {
        $get_conversion_price = getCurrencyrate($sellerCurrency);
        $ordertotal = $row["total"];
    } else {
        $ordertotal = $row["total"];
    }
    $taxtotal = $row["taxtotal"];
    //$ordertotal+=$row["taxrate"];
    $orderstatus = getArtistOrderStatus($orderid, $artistid);
    $orderdate = $row["order_date"];
    $orderdate = dateFormat($orderdate, "Y-m-d", "m/d/Y");
    $userid = $row["user_id"];
}
//$statlist= getStatusList();
$statlist = array();
if ($orderstatus == "Cancelled") {
    $statlist[2] = "Cancelled";
} else {
    if ($orderstatus == "Shipped") {
        $statlist[3] = "Shipped";
    } else {
        if ($orderstatus == "Delivered") {
            $statlist[4] = "Delivered";
        } else {
                                            <tr>
                                                <td colspan='3'>
                                                    
                                                       Order Part # <?php 
            echo $i + 1;
            ?>
                                                        <table width='100%'  border='0' cellpadding='0' cellspacing='0' class="cart_listingtbl2" >
                                                            <tr class="whitebg">
                                                                <td width='100%' colspan='7' align="left" ><b><?php 
            echo TEXT_VENDOR;
            ?>
  : &nbsp;<font color='RED'><?php 
            echo stripslashes(getArtistCompanyName($artists[$i]));
            ?>
</font></b>&nbsp;&nbsp;Order Status:&nbsp;<b><font color='RED'><?php 
            echo getArtistOrderStatus($orderid, $artists[$i]);
            ?>
</font></b></td>
                                                            </tr>
                                                            

                                                            <tr><td width='100%' colspan='7'>
                                                                    <table BORDER="0" width="100%" cellpadding="0" cellspacing="0" class="cart_listingtbl" >


                                                                        <tr>
                                                                            <th width='4%' align="center"><b>#</b></th>
                                                                            <th width='39%' align="center"><b>Product Name</b></th>
                                                                            <th width='12%' align="center"><b>Code</b></th>
                                                                            <th width='10%' align="center"><b>Rate</b></th>
                                                                            <th width='6%' align="center"><b>Qty</b></th>
                                    <td><?php 
        echo $link . htmlentities($row["email"]) . "</a>";
        ?>
</td>
                                    <td align="center"><?php 
        echo $link . dateFormat($row["order_date"], "Y-m-d", "m/d/Y") . "</a>";
        ?>
</td>

                                    <td><?php 
        echo $link . $adminCurrency["currency_symbol"] . " " . htmlentities(number_format($ordertotal, 2, '.', '')) . "</a>";
        ?>
</td>

                                    <td><?php 
        echo $link . htmlentities(getArtistOrderStatus($row["order_id"], $artistid)) . "</a>";
        ?>
</td>
                                </tr>
                                        <?php 
        $i++;
    }
    ?>
                                    <?php 
    if (isNotNull($check)) {
        ?>
                                <tr>
                                    <td colspan="6" align="center"><input type="submit" name="btnRequestForPayment" value="Request For Payment" class="button">
                                    </td>
                                </tr>
                                        <?php 
</td>
                                    <td valign="top" align="left"><?php 
            echo htmlentities($rw["order_status"]);
            ?>
&nbsp;</td>
                                </tr>



                                            <?php 
            $k++;
        }
        ?>
                                
                                <?php 
        $orderpartialStatus = getArtistOrderStatus($orderid, $artists[$i]);
        if ($orderpartialStatus != 'Delivered') {
            ?>

                                <tr class="brdr_new">

                                    <td height="37" colspan="5" align="left"> <?php 
            echo $rw['item_status'];
            ?>
Change status to:&nbsp;&nbsp;<?php 
            echo $ddl;
            ?>
&nbsp;<span class="btn_gotbl">
                                            <input name="chkStatus" type="checkbox" id="chkStatus" value="Y">
                                            Inform Order Status Change To Buyer </span>&nbsp;<?php 
            echo $btn;
            }
        }
        $orderTotal += $totalshippingcost;
        $link = 'vieworder.php?orderid=' . $ordRow["order_id"];
        ?>
                                    <tr>
                                        <td valign="top" align="left"><?php 
        echo htmlentities($ordRow["order_id"]);
        ?>
</td>
                                        <td valign="top" align="left"><?php 
        echo htmlentities($ordRow["user_name"]);
        ?>
</td>
                                        <td valign="top" align="left"><?php 
        echo getArtistOrderStatus($ordRow["order_id"], $artistid);
        ?>
</td>
                                        <td valign="top" align="left"><?php 
        echo dateFormat($ordRow["order_date"], "Y-m-d", "m/d/Y");
        ?>
</td>
                                        <td valign="top" align="left">$<?php 
        echo htmlentities(number_format($orderTotal, 2, '.', ''));
        ?>
</td>
                                        <td><a href="<?php 
        echo $link;
        ?>
">View</a></td>