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
