A PHP Error was encountered

Severity: Warning

Message: Missing argument 2 for Artists::genre()

Filename: controllers/artists.php

Line Number: 78

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: genre

Filename: controllers/artists.php

Line Number: 87

An Error Was Encountered

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY tbl_artist.vcArtistName ASC' at line 5

SELECT tbl_artist.iArtistID, tbl_artist.vcArtistName, tbl_artist.vcArtistWebsite, tbl_album.vcAlbumTitle, tbl_genre.iGenreID FROM tbl_artist LEFT JOIN tbl_album ON tbl_artist.iArtistID = tbl_album.iArtistID LEFT JOIN tbl_genre ON tbl_artist.iGenreID = tbl_genre.iGenreID WHERE tbl_artist.tiArtistEnabled = 1 AND tbl_album.tiAlbumEnabled = 1 AND tbl_album.iAlbumID IN ( SELECT MAX(iAlbumID) FROM tbl_album GROUP BY iArtistID ) AND tbl_genre.iGenreID = ORDER BY tbl_artist.vcArtistName ASC