Display total count of certain attachment type

[vat0r]

I would like to display the total number of .txt files attached on my forum. Is there a way to accomplish this?

EDiT: Got it using this.

"SELECT COUNT(extension) AS total FROM " . TABLE_PREFIX . "attachment WHERE extension='txt'"