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? Link to comment https://forums.phpfreaks.com/topic/76626-ramdom-wins/ 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. Link to comment https://forums.phpfreaks.com/topic/76626-ramdom-wins/#findComment-387993 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.