Recherche avancée

Sur d’autres sites (696)

• Joins between tables

  17 août 2010, par Mark — A few examples of loops

  Some examples of loops that generate multiple joins between 3 tables [spip 2.0.9] We would like, in a single loop, to retrieve the data from some articles from one (or several) sections to which a predetermined keyword has been assigned. will generate the following SQL query : SELECT (...)

• #DOUBLONS

  17 août 2010, par Mark — Tags

  #DOUBLONSkeywords or #DOUBLONSkeywords,family outputs the status of the duplicates tagged with (KEYWORDS) at this location in the code, in the form of an array of id_mot values : array(1,2,3,...) #DOUBLONS just by itself generates the raw list of all the duplicates. #DOUBLONS*keywords generates (...)

• |date_relative

  16 août 2010, par Mark — Filters

  The |date_relative filter, when applied to any #DATE... type tag, will display information associated with the tag depending on the context date. Example : the current date and time is Friday 25th September 2009 14:20. An article was recently published on Wednesday 23rd September 2009 at 10:20. (...)