You tell me what the subject should be???

[littlab]

I want to create a draft page for a FFL that will automatically put the person's username when it is his/her turn to pick. After the submit button is hit I want the screen to show USERNAME2 it's your pick. Then when USERNAME2 drafts his/her player I want it to display USERNAME3 it's your pick. Right now I have a javascript that will generate random numbers (User#) for the draft order. Each USERNAME is tied to a User# therefore I want to be able to use the random numbers generated to decide what name comes up next. I know how to search the table but how to get it to decide what USER is next is the tricky part for me.

Anyone have any ideas???

[GilesGuthrie]

I do something similar. I have a page that auto-refreshes, running through a list until it gets to the end.

It calls updateteam.php, with an id, which corresponds to the team. Because it's admin-side, I do it in javascript, using the setTimeout() method, but you could do it using the META refresh tag. Basically, you need PHP to write the id into the URL.

Elsewhere in the code, I'm checking for the highest ID of a team, then there's a test to stop the page from going past the end of the list.

The provisos on this are:

• You wish to access each user in turn.

• The users have sequential IDs.

Thus:

<?php
if(!isset($id)
{
    $id =1;
}
else
{
   $nextpage = $id +1;
}
?>
<script language="javascript">
<?php if($nextpage <= $nteams) echo "setTimeout(\"window.location.href('adminupdateteams.php?rid=".$rid."&id=".$nextpage."')\", 1000)"; ?>
</script>

HTH! 🙂