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/76625-solved-ramdom-wins/ Share on other sites More sharing options...
pocobueno1388 Posted November 9, 2007 Share Posted November 9, 2007 You can select a random row in your query, so that will make it easier <?php $query = "SELECT username FROM lottery ORDER BY rand() LIMIT 1"; $result = mysql_query($query)or die(mysql_error()); $row = mysql_fetch_assoc($result); mysql_query("UPDATE players SET credits=credits+$prize WHERE user='{$row['username']}'"); ?> Link to comment https://forums.phpfreaks.com/topic/76625-solved-ramdom-wins/#findComment-387992 Share on other sites More sharing options...
grlayouts Posted November 9, 2007 Author Share Posted November 9, 2007 played about with it, thanks for the help mate. Link to comment https://forums.phpfreaks.com/topic/76625-solved-ramdom-wins/#findComment-388012 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.