Hello again,

I've been working on a download tracker for my website. Unfortunately, it doesn't work. When you click on the download link, it brings you to this page, which then adds to the database (does work, the count has gone up in the mySQL) but then it redirects me to my homepage when it should redirect to the variable $downloadlink

PHP Code:

<?php
     $id = $_GET['id'] ;

    //CONNECT TO THE DATABASE STUFF REMOVED

    //GET ALL OF THE ENTRIES FROM ONE CATEGORY IN A DIFFERENT ORDER
    $result = mysql_query("SELECT * FROM `downloadtracker` WHERE `id` = '$id' ");
    if (!$result) { 
    echo mysql_error(); 
    exit; 
    }
    while ($array = mysql_fetch_array($result)) {
    $link = $array['downloadlink'];
    $number = $array['downloads'];

    $number++;

    mysql_query("UPDATE `downloadtracker` SET `downloads` = $number WHERE `id` = $id LIMIT 1;");

    $host  = $_SERVER['HTTP_HOST'];
    $uri  = rtrim(dirname($_SERVER['PHP_SELF']), '/\\');
    header("Location: http://$host$uri/$downloadlink");

    }

?>

Any help would be great, because I don't know why it doesn't work.

Thanks,

*~* Reality15

You have this line:
$link = $array['downloadlink'];

So I think you should have:
header("Location: http://$host$uri/$link");

<edit>
Also $_SERVER['PHP_SELF'] will return the current filename
</edit>

Alright, now the link in the address bar is correct, but instead of starting the download, it just gives me a message on the screen:

No input file specified.

Any clues now?

try change :

header("Location: http://$host$uri/$downloadlink");

with this

echo "<script>window.location.href=\"http://$host$uri/$downloadlink\";</script>";