1) { ?> ='".$date_paid1."' and DATE(order_date_time) <='".$date_paid12."' "; } if($_REQUEST['from']!="" && $_REQUEST['to']=="" ) { $cond9.="and DATE(order_date_time) ='".$date_paid1."'"; } if($_REQUEST['from']!="" && $_REQUEST['to']=="" ) { $cond9.="and DATE(order_date_time) ='".$date_paid12."'"; } if($_REQUEST['from']!="" && $_REQUEST['to']!="" ) { $cond9.="and DATE(order_date_time) >='".$date_paid1."' and DATE(order_date_time) <='".$date_paid12."' "; } $table_name="tbl_confirmorder"; $Query = "SELECT * from tbl_confirmorder where 1=1 $cond8 order by orid desc"; $namesss=$DB->query($Query); $nsssss=mysql_num_rows($namesss); $manssss='0'; $kjjj=0; while ($rowsss = mysql_fetch_array($namesss)) { $new_orid =$rowsss['orid']; $userid =$rowsss['userid']; $orderid=$rowsss['orderid']; $orderstatus =$rowsss['orderstatus']; $Query = "SELECT * from `shop_user` where user_id='$userid' "; $name=$DB->query($Query); $no=mysql_num_rows($name); $row = mysql_fetch_array($name); $new_status=$row['new_status']; $Query_oo = "SELECT * from `tbl_order` where orderid='$orderid' "; $name_oo=$DB->query($Query_oo); $no_oo=mysql_num_rows($name_oo); if($no_oo>0) { if($new_status==0) { if($orderstatus==0) { $par_status="Placed"; } if($orderstatus==1) { $par_status="Confirmed"; } if($orderstatus==2) { $par_status="Dispatched"; } if($orderstatus==3) { $par_status="Delivered"; } if($orderstatus==4) { $par_status="Refund"; } if($orderstatus==5) { $par_status="Packed"; } //sprintf("%02d", $to_hour); ?>

	S.no	Orderid	Date and Time	Name	State	Mobile No	Type	Courier Company	Courier No	Payment Mode	Invoice No	View
							Patient		1) { ?> Online		View

Order Details