print hyperlink field

Anon

we are using phpclassifieds new beta .3 version - http://www.deltascripts.com/download/

--->> this application offers templates to be used in the creation of af a new classified ad --->>

I need to figure out how to make one of the fileds a "hyperlink" field - that is to say, i need whatever is put by the user in that field to come out as a clickable link when the ad is posted to the database

--- I know this is alot to ask --please take a look at this app and offer your suggestions --

1) here is the php page that prints the ads to the dp

2) here is the suggestion by the script writer that does not work - or i simply do not know where to place the mod.

1-)
<?
session_start( );

if (!$siteid)
{
$siteid = $annid;
}
require("config/header.inc.php");
require("config/config.inc.php");
require("functions.php");
print("<table>");
$sql_links = "select * from $ads_tbl, $cat_tbl, $usr_tbl where catid=sitecatid AND ad_username = $usr_tbl.email AND siteid=$siteid";

$sql_result = mysql_query ($sql_links);
$num_links = mysql_num_rows($sql_result);

for ($i=0; $i<$num_links; $i++)
{
$row = mysql_fetch_array($sql_result);
$siteid = $row["siteid"];
$sitetitle = $row["sitetitle"];
$sitedescription = $row["sitedescription"];
$userid = $row["userid"];
$sitedate = $row["sitedate"];
$sitehits = $row["sitehits"];
$sitevotes = $row["sitevotes"];
$name = $row["name"];
$phone = $row["phone"];
$email = $row["email"];
$sitevotes = $row["sitevotes"];
$adressfield1 = $row["adressfield1"];
$adressfield2 = $row["adressfield2"];
$catname = $row["catname"];
$catid = $row["catid"];
$kid = $row["catid"];

    $expiredate = $row["expiredate"];
    $custom_field_1 = $row["custom_field_1"];
$custom_field_2 = $row["custom_field_2"];
$custom_field_3 = $row["custom_field_3"];
$custom_field_4 = $row["custom_field_4"];
$custom_field_5 = $row["custom_field_5"];
$custom_field_6 = $row["custom_field_6"];
$custom_field_7 = $row["custom_field_7"];
$custom_field_8 = $row["custom_field_8"];
$cattpl = $row["cattpl"];	
$datestamp = $row["datestamp"];
$picture = $row["picture"];
$hide_email = $row["hide_email"];
$img_stored = $row["img_stored"];
$year=substr($row[datestamp],0,4);
$month=substr($row[datestamp],4,2);
$day=substr($row[datestamp],6,2);
$sitedate1 = "$day.$month.$year";

while ($counter < 15)
{
 			$counter = $counter + 1; 
			$fieldnumber = "f" . $counter;
			$fieldid[$counter] = $row["$fieldnumber"];
}
find ("$year", "$month", "$day", "$delete_after_x_days");

if (!$special_mode) { print("$menu_ordinary"); }
require("link_title.php");
?>
<script LANGUAGE="JavaScript">
function openWin(URL) { aWindow=window.open(URL,"Stort_bilde","toolbar=no,width=400,height=300,status=no,scrollbars=no,resize=no,menubars=no");

}
function openWin2(URL) {
aWindow=window.open(URL,"Stort_bilde","toolbar=no,width=400,height=350,status=no,scrollbars=no,resize=no,menubars=no");
}
</script>
<h2><? echo $sitetitle ?></h2>

<table border="0" cellpadding="0" cellspacing="0" width="90%">

<tr>

<?
if ($picture > 0)
{
require("config/config.inc.php");
print("<td valign=top><a href=\"javascript:openWin('large_picture.php?id=$picture')\"><img border=\"0\" alt=\"Klikk for stort bilde\" src=\"get.php?id=$picture\" width=\"106\" height=\"68\" align=\"left\"></a></td>");
}
elseif ($img_stored <> '')
{
print("<td valign=top><a href=\"javascript:openWin('images/$img_stored')\"><img border=\"0\" alt=\"Klikk for stort bilde\" src=\"images/$img_stored\" width=\"106\" height=\"68\" align=\"left\"></a></td>");
}
else
{
$colsp = "colspan=2";
}
?>

<td <? echo $colsp ?> valign=top><? print("$sitedescription"); ?></td>

</tr>
<tr>
<td> 
</td>
<td></td>
</tr>
<tr>
<td colspan=2><? echo $general_details ?></td>
</tr>

<tr>
<td><? echo $sold_by_text?></td>
<td><? echo $name ?></td>
</tr>
<tr>
<td><? echo $add_user_email ?></td>
<td>
<?

if ($email)
{
if ($hide_email == 1)
{
print "<a href='contact.php?siteid=$siteid'>$la_contact_sale</a>";
}
else
{
print "<a href='mailto:$email'>$email</a>";
}
}
else
{
print "Call !";
}
?>

</td>
</tr>
<?
if ($adressfield1 OR $adressfield2)
{

print("<tr>");
print("<td>$location_text</td>");
print("<td>$adressfield1, $adressfield2</td>");
print("</tr>");
}
?>
<?

if ($phone)
{
print("<tr>");
print("<td>$add_user_phone</td>");
print("<td>$phone</td>");
print("</tr>");
}
?>
<?
if ($custom_field_1_text)
{
print("<tr>");
print("<td>$custom_field_1_text</td>");
print("<td>$custom_field_1</td>");
print("</tr>");

}

if ($custom_field_2_text)
{
print("<tr>");
print("<td>$custom_field_2_text</td>");
print("<td>$custom_field_2</td>");
print("</tr>");

}

if ($custom_field_3_text)
{
print("<tr>");
print("<td>$custom_field_3_text</td>");
print("<td>$custom_field_3</td>");
print("</tr>");

}
if ($custom_field_4_text)
{
print("<tr>");
print("<td>$custom_field_4_text</td>");
print("<td>$custom_field_4</td>");
print("</tr>");

}
if ($custom_field_5_text)
{
print("<tr>");
print("<td>$custom_field_5_text</td>");
print("<td>$custom_field_5</td>");
print("</tr>");

}
if ($custom_field_6_text)
{
print("<tr>");
print("<td>$custom_field_6_text</td>");
print("<td>$custom_field_6</td>");
print("</tr>");

}
if ($custom_field_7_text)
{
print("<tr>");
print("<td>$custom_field_7_text</td>");
print("<td>$custom_field_7</td>");
print("</tr>");

}
if ($custom_field_8_text)
{
print("<tr>");
print("<td>$custom_field_8_text</td>");
print("<td>$custom_field_8</td>");
print("</tr>");
}

$string = "select * from template where name = '$cattpl'";
$result = mysql_query ($string);
$row = mysql_fetch_array($result);

while ($field < 15)
{

$field = $field + 1;
$fieldname = "f" . $field;
$tmpfield1 = "f" . $field . "caption";
$tmpfield2 = "f" . $field . "type";
$tmpfield3 = "f" . $field . "mandatory";
$tmpfield4 = "f" . $field . "length";
$tmpfield5 = "f" . $field . "_filename";

$caption = $row["$tmpfield1"];
$type = $row["$tmpfield2"];
$mandatory = $row["$tmpfield3"];
$length = $row["$tmpfield4"];
$filen = $row["$tmpfield5"];

if ($fieldid[$field])
{
print("<tr>");
print("<td>$caption</td>");
print("<td>$fieldid[$field]</td>");
print("</tr>");
}
}

</tr>
<tr>
<td>Ad id</td>
<td><? echo $siteid ?></td>
</tr>
<tr>
<td><? echo $ad_views ?> </td>
<td><? echo $sitehits ?></td>
</tr>
<tr>
<td><? echo $ad_expire ?></td>
<td><? echo $expire_date ?></td>
</tr>
<tr>
<td><? echo $date_added ?></td>
<td><? echo $sitedate1 ?></td>
</tr>
</table>

<hr size="1" align="left" width="98%">

<?
print("<a href='index.php?kid=$kid&catname=$catname'>$la_similar</a>  ");
print("<a href='search.php?siteid=$siteid&adv=1'>$la_similar_ads</a>  ");
print("<a href='contact.php?siteid=$siteid'>$la_contact_sale</a>  ");
print("<a href='member_login.php?userid=$userid'>$la_edit</a>  ");
print("<a href='member_login.php?userid=$userid'>$la_delete</a>  ");
print("<a href=\"javascript:openWin2('tellafriend.php?id=$siteid&adtitle=$sitetitle')\">$la_tell_a_friend</a>");
?>
<input type="image" src="print.gif" name="submit" onclick="window.print()">

<?
}
$tell=$sitehits+1;
$s = "UPDATE $ads_tbl set sitehits=$tell,datestamp='$datestamp' where siteid=$siteid";
$result1=MYSQL_QUERY($s);

require("config/footer.inc.php");
?>

2-)
if ($fieldid[$field])
{
print("<tr>");
print("<td>$caption</td>");

if ($fieldid = "f3")
{
print "<a href='$fieldid[$field])'>$fieldid[$field])</a>";

}
else
{
print("<td>$fieldid[$field]</td>");
}
print("</tr>");

}

in detail.php. Note that if you bind a field (like f3 in this example), you can´t use the extra field in other templates for use in different type of ads/categories. This field f3 will now always print out a link, if you used this for telephone number or somthing, it will also be shown as a link...