Dear sir,
hi, I have a question.
Im sorry if i have posted this in the incorrect place,
it is neither my intention to offend or annoy.
my question>I am building a website,
the main page (index) is built up of a series of links,
a bit like gumtree or ebay.,
within all of these links are more links to each individual post.
What i am trying to do is to find a script that will automaticlly count the number of posts in each link

.example>
cars (4)
bikes (1)
trucks (4)
planes (0)

because i will not have a very large ammount of postings, i would like to be able to inform my visitors on the main page whether its good for them to follow or not.
I imagine its a simple piece of code , but i have tried in vain to search for something along these lines,Just the name of the code or software or even what type of action i am trying to perform would be a great start.I hope you can help me,

take a look at www.olive-tree.es for a better idea of what i mean

many thanks and kind regards.



AJSerjent

Typically these numbers are created through an aggregation SQL call to the database. For instance...



Something like this would give you the number of postings in the folder that has the ID of 2. This isn't typically calculated through following URL links because it would be hard to keep track of and second it would be a bit more time consuming.

I suggest you look up the term "aggregate functions" and in specific "count()" in SQL to help you out with this.

thanks very much for the helpful information, i know nothing about sql databases but its given me a start in the right direction.
many thanks once again,
ajs