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