Dormilich's Profile User Rating: *****

Reputation: 3652 Guru
Group:
Mentors
Active Posts:
10,869 (6.19 per day)
Joined:
08-June 10
Profile Views:
55,261
Last Active:
User is offline Mar 27 2015 03:18 PM
Currently:
Offline

Previous Fields

Country:
DE
OS Preference:
Mac
Favorite Browser:
FireFox
Favorite Processor:
Who Cares
Favorite Gaming Platform:
Who Cares
Your Car:
Volkswagen
Dream Kudos:
1000
Expert In:
PHP
Icon   Dormilich DÜV core member

Posts I've Made

  1. In Topic: looking up tagged entries

    Posted 27 Mar 2015

    completely new idea popping up:
        COUNT(t2.tag) tagmatch
     ...
    
    LEFT JOIN tags t2
        ON t2.server_id = s.id AND t2.tag IN (/* list of tags */)
     ...
    
    HAVING
        tagmatch = {numer of categories}
    
    

    although that assumes that only one tag per group is set
  2. In Topic: looking up tagged entries

    Posted 27 Mar 2015

    I’ll have to wait til next week to test it out.
  3. In Topic: looking up tagged entries

    Posted 27 Mar 2015

    could I do it like in post #6 or is that way off?
  4. In Topic: looking up tagged entries

    Posted 27 Mar 2015

    could I use a subselect instead of the temporary table?

    (still need that complete tag count for something else because I cannot display all assigned tags at once (a matter of display space))
  5. In Topic: looking up tagged entries

    Posted 27 Mar 2015

    Don’t have the query open right now, so I try to reconstruct it off the top of my head.
    SELECT
        s.*, -- in reality I list all fields explicitly
        COUNT(t.tag) tagcount,
        GROUP_CONCAT(t.tag SEPARATOR ' ') taglist,
        -- some more live info about the server status
    FROM
        servers s
    LEFT JOIN
        status st ON ... 
    LEFT JOIN
        location l ON ...
    LEFT JOIN
        categories cat ON ...
    LEFT JOIN
        tags t ON t.server_id = s.id
    LEFT JOIN
        clients c ON ...
    LEFT JOIN
        -- there can be several cards per server
        networkcard nc ON nc.server_id = s.id
    WHERE
    --  c.id = ?
    --  l.id = ?
    --  cat.id = ?
    --  etc.
    GROUP BY
        s.id
    HAVING 
        tagcount > 0
    
    


    funny thing … I came up with something similar.

My Information

Member Title:
痛覚残留
Age:
Age Unknown
Birthday:
April 18
Gender:
Location:
Behind the Wall
Interests:
kicking Pardona’s a**(*)
Full Name:
Bertold von Dormilich
Years Programming:
10
Programming Languages:
JavaScript, PHP, XSLT, Turbo Pascal, BASIC

Contact Information

E-mail:
Private
AIM:
AIM  Dormilich
Skype:
Skype  Dormilich

Comments

  • (2 Pages)
  • +
  • 1
  • 2
  1. Photo

    Herman de Vries Icon

    08 Aug 2014 - 12:26
    Thanks a lot for your recent help!
  2. Photo

    EdNolan Icon

    30 Nov 2013 - 15:36
    Many thanks for all the many times you have helped me !!!
  3. Photo

    andrewsw Icon

    02 Aug 2013 - 14:40
    Congratulations on 3000+, a nice big number!
  4. Photo

    raghav.naganathan Icon

    28 Dec 2012 - 04:26
    Dude...you sure are the best in the web development forums!!! :)
  5. Photo

    htmlovin Icon

    16 Oct 2012 - 07:21
    Great help thanks! This guy knows his stuff helping me clear up somethings in html/css
  6. Photo

    AnalyticLunatic Icon

    25 Sep 2012 - 12:48
    Just wanted to stop by and say thanks for that bit about "clear:both" when using floats in HTML/CSS. That solved a long-standing issue I have been having in Firefox! ^^
  7. Photo

    vivian2012 Icon

    17 May 2012 - 12:24
    Hello dear friend,

    Great to communicate with you and to know each other for relationship if you don't mind and have desire to correspond with me,i will appreciate you communication through my email address so that we can get to know more of each other.

    my email is ( vivianwilliams40@yahoo.com )
    vivianwilliams40 at yahoo dot com
  8. Photo

    RudiVisser Icon

    05 Sep 2011 - 04:32
    Thank you! :D
  9. Photo

    RudiVisser Icon

    12 Aug 2011 - 02:35
    Thanks yeah, the session class I have is pretty much like that, but also acts as a singleton and fake session handler! Both get the exact same effect :D
  10. Photo

    aaron1178 Icon

    31 Jul 2011 - 16:50
    Isn't it about time you get a promotion to moderator it think :)
  11. Photo

    codeprada Icon

    26 Apr 2011 - 13:12
    congratz... i gave u ur 900th rep
  12. Photo

    bhoop_computers Icon

    25 Apr 2011 - 19:20
    hello
  13. Photo

    Vip3rousmango Icon

    13 Apr 2011 - 07:58
    Thanks for the rep! :) Appreciated.
  14. Photo

    EnvXOwner Icon

    19 Mar 2011 - 10:35
    Hey! I found you on, http://bytes.com/dormilich
  15. Photo

    skyhawk133 Icon

    05 Mar 2011 - 08:35
    Thanks for all you've done for DIC lately! Congrats on the forum leader of the month recognition!
  • (2 Pages)
  • +
  • 1
  • 2