[SOLVED] ramdom wins

[grlayouts]

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?

[pocobueno1388]

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']}'");

?>

[grlayouts]

played about with it, thanks for the help mate.