ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:recordset:fields

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
reference:fields [2015/07/22 19:28] – [Usage] mnewnhamv5:reference:recordset:fields [2018/06/11 10:16] (current) – [Usage] function names starting with lowercase (#426) dregad
Line 1: Line 1:
 ====== fields ====== ====== fields ======
 +~~NOTOC~~
 <WRAP right box> <WRAP right box>
     mixed fields(     mixed fields(
           optional int $offset=1           optional int $offset=1
           )           )
-<WRAP>+</WRAP>
 ===== Description ===== ===== Description =====
-The function ''fields()'' returns the value of the column at the specified offset. The offset is always an integer number, beginning at 1. If the offset is negative, or greater than the number of columnsobtained through [[reference:fieldcount|fieldCount()]], the value returned is identical to false (===). If no offset is provided, the value of the first column is returned.+The function ''fields()'' returns the value of the column at the specified offset. The offset is always an integer number, beginning at 1. If the offset is negative, or greater than the number of columns obtained through [[v5:reference:recordset:fieldcount|fieldCount()]], the value returned is identical to false ''===''. If no offset is provided, the value of the first column is returned.
 ====== Usage ===== ====== Usage =====
 <code php> <code php>
Line 12: Line 13:
  * DB Connection assumed  * DB Connection assumed
  */  */
-$result = $db->Execute("SELECT * FROM ACT"); +$result = $db->execute("SELECT * FROM ACT"); 
-$r = $result->FetchRow();+$r = $result->fetchRow();
 print $r->fields(1); print $r->fields(1);
 /* /*
v5/reference/recordset/fields.txt · Last modified: 2018/06/11 10:16 by dregad