find-occurances

Tagging phrases in paragragh

I am using PHP and I am looking to create links within my text to other sections of the site so for example: I fell into the media industry aged 30, when David Mansfield, now on the board of Ingenious Media, gave me my first break at Thames TV. From there, I worked at the (now-defunct) Sunday Correspondent and IPC, before joining TDI, w...

Counting records belonging to a category in MySQL

Hi There, I've been battling with some SQL and can't seem to get my head around it. I have two tables, one with the list of categories and another with all my articles. What i'm trying to do is find how many articles are present for each category. Here is the SQL I have so far SELECT DISTINCT COUNT( po.post_Cat_ID ) AS Occurances, c...