grlayouts Posted November 9, 2007 Share Posted November 9, 2007 I have a simple lottery game. you buy a ticket and it enters your user name and an id number (auto increment) into a table ie, 1 Admin 2 dude2 3 dude now every hour i want to run a file which chooses a random winner. but so far it doesn't work. <?php $time=time(); include("config.php"); $winner = rand(1,$winner); $winz=mysql_fetch_object(mysql_query("SELECT * FROM lottery WHERE user='$winner'")); $winner_stuff=mysql_fetch_row(mysql_query("SELECT SUM(pot) FROM lottery;")); mysql_query("UPDATE players SET credits=credits+$prize WHERE user='$winz'"); ?> how far off am i? Quote Link to comment Share on other sites More sharing options...
pocobueno1388 Posted November 9, 2007 Share Posted November 9, 2007 Why did you post this twice? I replied on your last thread. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.