How run insert query in magento

<?php
$connection = Mage::getSingleton('core/resource')->getConnection('core_write');
    $connection->beginTransaction();
    $fields = array();
    $fields['cname']= "$com_name";
   $fields['name']= "$name";
   $fields['email']= "$email";
   $fields['phone']= "$phone";
   $fields['account']= "$account";
    $fields['customer_id']= "$custm_id";
   $fields['date']= NOW();
    $connection->insert('wolesaler_table', $fields);
    $connection->commit();
?>