Search User ID: Name: Email: User type: All selected>Desktop View All Admin: View Customers Query("select id,fname,lname,email,user_type,house_no,street,complex,landmark,city_id,pincode,area,state,mobile,full_address,reward_points,register_date,status,mark_seller from tbl_user where 1=1 $where order by id desc limit $start, $pagesize"); ?> fetchNextObject($sql)) { $i++; if($i%2==0) { $bgcolor = "#f6f6f6"; } else { $bgcolor = ""; } ?> S No. User ID / User Type Name Email Mobile/ Phone Address Area Pincode Reward Points Wallet Balance Wallet Status No. of Orders Last Order Register Date Is QR Seller Status . id);?> user_type==0){ echo "Registered"; }else{ echo "Guest"; } ?> fname)." ".stripslashes($line->lname);?> email);?> mobile);?> full_address){ echo $line->full_address; }else{ echo stripslashes($line->house_no);?> street);?> complex); ?> landmark).', '.$line->city_id.', '.$line->state; } ?> state);?> pincode);?> id);?> id),0,4);?> Add Refund View Wallet Status query("select order_date, count(id) as ordercount from tbl_order where user_id='$line->id' order by order_date desc"); $orderes=$obj->fetchNextObject($orderdetail); echo $orderes->ordercount; ?> ordercount>1){ echo CalculateOrderTime($orderes->order_date)." (".$orderes->order_date.")"; }else{ echo $orderes->order_date; } ?> register_date));?> mark_seller==1){?> status==1){?>