problems with php mysql

[wwwpromo]

i have some problem to change 1 thing

As you see i give the "CODE" as reference to the details.php page i wanna replace this with "URL" butt its not working i have try over 20 variables to this piece of code

This is a piece of the search page

<----

echo "<p>There are ";

echo mysql_num_rows($results);

echo " results for ->" . $trefwoord . ":</p>\n";

echo "<ol>";

while ($rij = mysql_fetch_assoc($results)) {

$melding .= "<p>";

echo '<a href="details.php?code=' . $rij["code"] . $url2 . '" title="' . $rij["title"] .'">';

echo $rij["title"];

echo '</a><br>';

echo "<br>" . htmlentities($rij["details"]);

echo "</p>\n";

------------>

this is the details page

<----------

 

<?php

if (isset($_GET['code'])) {

    $code = $_GET['code'];

    if ((strlen($code) > or (!is_numeric($code))) {

        include('producten.php');

        exit;

    }

$sql  = "SELECT * FROM `listings` ";

$sql .= "WHERE `code` = " . $code;

require_once('connect.inc.php');

mysql_select_db("listing_directo") or die(mysql_error());

$resultaat = mysql_query($sql) or die(mysql_error());

 

if (mysql_num_rows($resultaat) < 1) {

    mysql_free_result($resultaat);

    mysql_close($verbinding);

    exit;

} else {

    while ($rij = mysql_fetch_assoc($resultaat)) {

        $title        = $rij["title"];

        $url          = $rij["url"];

        $description  = $rij["description"];

        $pr          = $rij["pr"];

        $backlinky    = $rij["backlinky"];

        $backlinkg    = $rij["backlinkg"];

        $backlinkav  = $rij["backlinkav"];

        $backlinkalt  = $rij["backlinkalt"];

        $keywords    = $rij["keywords"];

        $indexy      = $rij["indexy"];

        $indexg      = $rij["indexg"];

        $indexav      = $rij["indexav"];

        $indexalt    = $rij["indexalt"];

        $digg        = $rij["digg"];

        $propeller    = $rij["propeller"];

        $reddit      = $rij["reddit"];

        $stumble      = $rij["stumble"];

        $keywordrank  = $rij["keywordrank"];

    }

    mysql_free_result($resultaat);

}

?>

What is wrong here?

the results are on

http://listing-directory.eu/lang/english/pr-directories-promotion/directories-reciprocal.php click on a link and you see the detail page only refered by the code