view_video.tpl

Code:
	Website:  {if $user_website ne ""}<a href="{$user_website}" target="_blank">{$user_website}</a>{else}
No Website Listed{/if}</a><br>
view_video.php

Code:
$result = mysql_query("SELECT * FROM video WHERE VID='".$video_id."'")or die(mysql_error());
$row = mysql_fetch_array( $result );

//**display wesite in video details**//
$result2 = mysql_query("SELECT UID,username,website FROM signup WHERE UID='".$row['UID']."'")or die(mysql_error());
$row2 = mysql_fetch_array( $result2 );
$smarty->assign('user_website', $row2['website'] );