SELECT newsy.id, DATE_FORMAT(newsy.dodano, '%e-%m-%Y %H:%i') AS utworzono,
          newsy.autor, newsy.tresc, newsy.temat , newsy.cat , COUNT(lp)  AS il_kom
          FROM newsy
          LEFT JOIN komentarze ON (komentarze.id=newsy.id)
          GROUP BY newsy.id ORDER BY newsy.dodano DESC

WHERE `cat` = $_GET['cat']

WHERE `cat` = $_GET['cat']

SELECT newsy.id, DATE_FORMAT(newsy.dodano, '%e-%m-%Y %H:%i') AS utworzono,
         newsy.autor, newsy.tresc, newsy.temat , newsy.cat , COUNT(lp)  AS il_kom
         FROM newsy
         LEFT JOIN komentarze ON (komentarze.id=newsy.id)
         GROUP BY newsy.id ORDER BY newsy.dodano DESC

Unknown column 'Programowanie' in 'where clause'
SELECT newsy.id, DATE_FORMAT(newsy.dodano, '%e-%m-%Y %H:%i') AS utworzono, newsy.autor, newsy.tresc, newsy.temat , newsy.cat , COUNT(lp) AS il_kom FROM newsy LEFT JOIN komentarze ON (komentarze.id=newsy.id) WHERE newsy.cat = Programowanie GROUP BY newsy.id ORDER BY newsy.dodano DESC

$sql="SELECT newsy.id, DATE_FORMAT(newsy.dodano, '%e-%m-%Y %H:%i') AS utworzono,
newsy.autor, newsy.tresc, newsy.temat , newsy.cat , COUNT(lp) AS il_kom
FROM newsy LEFT JOIN komentarze ON (komentarze.id=newsy.id)
WHERE newsy.cat = ".$_GET['cat']."
GROUP BY newsy.id ORDER BY newsy.dodano DESC";
   $query= $db->query($sql);


while($result=mysql_fetch_assoc($query))
  {
$p.='<h2><a href="'.$http_dir.'Comments?newsid='.$result['id'].'">'.$result['temat'].'</a></h2>
                    
             <p class="post-by">Dodał: <a href="'.$http_dir.'Profiles/'.$result['autor'].'">'.$result['autor'].'</a> ,<a href="'.$http_dir.'Categories/'.$result['cat'].'">'.$result['cat'].'</a></p>
                
             <p>'.nl2br($result['tresc']).'</p>  

            
             <p class="post-footer align-left">                    
             <a href="index.html" class="readmore">Czytaj dalej</a> |
             <a href="'.$http_dir.'Comments?newsid='.$result['id'].'" class="comments">Komentarze '.$result['il_kom'].'</a> |
             <span class="date">'.$result['utworzono'].'</span>    
             </p>';

}

$sql="SELECT newsy.id, DATE_FORMAT(newsy.dodano, '%e-%m-%Y %H:%i') AS utworzono,
  newsy.autor, newsy.tresc, newsy.temat , newsy.cat , COUNT(lp) AS il_kom
  FROM newsy LEFT JOIN komentarze ON (komentarze.id=newsy.id)
  WHERE newsy.cat = \"".$_GET['cat']."\"
  GROUP BY newsy.id ORDER BY newsy.dodano DESC";