Guest User

Untitled

a guest
May 17th, 2018
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. Fatal error: Uncaught Error: Call to a member function fetch() on boolean in C:xampphtdocsphppage.php:544 Stack trace: #0 {main} thrown in C:xampphtdocsphppage.php on line 544
  2.  
  3. $id = "53107933-9793-48FA-94FE-7F4DEB7EFFB6";
  4.  
  5. $idsecond = $id;
  6. $sql1type='SELECT
  7. Person.*
  8. FROM Person LEFT OUTER JOIN
  9. PersonAccount ON Person.PersonUId = PersonAccount.PersonUId LEFT OUTER JOIN
  10. PersonAddress ON Person.PersonUId = PersonAddress.PersonUId LEFT OUTER JOIN
  11. PersonMoreDetail ON Person.PersonUId = PersonMoreDetail.PersonUId
  12. WHERE Person.Type = 0 AND Person.CompanyDepartmentUId = '.$idsecond.' ORDER BY Person.Nr ASC';
  13.  
  14.  
  15.  
  16. $stm1type = $conn->query($sql1type);
  17. while($rows1type = $stm1type->fetch(PDO::FETCH_ASSOC)) {
  18. $id = isset($rows1type['PersonUId']) ? $rows1type['PersonUId'] : NULL;
  19. $cid = isset($rows1type['CompanyDepartmentUId']) ? $rows1type['CompanyDepartmentUId'] : NULL;
  20.  
  21. while($rows1type = $stm1type->fetch(PDO::FETCH_ASSOC)) {
Add Comment
Please, Sign In to add comment