Home « Help index « Formatting Codes «
Codes to format tables
SELECT * FROM yacs_articles WHERE (nick_name LIKE 'menu') OR (handle LIKE 'menu') ORDER BY publish_date DESC LIMIT 1
1146: Table 'challengeddf.yacs_articles' doesn't exist
SELECT * FROM yacs_sections AS sections WHERE (sections.nick_name LIKE 'navigation_boxes') ORDER BY edit_date DESC LIMIT 1
1146: Table 'challengeddf.yacs_sections' doesn't exist
SELECT * FROM yacs_categories AS categories WHERE ((categories.display LIKE 'site:all') AND ((categories.active='Y') AND ((categories.expiry_date is NULL) OR (categories.expiry_date <= '0000-00-00 00:00:00') OR (categories.expiry_date > '2025-05-12 07:34:31')))) ORDER BY categories.rank, categories.edit_date DESC, categories.title LIMIT 0,15
29: File './challengeddf/yacs_categories.MYD' not found (Errcode: 2)
SELECT sections.* FROM yacs_sections AS sections WHERE (sections.anchor='' OR sections.anchor IS NULL) AND (sections.active='Y') AND (sections.index_panel LIKE 'main') AND ((sections.index_map IS NULL) OR (sections.index_map != 'N')) AND ((sections.activation_date is NULL) OR (sections.activation_date <= '2025-05-12 07:34:31')) AND ((sections.expiry_date is NULL) OR (sections.expiry_date <= '0000-00-00 00:00:00') OR (sections.expiry_date > '2025-05-12 07:34:31')) ORDER BY sections.rank, sections.title, sections.edit_date DESC LIMIT 0,15
1146: Table 'challengeddf.yacs_sections' doesn't exist
On this page we are showing how to build simple tables. Use the char |, or tab, or two successive spaces, to separate column elements.
Table [table]...[/table]
In this example cells are separated by tabulation characters or by 2 spaces.
| Example | Rendering |
|---|
[table]
Rabbit Turtle
Stories Jean[nl]de la Fontaine
[/table] |
| Rabbit | Turtle |
| Stories | Jean
de la Fontaine |
|
Table [table=grid]...[/table]
In this example cells are separated by the | character.
| Example | Rendering |
|---|
[table=grid]
Rabbit|Turtle
Stories|Jean[nl]de la Fontaine
[/table] |
| Rabbit | Turtle |
| Stories | Jean
de la Fontaine |
|
Table [table=tiny]...[/table]
Actually any style can be applied to the generated table.
| Example | Rendering |
|---|
[table=tiny]
Rabbit|Turtle
Stories|Jean[nl]de la Fontaine
[/table] |
| Rabbit | Turtle |
| Stories | Jean
de la Fontaine |
|
Separate headers from the body [table]...[body]...[/table]
| Example | Rendering |
|---|
[table=grid]
First Name|Last Name
[body]
Rabbit|Turtle
Stories|Jean[nl]de la Fontaine
[/table] |
| First Name | Last Name |
|---|
| Rabbit | Turtle |
| Stories | Jean
de la Fontaine |
|
Explicit cells alignment
| Example | Rendering |
|---|
[table=grid]
left=Full Name| center=Birth Year| right=Net income
[body]
right=Speedy Rabbit|center=1888|$11,230
center=Jean de la Fontaine|center=1675|$234,567
[/table] |
| Full Name | Birth Year | Net income |
|---|
| Speedy Rabbit | 1888 | $11,230 |
| Jean de la Fontaine | 1675 | $234,567 |
|
Comma-separated values [table][csv]...[/csv][/table]
| Example | Rendering |
|---|
[table=grid]
[csv]
Net income for the year,$2.310
Net income for last year,$2.100
Net income increase,10%
[/csv]
[/table] |
| Net income for the year | $2.310 |
| Net income for last year | $2.100 |
| Net income increase | 10% |
|
Comma-separated values [table][csv=;]...[/csv][/table]
Using a different separator between cells.
| Example | Rendering |
|---|
[table=grid]
[csv=;]
Net income for the year;$2.310
Net income for last year;$2.100
Net income increase;10%
[/csv]
[/table] |
| Net income for the year | $2.310 |
| Net income for last year | $2.100 |
| Net income increase | 10% |
|
