Low End Mac's Online Tech Journal

Fixing a Small Scripting Problem

Website Automation with PHP and MySQL, Part 6

Dan Knight - 2002.05.10

This morning I discovered a problem with the PHP scripts we use to display the Mac of the Day and Email List of the Day.

My #2 son Brian <http://brkn.net/> and I came up with the following code to display the Mac of the Day:

<?php
$host = "sqlserver.lowendmac.com";
$username = "MyName";
$password = "MyPassword";
$connection = @mysql_connect($host,$username,$password);
mysql_select_db(lem_mod,$connection);
$today = round((date(U) + 32400) / 86400);
$mod = $today % 89;
$query = mysql_fetch_array(mysql_query("select * from mod where id = '$mod'"));
echo "<B><BR>Mac of the Day</B><BR> <A HREF=/$query[link]>$query[model]</A>";
$lod = $today % 38;
$query = mysql_fetch_array(mysql_query("select * from lists where id = '$lod'"));
echo "<B><BR>List of the Day</B><BR> <A HREF=\"$query[link]\">$query[listname]</A><BR>";
?>

Notice the line near the middle - $mod = $today % 89;

That line tells PHP to use modulo arithmetic to divide today's date (converted to a number) by 89 and discard everything but the remainder. This would give us 89 unique values - just what we need with 89 entries in the Mac of the Day database.

The problem is, modulo arithmetic returns a remainder from 0 (zero) to one less than your maximum number, so our function was using numbers from 0 to 88. And our database uses numbers from 1 to 89.

We use a similar function to handle the 38 email lists, and that's where I noticed the problem this morning. Today the email list script was returning zero, so no list was displayed.

All we have to do is add one to the number returned to have values in the range we need. I've modified two lines, uploaded the new script, and now everything works:

$mod = ($today % 89) + 1;
$lod = ($today % 38) + 1;

The Next Project

I'd planned on automating site links next, but have instead decided that the next project will be automating the Deal of the Day. This will involve real calendar dates, not raw numbers based on seconds since 1970.01.01.

I hope to cover this project next week.

Join us on Facebook. Follow us on Twitter.

Recent Online Tech Journal Columns

Optimized Software Builds Bring Out the Best in Your Mac, 2009.06.30. Applications compiled for your Mac's CPU can load more quickly and run faster than ones compiled for universal use.
Low End Mac's Safe Sleep FAQ, 2009.06.15. What is Safe Sleep mode? Which Macs support it? How can you enable or disable it? And more.
The Original Macintosh, 2009.01.12. An in-depth look at the original Macintosh and how it shaped future Macs.
More in the Online Tech Journal index.

Links for the Day

Mac of the Day: Macintosh Portable, introduced 1989.09.20. The nearly 16 lb. behemoth was innovative but not a smashing success.
February 12 in LEM history: 99: $4,320 for a 'free' iMac - 01: 10 Commandments of Macintosh - High-end word processing for free - 02: 8 OS X gotchas - Working less with my Mac than with my PC - Microsoft Office v. X - 03: New Zealand's Mac mag - 04: Nothing else is a Mac - 07: On Mighty Toaster Wings - Jobs stirs up DRM hornet's nest - OS X 10.2 best for Classic? - 08: Too much software choice is not a blessing - A month with Windows
Support Low End Mac

Recent Deals

About LEM Support Usage Privacy Contact

Low End Mac is an independent publication and has not been authorized, sponsored, or otherwise approved by Apple Inc. Entire Low End Mac website copyright ©1997-2012 by Cobweb Publishing, Inc. unless otherwise noted. All rights reserved. Apple, the Apple logo, Macintosh, iPad iPhone, iMac, iPod, MacBook, MagSafe, Mac Pro, Apple TV, and AirPort are registered trademarks of Apple Inc. Additional company and product names may be trademarks or registered trademarks and are hereby acknowledged.
Advice is presented in good faith, but what works for one may not work for all. Please report errors to .
LINKS: We allow and encourage links to any public page as long as the linked page does not appear within a frame that prevents bookmarking it.
Email may be published at our discretion unless marked "not for publication"; email addresses will not be published without permission, and we will encrypt them in hopes of avoiding spammers. Letters may be edited for length, context, and to match house style.
PRIVACY: We don't collect personal information unless you explicitly provide it. For more details, see our Terms of Use.

Custom Search

Follow Low End Mac on Twitter
Join Low End Mac on Facebook

Low End Mac Reader Specials

TypeStyler 11 is now in the Mac App Store!! -- Special Introductory Price of $59.95!! -- To Buy From The Mac App Store Click Here Now!! Or buy direct from Strider Software.

Don't install Parallels to play poker online! Poker Mac will show you how to download and install a native Mac poker and Mac Casino applications in minutes.

Affiliates

Amazon.com
The Apple Store
The iTunes Store
PC Connection Express
GainSaver
Parallels Desktop for Mac
eBay