URL field (easy one)

[carefree2]

view_viedo.php

$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

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

[pjohn]

will try thanks a lot

[pjohn]

Hm one more thing.. i need a field on the upload page where the submitter enters his url.. thanks

[carefree2]

Theres already one installed in user edit an admin option to request website on signup.

user_profile.php

[pjohn]

But the user should enter a different url for every video he submits.. thanks

[carefree2]

I cant see that happening. Users having 2 or more websites

If u want to add affiliate links youll have to create another column store thier urls there

[pjohn]

Yes i need affiliate links exactly :) And i know that there is some addon to the database, but for sure it can be done