Re: Random pick

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux