Differences

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

--- v5:reference:recordset:move [2016/01/17 00:57] – ↷ Page moved from v5:reference:move to v5:reference:recordset:move mnewnham
+++ v5:reference:recordset:move [2026/02/08 11:04] (current) – [Description] dregad
@@ Line 8: / Line 8: @@
 </WRAP>
 ===== Description =====
-The function ''move()'' moves the cursor to the n<sup>th</sup> record in a recordset. Offsets are zero-based. If the cursor is successfully moved then the function returns true. If the move is unsuccessful, (-ve offset, passed EOF etc) the function returns false. Note that some databases do not support moving to previous rows (scrolling backwards)
+The function ''move()'' moves the cursor to the n<sup>th</sup> record in a recordset. Offsets are zero-based.
+If the cursor is successfully moved then the function returns true.
+If the move fails (negative offset, passed EOF, etc), the function returns false.
+Note that some databases do not support moving to previous rows (scrolling backwards).
 -------------------------------------------
 ===== Usage =====
@@ Line 15: / Line 21: @@
  * Connection to DB2 sample database
  */
-$SQL = "SELECT * FROM act"
+$sql = "SELECT * FROM act";
-$recordset = $db->execute($SQL);
+$recordset = $db->execute($sql);
 /*
@@ Line 26: / Line 32: @@
  * Retrieve the record as an object
  */
-$record = $recordset->fetchObj;
+$record = $recordset->fetchObj();
 print_r($record);