Извличане на последен ID?

[SuCcEsS]

Как ще стане да се вземи ID на последния добавен клип?

Таблица на клиповете:

CREATE TABLE `jos_jomtube_videos` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) default NULL,
  `video_title` varchar(200) default NULL,
  `video_desc` text,
  `category_id` int(11) NOT NULL default '0',
  `tags` varchar(255) default NULL,
  `status` enum('pending','complete','error','cancelled','deleted') NOT NULL default 'pending',
  `transaction_dt` timestamp NOT NULL default '0000-00-00 00:00:00',
  `hits` int(11) NOT NULL default '0',
  `infin_vid_id` varchar(50) default NULL,
  `thumb_url` varchar(1000) default NULL,
  `duration` varchar(20) default NULL,
  `date_added` date default NULL,
  `published` tinyint(1) NOT NULL default '1',
  `video_type` varchar(255) default NULL,
  `video_url` text,
  `video_thumb` text,
  `downloadable` tinyint(1) default '1',
  `featured` tinyint(1) default '0',
  `votetotal` int(11) default '0',
  `date_updated` date default NULL,
  `remote_id` text,
  `display_thumb` varchar(255) default NULL,
  `checked_out` int(11) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

 

[emagi]

SELECT id FROM jos_jomtube_videos ORDER BY id DESC LIMIT 0, 1

 

[SuCcEsS]

SELECT id FROM jos_jomtube_videos ORDER BY id DESC LIMIT 0, 1

мерси а как да го изкарам в линк например video.php?id=ПОСЛЕДНО ДОБАВЕН

 

[emagi]

$query = mysql_result(mysql_query("SELECT id FROM jos_jomtube_videos ORDER BY id DESC LIMIT 0, 1"), 0);
echo "<a href='video.php?id={$query}'>Последно добавен</а>";