Re: [PHP-DB] Random pick

Chris wrote:
> David McGlone wrote:
>> On Monday 14 December 2009 21:02:37 Chris wrote:
>>> David McGlone wrote:
>>>> Hi everyone,
>>>>
>>>> I've been lurking in the shadows on the list for quite some time and 
>>>> now
>>>> I'm in need of a little info or advise.
>>>>
>>>> I'm looking for a way to grab a record out of a database on a 
>>>> certain day
>>>> each month and I'm wondering if this can be accomplished with just a
>>>> mysql query or would I need to use PHP also?
>>> A mysql query would do it but you'd use something to talk to mysql and
>>> process the results (whether it's php, perl, python, ruby etc depends on
>>> your other requirements).
>>>
>>
>> What I'm trying to do is to have a record picked from the database at 
>> random on the 1st of every month and display it on the page. Here is 
>> some code I have been working with:
>>
>> $query = "SELECT DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)";
>> $result = @mysql_query($query);
>> if (!$result){
>>
>> $query = "SELECT * FROM monthlyPooch ORDER BY RAND() LIMIT 1";
>> $result = @mysql_query($query);
>>
>> while ($row = mysql_fetch_array($result)){
>> echo "$row[poochName] ";
>> echo "$row[Birthdate]";
>>
>> }
>> }
> 
> You can check the day of the month in php then do your other query:
> 
> $today = date('j');

See http://php.net/date for date formats and what they return.

> if ($today !== 1) {
>   echo "Today isn't the first. No need to continue.\n";
>   exit;
> }
> ..
> random query etc here.
> 


-- 
Postgresql & php tutorials
http://www.designmagick.com/