query.get_row
/
Database /
query.get_row
By Amit Singh. Posted on
| Title |
: |
query.get_row |
| Purpose |
: |
It Returns one single row as an array. Use when you are expecting the output to be 1 column. |
| Syntax |
: |
|
|
[query.get_row set="template.res"] //** Your SQL query goes here **// [/query.get_row] |
|
| Input Parameters |
: |
query: (int) (Required) SQL query to execute. |
| Return Value |
: |
It returns: Database query result in format ARRAY_A or null on failure |
| Example 1 |
: |
| Code |
: |
|
|
[query.get_row dump=1] SELECT * FROM `wp_posts` [/query.get_row] |
|
| Output |
: |
 |
| Description |
: |
The above example code will output the SQL query result in array as shown above. The query has return one row and we can use the key directly here. |
|
Last Modified By abhishek.