Magento : Get Product Qty

  $connection = Mage::getSingleton('core/resource')
->getConnection('core_write');
$connection->beginTransaction();
$fields = array();
$fields['name']= 'test';
$fields['description']= 'test';
$connection->insert('tablename', $fields);
$connection->commit();