Jump to content
MakeWebGames

Recommended Posts

Posted

Ok i couldn't get the function to work so i just wrote a query ... only problem is nothing is inserting into the table and i think its down to the SELECT query, if someone could point out the error or write it up correctly for me it would be most appreciated, thanks

 

$winner=$db->query("SELECT * FROM users WHERE rampageKILLS > 0 ORDER BY rampageKILLS DESC LIMIT 1");
while($w=$db->fetch_row($winner))
{
$db->query("INSERT INTO events VALUES('',{$w['userid']},unix_timestamp(),0,'text here')"); 
}

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...