ofevent 1 title

short desc 1

Learn More
*/ // $event_datestamp = mktime(0, 0, 0, $month, $day, $year); $current_datestamp = time(); /* spare variable list $name $day $month $year $time $cost $venue $short_desc $long_desc */ if (!$connection = mysql_connect(null, "our_lady", "rossman")) // opens connection to db server for user "db_admin" { $error_message = "Sorry, the database server cannot be contacted at this time, please try again later."; include "db_error_script.php"; exit(); } if (!mysql_select_db("olol", $connection)) // selects the ipc database { $error_message = "Sorry, the server cannot connect to the Our Lady of Lourdes database at this time, please try again later."; include "db_error_script.php"; exit(); } ////////////// // $sql = "SELECT * FROM item_table WHERE on_view ='1' AND expiry_date <= $current_datestamp ORDER BY expiry_date ASC"; $sql = "SELECT * FROM item_table WHERE on_view ='1' AND expiry_date >= $current_datestamp ORDER BY expiry_date ASC"; // if (!$result = mysql_query("SELECT * FROM item_table WHERE on_view ='1' AND expiry_date <= $current_datestamp ORDER BY expiry_date ASC")); if (!$result = mysql_query($sql)) { $notes = "error couldn't select information from the table item_table in the olol database"; } $num_rows = mysql_num_rows($result); $notes .= "
\$num_rows = $num_rows"; if ($num_rows == 0) { // the event calendar is empty, there are no events to display // therefore no html is added to the output. // there is no need for an explanation of this - or is there??????? maybe a blank event with no further info } $i = 0; while ((list($unused_auto_increment_index, $reference, $on_view, $item_name, $unused_item_type, $event_datestamp, $short_desc, $long_desc, $venue, $cost, $contact_info, $priority, $image_location, $file1_name, $file2_name, $file3_name, $time, $spare2, $spare3, $spare4, $spare5) = mysql_fetch_row($result))!= FALSE) { // in this loop, all lines from the events table $i++; $item_name = stripslashes($item_name); $time = stripslashes($time); $cost = stripslashes($cost); $venue = stripslashes($venue); $short_desc = stripslashes($short_desc); $long_desc = stripslashes($long_desc); $event_date_info = date('l jS F Y', $event_datestamp); // template of formatted accordion style output /*
event title 2

short desc 1

Learn More
*/ $accordion_output .= "
".$item_name."
"; $accordion_output .= "
"; $accordion_output .= "

".$short_desc."

"; $accordion_output .= " More information
"; } // end of while loop /////////// mysql_close($connection); echo (" Our Lady of Lourdes, Plympton - Our Lady of Lourdes, Roman Catholic Church
\"Our

Our Lady of Lourdes, Plympton: 17 Vicarage Road, Plympton, Plymouth, PL7 4JU.  Telephone: 01752 331288

Forthcoming Events
$accordion_output
Fr. Jonathan Shaddock
\"Father

Welcome to the Parish of Our Lady of Lourdes, Plympton
We are situated at the heart of Plympton; A Eucharistic Community who strive to follow Jesus: in a beautiful church which has recently been reordered and redecorated. We have a friendly community that continues to grow. We are an active church with many varied groups, social and fund-raising events. We are a caring community and we aim to provide support for those in need. St Peter’s Convent in George Lane, is part of our parish. We look forward to meeting you.
Fr Jonathan Shaddock

  • Young People
  • Find Us
  • Gift Aid
  • Our Photo Gallery
  • About the Church (History)
  • Welcome Back
  • Hospital Chaplaincy
  • Funerals
  • Diocese of Plymouth
  • St Peter's Convent
  • Links
  • Contact us now on 01752 331288 or by clicking here.

    "); ?>