Dropping my domain name path from url link

Hi, I have a url link that is returned from a mysql db, it displays correctly on my page but when I click on it, in the address bar it will include my domain which then causes the error because it can’t find the page. My code where the error is coming from is:

$query = “select * from movie where movie_title like \”%$trimmed%\"
order by movie_title"; // EDIT HERE and specify your table and field names for the SQL query

$numresults=mysql_query($query)or die (mysql_error());
$numrows=mysql_num_rows($numresults) or die (mysql_error());
// If we have no results, offer a google search as an alternative

if ($numrows == 0)
{
echo “<h4>Results</h4>”;
echo “<p>Sorry, your search: "” . $trimmed . “" returned zero results</p>”;

// google
echo “<p><a href=\“http://www.google.com/search?q=
. $trimmed . “\” target=\”_blank\" title=\“Look up
" . $trimmed . " on Google\”>Click here</a> to try the
search on google</p>";
}

// next determine if s has been passed to script, if not use 0
if (empty($s)) {
$s=0;
}

// get results
$query .= " limit $s,$limit";
$result = mysql_query($query) or die(“Couldn’t execute query”);

// display what the person searched for
echo “<p>You searched for: "” . $var . “"</p>”;

// begin to show results set
echo “The following results have been found:”;
echo “<br />”;
$count = 1 + $s ;

// now you can display the results returned
while ($row= mysql_fetch_array($result)) {
$title = $row[“movie_link”];
$title_encoded = urlencode($title);
echo “<a href=” . $title_encoded . “>” . $title . “</a>”;
echo “<br />”;
//echo “$count.) $title” ;
$count++ ;
}

$currPage = (($s/$limit) + 1);

//break before paging
echo “<br />”;

// next we need to do the links to other results
if ($s>=1) { // bypass PREV link if s is 0
$prevs=($s-$limit);
print " <a href=\“$PHP_SELF?s=$prevs&q=$var\”><<
Prev 10</a>&nbsp ";
}

// calculate number of pages needing links
$pages=intval($numrows/$limit);

// $pages now contains int of pages needed unless there is a remainder from division

if ($numrows%$limit) {
// has remainder so add one page
$pages++;
}

// check to see if last page
if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {

// not last page so give NEXT link
$news=$s+$limit;

echo " <a href=\“$PHP_SELF?s=$news&q=$var\”>Next 10 >></a>";
}

$a = $s + ($limit) ;
if ($a > $numrows) { $a = $numrows ; }
$b = $s + 1 ;
echo “<p>Showing results $b to $a of $numrows</p>”;

?>

</body>
</html>