A PHP Error was encountered

Severity: Notice

Message: Undefined variable: specialism

Filename: artists/front_artist_left_menu_view.php

Line Number: 14

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 'AND active=1 ORDER BY last_name' at line 1

select*from artists where specialism= AND active=1 ORDER BY last_name