Page 1 of 1

Finding rows where date was over 30 days ago or was not set

Posted: Wed Jul 21, 2010 9:02 pm
by Smudly
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:

Code: Select all

<?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;

?>

Re: Finding rows where date was over 30 days ago or was not

Posted: Wed Jul 21, 2010 11:54 pm
by Gargoyle

Code: Select all

SELECT * FROM table WHERE date<NOW()-2592000;

Re: Finding rows where date was over 30 days ago or was not

Posted: Wed Jul 21, 2010 11:56 pm
by John Cartwright
Duplicate. Locked.