notthing show up

i try to add a code in single page :

PHP Code:

$d = mktime (0,0,0,date("m"),date("d"),date("Y"));
$todayatt = $DB_site->query("SELECT attachmentid,counter,filename FROM attachment WHERE dateline >='$d' ORDER BY counter DESC LIMIT 10");
while ($todaytop = mysql_fetch_array($todayatt)):
    ++$todattopnbsp;
$todayattname .= "<a href=attachment.php?s=$session[sessionhash]&attachmentid=$todaytop[attachmentid]>$todaytop[filename]</a><br>";
    $todayattcount .= "$todaytop[counter]<br>";
endwhile; 

the code above i want to show up today attach file download's

top 10 list..but no error and nothing show up?what's wrong?

and if want to add upload username and file size how to change

the code?thankz...........

[filburt1]

Run your query in mysql.exe or phpMyAdmin and see if it works.

[squawell]

Today at 09:16 PM filburt1 said this in Post #2
Run your query in mysql.exe or phpMyAdmin and see if it works.

oops....i know why it cant show up?because it effect after u apply

the code....now i upload a attach file it show up......

by the way if want to show attach file size how should i change

the code?thankz.....