Displaying data from database
I really think you should dive into Drupal's Examples Module to look at how a lot of the hooks and so forth you are (mis)using actually work.

But, quickly:

function subscription_menu() {

  $items=array();

  $items[ 'subscriptions' ] = array( 
    'title' =&gt; 'View the Subscribers', 
    'description' =&gt; 'Subscription form available for subscribers',
    'page callback' =&gt; 'subscription_records',
    'access arguments' =&gt; array( 'access content' ),
    'file' =&gt; 'subscription.pages.inc'
  );

  return $items;

}


and

function subscription_records() {

  $result = db_query('SELECT * FROM {subscribe}');
  $records = $result-&gt;fetchAll();

  $content = '&lt;pre&gt;' . print_r($records, TRUE) . '&lt;/pre&gt;';

  return $content;

}


clean up most of the glaring misunderstandings.

However, you will still need to look into Render Arrays and Dynamic Queries to really clean up your code, as well as the Drupal Theming Guide with special attention to theme_table() to create the page you seem to be after.  And, of course, if you need user input, the Form API Reference is a must. But, once again, all of these are explained and demonstrated in the Examples Module.