How do i do a count of how many records are tagged under one tag?

[snowboardr]

How do i do a count of how many records are tagged under one tag?

SELECT DISTINCT ut.uxtagid, ut.uuserid, ut.uprivate, tt.tid, tt.ttag, tt.trated FROM usertags ut, thetags tt WHERE ut.uuserid=1 AND ut.uxtagid=tt.tid ORDER by tt.ttag


"thetags" contains the actual tag name like this:

tid, ttag


"usertags" when a user tags a record its stored here, and the records here are linked to the tag name

uuserid = the user who tagged it
uxtagid = is joining the "thetag" table to identify the name of the tag
uxforumpostid = the record that is being tagged

Thanks for your help
Jason

Jason

[red]Army[/red] : [white]Combat Engineer[/white] : [blue]21B[/blue]

 

[r937]

which tag? which records? which user?

these all affect what the query looks like

r937.com | rudy.ca

 

[snowboardr]

The query i posted above displays all the tags for one user all i would like to do is count each record that is under each tag and display the number of records tagged next to it... so it would be like

tag (1)
tag (45)
tag (53)

[URL unfurl="true"]http://www.webreference.com/programming/javascript/ncz/column2/example2.html[/URL]

Jason

[red]Army[/red] : [white]Combat Engineer[/white] : [blue]21B[/blue]

 

[Kozusnik]

How about...

SELECT ttag, count(tid) FROM thetags
LEFT OUTER JOIN usertags on uxtagid=tid
WHERE uuserid=1 ORDER by ttag

Mark