Results 1 to 4 of 4

Thread: [RESOLVED] go to next user?

Threaded View

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Jun 2008
    Posts
    1,023

    Resolved [RESOLVED] go to next user?

    i'm making a project where people can click on others links and well when this is clicked i want it to go to the next user thats in the 'users' table(not clicks) and well, the current user would be the receiver, now what i need is to find the user that comes after $receiver in the users table

    PHP Code:
    if (isset($_POST['sendclick'])) {
    $currentweek date("W"time());
    $clickresult mysql_real_escape_string($_POST['clickresult']);
    $username mysql_real_escape_string($_POST['username']);
    $receiver mysql_real_escape_string($_POST['receiver']);
    if (!(
    $username == "(Choose Username)")) {
    mysql_query("INSERT INTO clicks (clicker, receiver, week, message) VALUES ('".$username."', '".$receiver."', '".$currentweek."', '".$clickresult."')");
    /* 
    $nextuser will be the user after the current $receiver.
    what i need is to select all from users and get the next user on the list...
    header("Location: index.php?view=recruit&click=$nextuser"); 
    */
    }

    i put a comment in the code so i could make a bit more sense, and if this doesn't make any sense at all or almost no sense, please ask...
    Last edited by Justa Lol; Feb 18th, 2010 at 08:08 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width