Number of items in db placed next to link

[jokks]

Hi

Ive been trying to find how coders put the number of items in a database next to a link and then manage keep it updated - eg

widgets (14)

Does anyone know how its done or what the code would be like ?

Cheers

🙂

[cahva]

Quite simple stuff. Count the items in a category.

SELECT COUNT(*) FROM items WHERE category_id = 12;

That would give you the number of items from items table where category_id is 12. You could also place that count to the same sql as subquery where you list the categories.

[jokks]

Thanks.

I'd been looking at a convoluted Ajax\PHP solution.

You know what they say..its simplicity thats clever!

Cheers

🙂