v5:reference:connection:getcol
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionLast revisionBoth sides next revision | ||
reference:getcol [2015/07/21 16:54] – created mnewnham | v5:reference:connection:getcol [2016/04/22 02:36] – [Description] mnewnham | ||
---|---|---|---|
Line 3: | Line 3: | ||
<WRAP right box> | <WRAP right box> | ||
== syntax == | == syntax == | ||
- | | + | |
mixed $sql | mixed $sql | ||
| | ||
Line 11: | Line 11: | ||
===== Description ===== | ===== Description ===== | ||
- | The function executes a statement and returns the first column of the entire recordset in an array or false if the statement execution fails. | + | The function executes a statement and returns the first column of each row of the the entire recordset in an array or false if the statement execution fails. |
- | For a detailed description of the SQL and bind parameters passed, see [[reference: | + | The presentation of the returned data can be modified by the variables [[v5: |
+ | |||
+ | For a detailed description of the SQL and bind parameters passed, see [[v5:reference:connection: | ||
The optional third parameter passed enables space trimming of the returned value. This is only relevant if the returned string is coming from a CHAR type field. | The optional third parameter passed enables space trimming of the returned value. This is only relevant if the returned string is coming from a CHAR type field. |
v5/reference/connection/getcol.txt · Last modified: 2019/05/08 16:41 by dregad