Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function getDataListSertifikat($where,$order,$limit){
- global $db;
- $sql = "SELECT srt.*,us.username from user_sertifikat as srt inner join user as us on
- us.id_user=srt.pemegang_sertifikat
- ".$where." ".$order.$limit;
- $rs = $db->Execute($sql);
- if(!$rs) {
- return $db->ErrorMsg();
- }
- else {
- return $rs;
- }
- }
- function getCountListSertifikat($where){
- global $db;
- $sql = "SELECT srt.id_user_sertifikat from user_sertifikat as srt inner join user as us on
- us.id_user=srt.pemegang_sertifikat
- ".$where;
- $rs = $db->Execute($sql);
- if(!$rs) {
- return $db->ErrorMsg();
- }
- else {
- return $rs->recordCount();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement