"X total posts"

[Anon]

Is there a way to count the number of entries in a certain field (varchar) in a mysql database table, and then display that number on a page? I have IDs for each entry, but they are each random 35 character varchar ids, so I can't just list the highest ID#.

[Anon]

SELECT COUNT(id) AS total FROM table

[genecide]

You can use the function mysql_num_fields.

[[deleted]]

don't you mean mysql_num_rows()?

But that's the slow method, using count() is faster.