in reply to Re^2: Using variables withing a mysql query
in thread Using variables within a mysql query
This should be equivalent to double quotes. What do you get from a print $data; after your statement above?
If you get exactly the query (SELECT id, name, location FROM book WHERE 1 ORDER BY id DESC) and it doesn't work as expected, perhaps you should post more of the surrounding code...
In Section
Seekers of Perl Wisdom