my $query = "SELECT location FROM demstock2 WHERE ds_id=$main";
my $sth   = $db->prepare($query);
$sth->execute or print "Can't execute <pre>$query</pre>: " . $db->errstr . "<br>\n";