Dlaczego nie dziala? Opcje

[cichy_bob]

[php:1:4706ae7e9d]<?

$db = download_categories;


$query2 = "SELECT * FROM $db";

$result2 = mysql_query($query2);

$count = mysql_num_rows($result2);


if($count == "0")
{

echo "Brak plikow!";

}

elseif($count > "0")
{

$query = "SELECT * FROM $db ORDER BY category DESC";

$result = mysql_query($query);

while($row = mysql_fetch_array($result)) {

$query3 = "SELECT * FROM download WHERE category=$row[category]";

$result3 = mysql_query($query3);

$count2 = mysql_num_rows($result3);

echo ":: <A HREF=$PHP_SELF?a=show&&category=$row[category] CLASS=menu>$row[category]</A><BR>";
echo " &nbsp; &nbsp; $count2 plikow";
}
}

?>[/php:1:4706ae7e9d]

Daje mi wynik:


Warning: Supplied argument is not a valid MySQL result resource in c:apachehtdocsaaafiles.php on line 56
:: nowa
plikow
Warning: Supplied argument is not a valid MySQL result resource in c:apachehtdocsaaafiles.php on line 56
:: aaa
plikow



Dlaczego nie wyswietla sie:
:: kategoria
0 plikow


-------------------------
[zmoderowane]
Kod php umieszczaj w znacznikach [php]
BzikOS

[BzikOS]

[php:1:fb2525094d]<?php
$db = "download_categories";

$query = "SELECT count(*) FROM $db";
list($count) = mysql_fetch_row( mysql_query( $query2 ) );

if($count == 0)
{
echo "Brak plikow!";
}
else
{
$query = "SELECT category FROM $db ORDER BY category DESC";
$result = mysql_query( $query );

while(list($category) = @mysql_fetch_row( $result ))
{
$query = "SELECT count(*) FROM download WHERE category='$category'";
list($count) = @mysql_fetch_row( @mysql_query( $query ) );

echo ":: <A HREF="$PHP_SELF?a=show&category=$category" CLASS="menu">$category</A><BR>";
echo " [space] [space] $count plikow";
}
}
?>[/php:1:fb2525094d]