Issue on extending-modx/xpdo/class-reference/xpdo/xpdo.query
bennyb opened this issue · 0 comments
bennyb commented
Affected page(s)
https://docs.modx.com/3.x/en/extending-modx/xpdo/class-reference/xpdo/xpdo.query
What needs to be improved?
Under the Select a Single Record the code example
$result = $modx->query("SELECT * FROM modx_users WHERE id=1"); if (!is_object($result)) { return 'No result!'; } else { $row = $result->fetch(PDO::FETCH_ASSOC); return 'Result:' .print_r($row,true); }
Will always return true so should be something like
$result = $modx->query("SELECT * FROM modx_users WHERE id=1"); if(!$result->fetch(PDO::FETCH_ASSOC)) { return 'No result!'; } else { $row = $result->fetch(PDO::FETCH_ASSOC); return 'Result:' .print_r($row,true); }