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 [2020/01/02 16:59] (current) – fix obvious typos in the example peterdd
@@ 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 is unsuccessful, (-ve 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 15: @@
  * Connection to DB2 sample database
  */
-$SQL = "SELECT * FROM act"
+$sql = "SELECT * FROM act";
-$recordset = $db->execute($SQL);
+$recordset = $db->execute($sql);
 /*
@@ Line 26: / Line 26: @@
  * Retrieve the record as an object
  */
-$record = $recordset->fetchObj;
+$record = $recordset->fetchObj();
 print_r($record);