I'm making a tagging system for a script. The tagging system is much like the one here.
be it's not normalized like this one.
It's a single table in my database with three columns.
uid | id | name
The 'id' field is not auto increment. It is a field which holds the corresponding tables unique id.
Everything works well. I explode before it hits the database, I get the unique id with mysql_insert_id. No users and just one admin so this won't be any issue.
My question is.. How do I make it so one can click the tag and it will take you to a url like.. tags.php?=programming or something to that effect?
This query gets all tags with the tag name being $tagname . This works if I display it on a test page. and exchange the tagname var with an actual tag name like "bookreviews' or what not.
$query = "SELECT titles.title,tags.id FROM titles,tags WHERE tags.tag = '$tagname' AND tags.id = titles.id GROUP BY tags.id";
I don't want to have to have individual pages for my tags. At the moment I can do that. But I think the idea is to have a tags.php archive that does it for you..