Ignore:
Timestamp:
Dec 4, 2014 3:10:46 PM (10 years ago)
Author:
namnd
Message:
 
File:
1 edited

Legend:

Unmodified
Added
Removed

  • pro-violet-viettel/sourcecode/application/modules/frontend/models/user_model.php

    r642 r644  
    534534                $username = $data['username'];
    535535                $this->db->query ( 'UNLOCK TABLES' );
    536                 $sql = "SELECT * FROM tblregisterpackagelog where username = ? ORDER BY created_time DESC LIMIT ".$data['start'].", ".$data['perpage']." ";
     536                $sql = "SELECT * FROM tblregisterpackagelog INNER JOIN tblservicepackage ON tblservicepackage.p_code = tblregisterpackagelog.p_code where username = ? ORDER BY created_time DESC LIMIT ".$data['start'].", ".$data['perpage']." ";
    537537                $query = $this->db->query ( $sql, array (
    538538                                $username
Note: See TracChangeset for help on using the changeset viewer.