total number

[Al_90]

here's my table:

CREATE TABLE `portal` (
`id` int(5) unsigned NOT NULL auto_increment,
`title` varchar(26) NOT NULL default '',
`author` varchar(22) NOT NULL default '',
`userid` int(5) NOT NULL default '0',
`category` varchar(18) NOT NULL default '',
`width` varchar(4) NOT NULL default '',
`height` varchar(4) NOT NULL default '',
`description` text NOT NULL,
`userfile` varchar(26) NOT NULL default '',
`filesize` int(6) NOT NULL default '0',
`views` int(10) NOT NULL default '0',
`date` varchar(30) NOT NULL default '',
`score` float(3,2) default '2.50',
`votes` int(5) unsigned NOT NULL default '1',
`type` varchar(9) NOT NULL default '',
`thumb` varchar(26) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

and i want to placce a thing on my site that tells me the total number of views there is, thanks :)

[Velox Letum]

SELECT SUM(views) AS totalviews FROM portal

The field name returned will be totalviews, the sum of the view count from all rows in portal.