-my $st_query = $DB->prepare("SELECT s.name, d.set_id, d.disc, d.path
- FROM dvd_disc AS d JOIN dvd_set AS s
- ON d.set_id = s.id
- WHERE d.disc_id IS NULL");
-my $st_store = $DB->prepare("UPDATE dvd_disc SET disc_id = ?
- WHERE set_id = ? AND disc = ?");
+my $search = $opt{"a"} ? "" : "WHERE d.disc_id IS NULL";
+my $st_query = $DB->prepare
+ ("SELECT s.name, d.set_id, d.disc, d.path
+ FROM dvd_disc AS d JOIN dvd_set AS s ON d.set_id = s.id
+ $search");
+my $st_store = $DB->prepare
+ ("UPDATE dvd_disc SET disc_id = ? WHERE set_id = ? AND disc = ?");