Latest added lyrics

Dimitris
Dimitris
Offline
0
Hi again :-)

I modified your latest_added artists module in order to show me the latest added songs with lyrics. It fetches the XX latest songs OK but it doesn't check if the lyrics field is NULL (it ignores the WHERE clause) so .. it actually brings the last XX songs no matter if they have lyrics

Any idea why?

Thanks in advance
Dimitris [img size=500]http://www.joomlamusicsolutions.com/images/fbfiles/images/sshot2.jpg[/img]
Attachments:
Responses (2)
  • Accepted Answer

    Wednesday, August 12 2009, 01:25 PM - #Permalink
    0
    yes, you should not use lyrics is NOT NULL but

    lyrics != ''
    The reply is currently minimized Show
  • Accepted Answer

    Dimitris
    Dimitris
    Offline
    Wednesday, August 12 2009, 04:10 PM - #Permalink
    0
    thanks

    It works fine
    The reply is currently minimized Show
Your Reply