WHERE vmplay_artists.id = vmplay_videos.artistid and vmplay_videos.videoactive = 'YES' ORDER BY vmplay_artists.artistfirst ASC
The result is showing results that have a 'NO' under vmplay.videos.videoactive Is there something wrong with my code?
At first glance it looks fine. Can you post your complete sql statemtent?
