Re: [PHP-DB] Random pick

Dont know if you found anything, but I ran accross this in on of my  
other searches.

http://php.about.com/od/finishedphp1/p/day_redirect.htm

Karl


On Dec 18, 2009, at 10:10 AM, Philip Thompson wrote:

> On Dec 15, 2009, at 6:02 PM, David McGlone wrote:
>
>> On Monday 14 December 2009 21:44:24 Chris wrote:
>>> 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.
>>>
>>
>> Hmmm. This isn't exactly what I'm looking for. What I'm trying to  
>> do is get a
>> new picture on the 1st of every month and display it for that  
>> whole month.
>
> Could you not just create a mysql table that contains the month and  
> a url to a file?
>
> <?php
> // image.php
> $currentMonth = date('n');
> $sql = "SELECT `image_location` FROM `monthly_images` WHERE `month`  
> = $currentMonth LIMIT 1";
> $result = mysql_query($sql);
> list ($loc) = mysql_result ($result);
>
> header ("Content-type: image/png");
> readfile ($loc);
> exit;
> ?>
>
> And then in your HTML:
>
> <img src="image.php" alt="MonthlyImage" title="Yay for me!" />
>
> I just wrote that code here in the email, but it should get you  
> going in the right direction. Hope that helps!
>
> ~Philip
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

Karl DeSaulniers
Design Drumm
http://designdrumm.com