Forumpost

Posted Yesterday, 11:00 PM"that errors means that you have to valid mysql result resouce passed in mysql_num_rows(). it happends when mysql_query() fails. you have to check why it fails using mysql_error() when mysql_query() fails.SELCT FOUND_ROWS() AS totalRow is different sql query. you have to pass it in different mysql_query() call as you did with your other query. ""$get_cashouts = mysql_query("SELECT CALC_FOUND_ROWS * FROM cashout_history WHERE usrid=$u ORDER BY cdate LIMIT 0,10");"$get_cashouts = mysql_query (SELECT FOUND_ROWS() AS totalRows) friend, I really don't know much about coding, please see if above code is right or not. I don't know how to check msql_query error friend.

Hello friend, I tried it but I am getting some error response in the place of history Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/theprofi/public_html/members/history.php on line 83 Friend, moreover I don't know where to place "SELECT FOUND_ROWS() as totalRows" should I place it under like this"$get_cashouts = mysql_query("SELECT CALC_FOUND_ROWS * FROM cashout_history WHERE usrid=$u ORDER BY cdate LIMIT 0,10");"SELECT FOUND_ROWS() AS totalRows

$get_cashouts = mysql_query("SELECT * FROM cashout_history WHERE usrid=$u ORDER BY cdate"); friend I have taken above code from my script so that you may tell where exactly I can add it. It cashout_history is what I want to make into several pages when it grows.

Friend, thanks for your reply. But I really don't knwo where to put the codeSELECT CALC_FOUND_ROWS *.......LIMITcan you please tell me.

Hello friends. I have a site running, and my site script is php. In members area there a history section where member can see his activities. The problem now is, the history page just keep grows as new activities are taken places, it looks odd as it is keep added in single page. What I want is, I want it create a automated new pages after 25 or 30 history activities like page 1 page 2 so that it looks good. So, please someone help me how to create automated new pages. Thanks.