RyanWalsh3387

Hi All, Right now I have a statistic on my home page that is gathered from querying the database. I would rather this statistic only be queried every hour or so instead of everytime someone lands on the home page! It seems my google skills are not very high today as I can't seem to find any easy instructions on how to do this. Any help would be appreciated. Essentially I want to pass array variable data(top 5 users and their last purchase) from a cron file to the home page. Thanks, Ryan

Minor changes made--but that did the trick--thanks so much!!

A win/loss report for Players in a game. Thanks! I will have the script do multiple checks, but for the most part your true/reject logic is basically it. I'll dive more into the actual scenario for everyone! A game is played amongst two players. When Player 1 or Player 2 reports the winner, the other player will then have 24 hours to confirm or deny the report. If the other player does not make any report within 24 hours, the winner goes as reported by the first player and the records will be updated. I have these fields on one table: idGame | Player | Winner_report | Winner_report_timestamp | Game_status (1 = In progress, 2 = winner reported, 3 = match confirmed by both players, 4 = match confirmed by reporter, 5 = rejected) an example would be the following: 1 | Joe | Joe | 10/15/2013 6:13:13 | 2 1 | Steve | ''| '' | 2 2 | Mary | Mary | 10/15/2013 7:13:13 | 2 2 | Alison | " | '' | 2 Steve needs to confirm that Joe was the winner. He has 24 hours to do so or the row will autofill in Joe as the winner and change the status to 4 and Joe will be the winner. Would the logic be something like this: Cron job to run every minute to check if 1 row of Game NOT NULL for Winner_report and 1 row of Game IS NULL for Winner_report, then check to see if time is 24 hours past timestamp, and if it is change status to 4 and change records of players based on Winner_report of NOT NULL? Thanks!! Ryan

Hi cyberRobot, So I set a timestamp up for that purpose, but I am not certain how to make a script run at 24 hours after the event is triggered. Any ideas? Thanks, Ryan

Hi all, So here is the scenario 1: User 1 reports A, B, or C 2: User 2 has 24 hours to confirm(or reject) what User 1 reported. 2a: If User 2 does not report within 24 hours, User 1 report is considered true. I am using PHP + MySQL. Can anyone advise what they would do to tackle this scenario? Thanks, Ryan

Thanks All, Maniac Dan's solution seemed to fit best for me. Barand, I think that would work if successive was the method, but a user can click on any page they want. I know in my scenario there were only two pages, but the real use case there will be multiple pages that they can jump to. I didn't think of using sessions to store them, I will definitely use that knowledge in the future so thanks for that. Thanks everyone-- I really appreciate the help.

Thanks for the replies. Pagination is actually set up properly for me. I think what I am looking for is a slightly advanced version of pagination. If anyone can think of a way to do this please help! Thanks! -Ryan

How can I set the range of rows to display on an array? For example, I have a query with 20 results. I want page 1 to display rows 1-10 . I want page 2 to display rows 11-20. Orginially I set this up just using a LIMIT and OFFSET, however that does not work with my ranking field (it would set the first rank of the second page back to 1 rather than its proper rank, and since ties can happen I couldn't just use the value prior to it, as 7, 8, 9, and 10 could all really be rank 7, and if 11 has the same score as 7-10 it too should be rank 7, not 11) this is what i have so far: $max_results = 10; $cur_page = 1 $query3 = "SET @rank = 0, @prev_rank = -1, @rownum = 0"; $result3=mysql_query($query3); $query = "SELECT *,@rownum := @rownum + 1 AS row, @rank := if (@prev_rank<>Score, @rownum,@rank) AS ranking, @prev_rank:= Score AS score FROM blah blah blah" $result = mysql_query($query) while ($row = mysql_fetch_assoc($result)) { echo "".$row['ranking'].""; } Thanks for the help! -Ryan edit--I believe there are two solutions to this which both I can not figure out--- 1: Find a way to find query the rows prior to the starting row 2: Find a way to display a set range of rows from the query.