Re: 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