Just a copy/paste of one of the previous codes, except for all the source codes
As long as i keep it “un-official”, then i THINK i can’t get into trouble
But then again, the church can request that i take down that thingy on the right side
While i’m at it, i may as well document everything i’m doing?
First thing, make the database
CREATE TABLE `emyf` ( `Date` date NOT NULL, `Special` varchar(255) NOT NULL, `PIC` varchar(45) NOT NULL, `P&W` varchar(45) NOT NULL, `Musician` varchar(45) NOT NULL, `Tech` varchar(45) NOT NULL, `Food/Cleaning` varchar(45) NOT NULL, PRIMARY KEY (`Date`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
After that, you need to insert the data?
/*!40000 ALTER TABLE `emyf` DISABLE KEYS */; INSERT INTO `emyf` (`Date`,`Special`,`PIC`,`P&W`,`Musician`,`Tech`,`Food/Cleaning`) VALUES ('2010-01-30','Welcome Night - Pot Luck, Talk and Games','Matt','Venus','Sally','Michelle','Everyone'), ('2010-02-06','Bible Study - Christian Beliefs','Sally','Matthew','Jeffrey','Aaron Wong','Sally'), ('2010-02-13','Ice-skating','Jenny','-','-','-','-'), ('2010-02-20','Bible Study - Christian Beliefs','Aaron Wong','Amos','Dylan','Anita','\"Jamie/Venus\"'), ('2010-02-27','Talk: Israel','Jamie','Jessica','Michelle','Nathan','Angie'), ('2010-03-06','Bible Study - Christian Beliefs','Vanessa ','Jeffrey','Matthew','Jensen','Sam'), ('2010-03-13','Asian - Quiz (Happy CNY!)','Jenny','Aaron W','Dylan','Kelvin','Jessica'), ('2010-03-20','Day Camp with EMP','-','-','-','-','-'), ('2010-03-27','Bible Study - Christian Beliefs','Jeffrey','Venus','Sally','John','Anita'), ('2010-04-03','Easterfest - Toowoomba','Amos/Jeffrey','-','-','-','-'), ('2010-04-10','Sisters\' Night','Kevin Yau','-','-','-','-'), ('2010-04-17','Bible Study - Christian Beliefs','Sally','Matthew','Jeffrey','Joey','Dylan'), ('2010-04-24','DVD Night','Michelle','Amos','Dylan','Angie','Jenny'), ('2010-05-01','Amazing race','Matthew','-','-','-','-'), ('2010-05-08','Parents\' Night','CMYF','-','-','-','-'), ('2010-05-15','Bible Study - Christian Beliefs','Aaron Wong','Amos ','Dylan','Joey','Jennifer'), ('2010-05-22','Birthday Night','Amos','Venus','Michelle','Jenny','Everyone'), ('2010-05-29','Bible Study - Christian Beliefs','Matthew','Vanessa','Jeffrey','Nathan','Michelle'), ('2010-06-05','Bible Study - Christian Beliefs','Sally','Aaron W','Dylan','Sam','Vanessa'), ('2010-06-12','Talk: Different Religions','Jamie','Matthew','Jeffrey','Anita','Jennifer'), ('2010-06-19','Games Night','Cindy','-','-','-','-'), ('2010-06-26','Kayaking ','Kelvin Lam','-','-','-','-'); /*!40000 ALTER TABLE `emyf` ENABLE KEYS */;
And do that afew times?
Next, comes the PHP
<?php $date=date('y-m-d'); $conn = mysql_connect('localhost', 'joeylau_*****', '************'); if (!$conn) {echo "Unable to connect to DB: " . mysql_error();exit;} if (!mysql_select_db("joeylau_admin")) {echo "Unable to select joey: " . mysql_error();exit;} $sql = "SELECT * FROM emyf WHERE `Date`>='$date' LIMIT 1;"; $result = mysql_query($sql); if (!$result) {echo "Could not successfully run query ($sql) from DB: " . mysql_error();exit;} if (mysql_num_rows($result) == 0) {echo "No rows found, nothing to print so am exiting";exit;} while ($row = mysql_fetch_assoc($result)) { $mysqldate = $row["Date"]; $phpdate = strtotime( $mysqldate ); $mysqldate = date('d M', $phpdate); echo '<table border="1">'; echo '<tr><th>Date:</th><td>' . $mysqldate . '</td></tr>'; echo '<tr><th>Special:</th><td>' . $row["Special"] . '</td></tr>'; echo '<tr><th>PIC:</th><td>' . $row["PIC"] . '</td></tr>'; echo '<tr><th>P&W:</th><td>' . $row["P&W"] . '</td></tr>'; echo '<tr><th>Musician:</th><td>' . $row["Musician"] . '</td></tr>'; echo '<tr><th>Tech:</th><td>' . $row["Tech"] . '</td></tr>'; echo '<tr><th>Food/Cleaning:</th><td>' . $row["Food/Cleaning"] . '</td></tr>'; echo '</table><br />'; } mysql_free_result($result); ?>
Then, the last bit, add it to the site 😀