view_viedo.php
Code:
$result = mysql_query("SELECT * FROM video WHERE VID='".$video_id."' and approve ='1'")or die(mysql_error());
$row = mysql_fetch_array( $result );
//**display wesite in video details**//
$result4 = mysql_query("SELECT UID,username,website FROM signup WHERE UID='".$row['UID']."'")or die(mysql_error());
$row4 = mysql_fetch_array( $result4 );
$smarty->assign('user_website', $row4['website'] );
view_video.tpl
Code:
Website: {if $user_website ne ""}<a href="{$user_website}" target="_blank">{$user_website}</a>
{else}
No Website Listed{/if}
Bookmarks