if statment help

[coldwerturkey]

I bought a script from a friend and need a little help,

function download() {
$getq = mysql_query("SELECT downloads FROM dloads_files WHERE id = '{$_GET['f']}'");
$dinf = mysql_fetch_array($getq);
$dnew = $dinf['downloads'] + 1;
$update = mysql_query("UPDATE dloads_files SET downloads = '{$dnew}' WHERE id = '{$_GET['f']}'");

in html output

Downloads: {$finfo['downloads']} //# of downloads


<a href='?!=03&f={$finfo['id']}'>[Download]</a> //download link

I want to display nothing if no file ['f'] exsits, Ive been trying for 2hours but being a newb, no such luck, I hope everything you need is there. Thanks in advance,

[YAOMK]

Hard to tell exactly how you want your logic to flow, but I guess you could do:

if (isset($finfo['id']) && $finfo['id'] >= 0)
{
echo "Downloads: $finfo['downloads']"; //# of downloads 
echo  "<a href='?somevar=03&f=$finfo['id']>[Download]</a>"; //download link 
}
else
exit;

Note that you shouldn't pass $_GET[] input directly to your sql query, try using mysql_real_escape_string() to escape user input and prevent sql injections.

[wilku]

You might want to look at [man]is_file[/man] and if statement. Glue them together and you have your solution.