ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:userguide:learn_abstraction:basic_query

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
v5:userguide:learn_abstraction:basic_query [2016/03/15 01:23] – mnewnhamv5:userguide:learn_abstraction:basic_query [2016/03/15 14:27] (current) – mnewnham
Line 51: Line 51:
  
 ^Command^Description| ^Command^Description|
-|[[v5:reference:connection:getcol|getCol()]]|Executes a provided SQL statement and returns the first row of the entire recordset into a numeric array|  +|[[v5:reference:connection:getcol|getCol()]]|Executes a provided SQL statement and returns the first **column** of the entire result set into a numeric array, no matter how large. If multiple columns are retrieved by the SQL statement, all but the first are discarded|  
-|[[v5:reference:connection:getone|getOne()]]|Retrieves the first column of the first matching row of an executed SQL statement|  +|[[v5:reference:connection:getone|getOne()]]|Executes a provided SQL statement and returns the first **column** of the first matching **row** into a variable. If multiple columns are retrieved by the SQL statement, all but the first are discarded|  
-|[[v5:reference:connection:getrow|getRow()]]|Retrieves the first matching row of an executed SQL statement|+|[[v5:reference:connection:getrow|getRow()]]|Executes a provided SQL statement and returns the first matching **row** into a array. If multiple rows are retrieved by the SQL statement, all but the first are discarded|
v5/userguide/learn_abstraction/basic_query.1458001409.txt.gz · Last modified: (external edit)