This is quotes.php: [code] <style type="text/css"> <!-- .style1 { font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold; color: #E5E6E7; } .style2 { font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-style: italic; color: #E5E6E7; } --> </style> </head> <body bgcolor="#696d71"> <img src="images/tip.gif" > <span class="style1">Quote of the day - <?php echo date("F jS, Y"); ?></span> <table border="0" cellpadding="6" width="40%" cellspacing="0"> <tr> <td width="100%" class="style2"><code> <?php // ***************************************************************************** // -------"The World's simplest PHP Message/Quote of the Day Script"---------- // // Author: Mads Søgaard (mads@acm.org) // Homepage: http://www.emacs.dk/quote/ // Version: 1.0 // // // ***************************************************************************** // -------------------- Description -------------------------------------------- // // "The World's simplest PHP Message/Quote of the Day Script" is a simple // "quote-of-the-day script" that needs access to a MySQL database. It only // consists of one script that's SIMPLE and hence easy to customize. This is how // it works: You put any number of quotes/messages/whatever into the database, // and then the script will show one quote every day. When all quotes have been // shown, the script starts from the beginning of the quotes again. And if your // quote-of-the-day page doesn't receive any visitors on a given day, the given // quote-of-the-day will be shown the next day too. It simple, yet smart. // // // ***************************************************************************** // -------------------- Installation -------------------------------------------- // 1. Upload the quote.php to your web server. // 2. Change the following variables $DB_SERVER,$DB_USER, $DB_PASS, $DB_NAME // (see below) // 3. Create the needed tables in your database with the quotes.sql file. // You can do it from the prompt (mysql -u[username] [-p] [database] < quotes.sql) // or you can use the wonderful phpMyAdmin at http://www.phpwizard.net/projects/phpMyAdmin/ // 4. Point your browser to http://yourdomain/quotes.php // 5. Add your own quotes to the database and custumize the script as you see fit. // // ***************************************************************************** // -------------------- Do you find this script useful? ------------------------ // // Then by all means recommend it to other people! Or link back to me from your // homepage (that would be greatly appreciated) // You can also review my script and give it good grades at: // http://www.hotscripts.com/PHP/Scripts_and_Programs/Quote_Display/ // (or anywhere else you may have found it) // // ****************************************************************************** // **************************************** // Fill in your database information below // **************************************** $DB_SERVER = "mysql"; $DB_USER = "name"; $DB_PASS = "pwd"; $DB_NAME = "quotes"; // **************************************** // **************************************** // you do NOT have to edit below this line // **************************************** $con = mysql_connect($DB_SERVER, $DB_USER, $DB_PASS); mysql_select_db($DB_NAME); $getNoOfQuotesQuery = mysql_query("select count(*) from quotes", $con); $no_of_quotes = mysql_result($getNoOfQuotesQuery,0); $getMetaDataQuery = mysql_query("SELECT * FROM quotes_meta", $con); $row = mysql_fetch_row($getMetaDataQuery); $number_reached = $row[1]; $date_modified= $row[2]; // get the current day of the month (from 1 to 31) $day_today = date("j"); if ($date_modified != $day_today){ // we have reached the end of the quotes if ($number_reached >($no_of_quotes - 1)){ $number_reached = 1; $query3 = mysql_query('UPDATE quotes_meta SET date_modified = "'.$day_today.'", number_reached = "'.$number_reached.'"', $con); mysql_query($query3,$con); } else { // we haven't reached the end of the quotes // therefore we increment $number_reached $number_reached = $number_reached + 1; $query3 = mysql_query('UPDATE quotes_meta SET date_modified = "'.$day_today.'", number_reached = "'.$number_reached.'"', $con); mysql_query($query3,$con); } } // we get the quote with 'id = $number_reached' from the database $getQuoteQuery = mysql_query("SELECT quote,author FROM quotes WHERE id = ".$number_reached, $con); $row = mysql_fetch_row($getQuoteQuery); // we print the quote ($row[0]) and the author ($row[0]) echo $row[0]."<p align='right'><i>~ " . $row[1]; // close the database connection mysql_close($con); ?> </i></code></td> </tr> </table> <p> </p> </body> </html> [/code] ************************* Then there's an SQL file that goes with it....