StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPhp tags display
primarykey
Id
1577687
data
AcceptedAnswerId
0
AnswerCount
2
ClosedDate
CommentCount
6
CommunityOwnedDate
CreationDate
2009-10-16T12:10:51.973
FavoriteCount
0
LastActivityDate
2009-10-16T13:35:24.497
LastEditDate
LastEditorUserId
0
OwnerUserId
168535
ParentId
0
PostTypeId
1
Score
0
ViewCount
177
LastEditorDisplayName
text
Body
There are 4 tables used for storing tags: <pre><code>tagovi, tagovi_vijesti, tagovi_blogovi, tagovi_dogadjanja </code></pre> Structure od table <code>tagovi</code>: <pre><code>id - name </code></pre> Structure of table <code>tagovi_vijesti</code>: <pre><code>id - vijesti_id - tag_id </code></pre> The same is for other two tables. On main page I display tags from all three tables this way: <pre><code>$sql = "SELECT T.id AS id, T.name AS tag, TV.id AS tag_vijest_id, TD.id AS tag_dogadjanje_id, TB.id AS tag_blog_id, COUNT(*) ponavljanje FROM tagovi AS T LEFT JOIN tagovi_vijesti AS TV ON T.id = TV.tag_id LEFT JOIN tagovi_dogadjanja AS TD ON T.id = TD.tag_id LEFT JOIN tagovi_blogovi AS TB ON T.id = TB.tag_id WHERE TV.id IS NOT NULL GROUP BY id ORDER BY id DESC LIMIT 35"; $sql_result = mysql_query($sql,$connect) or die("Upit nije izvrsen"); while ($row = mysql_fetch_array($sql_result)){ $tag_id = $row["id"]; $tag_url = $row["tag"]; $tag = preg_replace('/-/', ' ', $tag_url); $tag_ponavljanje = $row["ponavljanje"]; if($tag_ponavljanje >= 10 && $tag_ponavljanje < 20) $fontSize = "14px"; elseif($tag_ponavljanje >= 20 && $tag_ponavljanje < 30) $fontSize = "16px"; elseif($tag_ponavljanje >= 30 && $tag_ponavljanje < 40) $fontSize = "18px"; elseif($tag_ponavljanje >= 40 && $tag_ponavljanje < 60) $fontSize = "20px"; elseif($tag_ponavljanje >= 60) $fontSize = "24px"; else $fontSize = "12px"; echo " &nbsp; <a href = \"$ispisi_link/tag/$tag_url\" style=\"font-size: $fontSize;\">$tag</a> &nbsp; "; } </code></pre> But I don't think that this is the perfect way to do it because tags are sorted by id and then all those old tags will never be displayed again because results are sorted by id. What kind of display (query) do you use? What would you advise me about displaying tags? Is it better to sort them by number of repeating of each tag (in my table repeating is called "ponavljanje")? If I use this way then I'm bit afraid that there will be tags that will be repeated in most of content and new one will never be displayed on main page. Or should I maybe use two queries, one for new tags and one for those who are mostly used? Thanks, Ile
Tags
<php><tags>
Title
Php tags display
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USilija veselica
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.