The content extracted from the selection made by a SPIP loop is displayed by using tags. Systematically, whenever a table has an SQL field "x", SPIP is able to provide/display the contents of that field by using the syntax
- #X - #NAME_OF_SQL_FIELD - #NONEXISTENT_FIELD<br />
SPIP will not create an SQL query for ALL of the table’s columns (
SELECT * ...) in order to retrieve the requested data, but, will, at each occasion, issue a specific data request – in this case, it would be
SELECT x, name_of_sql_field FROM spip_table.
Whenever a field does not exist in the SQL table, like “nonexistent_field” in our example above, SPIP will not insert it into the table query, but will attempt to recover a value for the field from a surrounding loop – if there are any. If there is no parent loop with such a field, then SPIP looks into the environment, just as if you had written