public function getAllRegisteredUser($row) { $sqlGetAllRes = "SELECT CUS_ID,CUS_USERNAME,CUS_PASSWORD,CUS_EMAIL,CUS_FIRST_NAME,CUS_LAST_NAME,CUS_GENDER,CUS_CONTACT_ADDRESS,CUS_RECEIPT_ADDRESS,CUS_PHONE_NUMBER,CUS_FACEBOOK_ADDRESS,CREATED_DATE_TIME FROM RICH_CUSTOMER ORDER BY CREATED_DATE_TIME DESC LIMIT " . $row; $result = mysql_query($sqlGetAllRes); $listUser = new ArrayList(); while ($row = mysql_fetch_array($result)) { $userObj = new CustomerVO(); $userObj->setCusID($row['CUS_ID']); $userObj->setCusUsername($row['CUS_USERNAME']); $userObj->setCusPassword($row['CUS_PASSWORD']); $userObj->setCusEmail($row['CUS_EMAIL']); $userObj->setCusFirstName($row['CUS_FIRST_NAME']); $userObj->setCusLastName($row['CUS_LAST_NAME']); $userObj->setCusGender($row['CUS_GENDER']); $userObj->setCusContactAddr($row['CUS_CONTACT_ADDRESS']); $userObj->setCusReceiptAddr($row['CUS_RECEIPT_ADDRESS']); $userObj->setPhoneNumber($row['CUS_PHONE_NUMBER']); $userObj->setCusFacebookAddr($row['CUS_FACEBOOK_ADDRESS']); $userObj->setCusCreatedDateTime($row['CREATED_DATE_TIME']); $listUser->Add($userObj); } return $listUser; }