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...