Forum PHP.pl

[SQL] pobierz, plaintext 
SELECT * FROM tabela GROUP BY kategoria ORDER BY id DESC
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
LIMIT 1
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
LIMIT 1
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT * FROM tabelka WHERE id IN (SELECT max(id) FROM tabelka GROUP BY category) GROUP BY category ORDER BY id DESC
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT * FROM tabelka WHERE id IN (SELECT max(id) FROM tabelka GROUP BY category) ORDER BY id DESC
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
$zapytanie = "SELECT DISTINCT(kategoria) FROM tabela";
  $wynik = mysql_query($zapytanie);
  $ilosc = mysql_num_rows($wynik);
 for ($i=0; $i<$ilosc; $i++)
    {
   $pokaz = mysql_fetch_array($wynik);
   $SELECTDISTINCTkategoria = $pokaz['DISTINCT(kategoria)'];
 
$zapytanie2 = "SELECT * FROM tabela where kategoria='$SELECTDISTINCTkategoria' order by kategoria desc LIMIT 1";
  $wynik2 = mysql_query($zapytanie2);
     $dane = mysql_fetch_array($wynik2);
     $ostatnie_id = $dane['id'];
 
 echo "$ostatnie_id";
     
}
?>
[PHP] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT `tekst`, `kategoria` FROM (SELECT * FROM `table` ORDER BY id DESC) AS temp GROUP BY kategoria
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT id_klienta, avg(sztuk) FROM zakupy GROUP BY id_klienta HAVING avg(sztuk)>10
[SQL] pobierz, plaintext