query.get_col
/
Database /
query.get_col
By Amit Singh. Posted on
| Title |
: |
query.get_col |
| Purpose |
: |
It Returns values of particular column. Use when you are expecting the output to be 1 column. |
| Syntax |
: |
|
|
[query.get_col set="template.res"] //** Your SQL query goes here **// [/query.get_col] |
|
| Input Parameters |
: |
query: (int) (Required) SQL query to execute. |
| Return Value |
: |
It returns: Database query result. Array indexed from 0 by SQL result row number. |
| Example 1 |
: |
| Code |
: |
|
|
[query.get_row dump=1] SELECT post_title FROM `wp_posts` limit 5 [/query.get_row] |
|
| Output |
: |
 |
| Description |
: |
The above example code will output the SQL query result in array as shown above. The query has return values of column post_title from wp_post table. |
|
Last Modified By abhishek.