How to Get the First Attachment of a Node in the View?

See more:

Drupal

hi,

I have a drupal 6 site that has a slider view to display the news article in a slide view. I need to display the first attachment picture only but the problem is it is displaying all the attached pictures in the slide which makes it ugly.
the view code:

$view = new view;
$view->name = 'news_slider2_en';
$view->description = 'News Slider2 (en)';
$view->tag = '';
$view->base_table = 'node';
$view->core = 6;
$view->api_version = '2';
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->override_option('fields', array(
  'body' => array(
    'id' => 'body',
    'table' => 'node_revisions',
    'field' => 'body',
  ),
));
$handler->override_option('filters', array(
  'name' => array(
    'operator' => '=',
    'value' => 'Latest News',
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
      'optional' => FALSE,
    ),
    'case' => 1,
    'id' => 'name',
    'table' => 'term_data',
    'field' => 'name',
    'relationship' => 'none',
  ),
  'language' => array(
    'operator' => 'in',
    'value' => array(
      'en' => 'en',
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'language',
    'table' => 'node',
    'field' => 'language',
    'relationship' => 'none',
  ),
));
$handler->override_option('access', array(
  'type' => 'none',
));
$handler->override_option('cache', array(
  'type' => 'none',
));
$handler->override_option('title', 'News Slider2 (en)');
$handler->override_option('css_class', 'news-block');
$handler->override_option('header', '  <div id="slideshow">
    <div id="slidesContainer">');
$handler->override_option('header_format', '2');
$handler->override_option('header_empty', 0);
$handler->override_option('footer', '<div>
	 </div>
<div>
	 </div>
');
$handler->override_option('footer_format', '2');
$handler->override_option('footer_empty', 0);
$handler->override_option('items_per_page', 6);
$handler->override_option('use_more', 1);
$handler->override_option('use_more_always', 0);
$handler->override_option('row_plugin', 'node');
$handler->override_option('row_options', array(
  'relationship' => 'none',
  'build_mode' => 'teaser',
  'links' => 1,
  'comments' => 0,
));
$handler = $view->new_display('block', 'Block', 'block_1');
$handler->override_option('fields', array(
  'title' => array(
    'label' => '',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'absolute' => 0,
      'link_class' => '',
      'alt' => '',
      'rel' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
      'strip_tags' => 0,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'hide_alter_empty' => 1,
    'link_to_node' => 1,
    'exclude' => 1,
    'id' => 'title',
    'table' => 'node',
    'field' => 'title',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
  ),
  'teaser' => array(
    'label' => '',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'absolute' => 0,
      'link_class' => '',
      'alt' => '',
      'rel' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
      'strip_tags' => 1,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'hide_alter_empty' => 1,
    'exclude' => 1,
    'id' => 'teaser',
    'table' => 'node_revisions',
    'field' => 'teaser',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
  ),
  'upload_fid' => array(
    'label' => 'Attached files',
    'alter' => array(
      'alter_text' => 1,
      'text' => '<img src="http://localhost/ISC/sites/all/scripts/showImage.php?image=[upload_fid-url]" style="width:50px;height:50px;" alt="" />',
      'make_link' => 0,
      'path' => '',
      'absolute' => 0,
      'link_class' => '',
      'alt' => '',
      'rel' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '1000',
      'word_boundary' => 0,
      'ellipsis' => 0,
      'html' => 0,
      'strip_tags' => 0,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'hide_alter_empty' => 1,
    'type' => 'separator',
    'separator' => ',',
    'link_to_file' => 0,
    'only_listed' => 0,
    'exclude' => 1,
    'id' => 'upload_fid',
    'table' => 'node',
    'field' => 'upload_fid',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
  ),
  'nothing' => array(
    'label' => '',
    'alter' => array(
      'text' => '<div class="slide">
<span class="slidetitle">[title]</span>
<div class="nsimage">[upload_fid]</div>
<div class="nscontent">[teaser]</div>
</div>',
      'make_link' => 0,
      'path' => '',
      'absolute' => 0,
      'link_class' => '',
      'alt' => '',
      'rel' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
      'strip_tags' => 0,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'hide_alter_empty' => 1,
    'exclude' => 0,
    'id' => 'nothing',
    'table' => 'views',
    'field' => 'nothing',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
  ),
));
$handler->override_option('sorts', array(
  'created' => array(
    'order' => 'DESC',
    'granularity' => 'second',
    'id' => 'created',
    'table' => 'node',
    'field' => 'created',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
  ),
));
$handler->override_option('css_class', 'block-slider');
$handler->override_option('header', '<script src="http://localhost/ISC/sites/all/scripts/jquery-1.7.min.js" type="text/javascript"></script>
<script type="text/javascript" src="http://localhost/ISC/sites/localhost/scripts/block-slider.js"></script>
<?php
echo "<!-- @@ Block Slider -->";
echo "<div id=\\"top\\">\\r";
echo "<div class=\\"slider_left\\"></div>\\r";
echo "<div class=\\"slider_right\\"></div>\\r";
echo "<div id=\\"slider\\" class=\\"block_slider\\"><div>\\r";
?>');
$handler->override_option('header_format', '3');
$handler->override_option('header_empty', 1);
$handler->override_option('footer', '<?php
echo "</div> <!-- <div class=\\"slider\\" id=\\"block_slider\\"> -->\\r";
echo "</div> <!-- <div id=\\"top\\"> -->\\r";
echo "</div>\\r";
?>');
$handler->override_option('footer_format', '3');
$handler->override_option('row_plugin', 'fields');
$handler->override_option('row_options', array(
  'inline' => array(
    'nothing' => 'nothing',
  ),
  'separator' => '',
  'hide_empty' => 0,
));
$handler->override_option('block_description', '');
$handler->override_option('block_caching', -1);

I think the [upload_fid] is the array of the attachments, how can i get only the first item of the array?

Thank you