Subscribe via rss
Guest
or Ask a Question
Discussions
Add a reply View Replies (2)

How to Load Albums by Latest ID or Latest Album Id

Suggestions
Tuesday, February 28 2012, 02:33 AM
dev monster
dev monster
Offline
0
I see in the "models/album" file there are several SQL query that gather information for the Album by album_id or

$id = JRequest::getVar('id');

But I want that to reflect the most Recent Album Id or DESC album_id for that user that was added.

It is currently gathering the information for the first album added by user, I want to know where to change the Order By or chagne the SQL to get the lastest Album.

PLEASE HELP..........
Responses (2)

  • Accepted Answer

    dev monster
    dev monster
    Offline
    Tuesday, February 28 2012, 03:17 AM - #Permalink
    0
    Here is simple Answer to that Question:

    Online 24 in "models/album"

    Comment out
    //$id = JRequest::getVar('id');

    And Add this in Place:

    $query = 'SELECT id FROM #__muscol_albums ORDER BY id DESC' ;
    $this->_db->setQuery( $query );
    $id = $this->_db->loadResult('id');
    The reply is currently minimized Show

  • Accepted Answer

    dev monster
    dev monster
    Offline
    Tuesday, February 28 2012, 04:39 AM - #Permalink
    0
    Apologize for previopus posting:

    correct way to get each users multiple albums to show up in Standard User Layout:

    Add this code in file "models/album"

    Line 24

    $userid = JRequest::getVar('userid');
    $myId = $user->id;


    if($myId == $userid){
    $query = 'SELECT id FROM #__muscol_albums ORDER BY id DESC' ;
    $this->_db->setQuery( $query );
    $id = $this->_db->loadResult('id');
    } else {
    $query = 'SELECT id FROM #__muscol_albums where user_id ='.$userid.' ORDER BY id DESC' ;
    $this->_db->setQuery( $query );
    $id = $this->_db->loadResult('id');


    }

    Removed or comment
    Line 24
    //$id = JRequest::getVar('id');
    The reply is currently minimized Show
Your Reply