$yerli = "SELECT id FROM lyrics WHERE tip = '1'";
$yabanci = "SELECT id FROM lyrics WHERE tip = '2'";
$toplam = "SELECT id FROM lyrics";
echo "yerli: " . mysql_num_rows(@mysql_query($yerli));
echo "yabancı: " . mysql_num_rows(@mysql_query($yabanci));
echo "toplam: " . mysql_num_rows(@mysql_query($toplam));