\n"; echo "\n",$myrow["event"]); $start_date = $myrow[date]; $string = "$start_date"; $stringArray = explode("-", $string); $date = mktime(0,0,0,$stringArray[1],$stringArray[2],$stringArray[0]); $StartDate = date("d/m/Y", $date); $email_subject1 = $myrow[venue]; $email_subject2 = $myrow[event]; $email_subject = "Enquiry for $email_subject2 at $email_subject1 on $StartDate"; printf("\n",$myrow["time"],$myrow["duration"]); printf("\n",$myrow["venue"]); printf("\n",$myrow["content"]); printf("

$venue1"; } // create SQL statement $sql = "SELECT DISTINCT event FROM whats_on ORDER BY event ASC"; // execute SQL query and get result $sql_result = mysql_query($sql,$connection) or die("Couldn't execute query."); // put data into drop-down list box while ($row = mysql_fetch_array($sql_result)) { $event1 = $row["event"]; $option_event .= "$event1"; } ?> = '$today' OR end_date >= '$today ' order by date LIMIT 15",$db); if ($myrow = mysql_fetch_array($result)) { $num_rows = mysql_num_rows($result); echo "\n"; print "Displayed is the next $num_rows events provided by Insight Solutions starting on or after $fulltoday"; echo " \n"; ?> You can Search and display for events or Seminars using any of the following options: Show Events or Seminars for Select Month January February March April May June July August September October November December Year200620072008200920102011201220132014201520162017201820192020  Show Events or Seminars at Select Venue  Show Events or Seminars Covering Select Subject  \n"; echo "

\n"; printf("%s

on $StartDate at %s for %s

%s

%s

Cost: %s Click here for further info

\n",$myrow["cost"]); printf("

---

\n",$myrow["id"]); } while ($myrow = mysql_fetch_array($result)); } else { echo ""; echo "We Found No Events from $fulltoday"; echo "

Please click back on your browser and try again!

"; } mysql_close (); ?>