Magento get data from database
In this tutorial we tell you how to retrive the content from database with the use of table name . here is the core help to fetch the content using select query .
$connection = Mage::getSingleton('core/resource')->getConnection('YOUR_DATABASE_NAME');
//I assuming that you created the model for your table
$result = $connection->fetchAll("SELECT *FROM YOUR_TABLE");
///just checking the result
Hope this is helps you .