I'm creating a daily drawing system. The users have a chance to win every day. Once a user wins, they will not be able to win again for 30 days. I need to select all rows inside my mysql database that have dates over 30 days ago, or are still set as default (0000-00-00). How can I do something like this?

I've tried a few different ways but none seem to work. Once these rows are selected, it randomly chooses 3 winners, and sets their new dates to the current date.

Current code:

PHP Code:

<?php

include_once('../inc/connect.php');

$date = date("Y-m-d");

$drawquery = mysql_query("SELECT id FROM users ORDER BY rand() LIMIT 1");
$row = mysql_fetch_assoc($drawquery);

$wondaily = $row['wondaily'];

$userid = $row['id'];
echo $userid;

?>

A one way is:

$time = strtotime(date("Y-m-d")) - 60*60*24*30;
$date = date("Y-m-d", $time);
$drawquery = mysql_query("SELECT `id` FROM `users` WHERE `date` > '".$date."' ORDER BY rand() LIMIT 1");

select * from users where date > now() - interval 30 day or date = 0 order by rand limit 3