User Profile

Collapse

Profile Sidebar

Collapse
2020
2020
Last Activity: Jul 1 '20, 01:18 PM
Joined: Jun 27 '20
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • 2020
    replied to Why WHILE LOOP Fails After One Execution ?
    in PHP
    SioSio,

    I just realized that, $_SESSION['row_count'] = 5, when I click the SEARCH button. 5 matching rows found.

    Then when I click PAGE 2 on pagination, the $_SESSION['row_count'] = 0, why is that ? It should stay 5. i am not overwriting the variable value either.

    This is the reason why, when I click PAGE 2 or PAGE 3 on the PAGINATION section, I see zero results or rows shown. No rows get shown beyond...
    See more | Go to post

    Leave a comment:


  • 2020
    started a topic Why WHILE LOOP Fails After One Execution ?
    in PHP

    Why WHILE LOOP Fails After One Execution ?

    Hiya,

    Php gurus, can you tell me is this query ok to get row count ? It works here:

    Code:
    $query_2 = "SELECT * FROM users WHERE first_name = ? AND marital_status = ? LIMIT $offset,$last_row_on_page";
    The rows_count() function uses the above query.
    Then it forwards you to the fetch_rows() function that fetches the rows and displays them in a pagination way to you.

    ...
    See more | Go to post
No activity results to display
Show More
Working...