$query = "SELECT b.eventID as eventID, tagline, blurb, filepath, filename FROM eventbillboard AS b, events AS e WHERE e.eventID = b.eventID AND b.active = 1 AND TO_DAYS(NOW()) - TO_DAYS(start) < 1 ORDER BY start ASC LIMIT 1"; $result = mysql_query($query) or die("Query failed: ($query) with error: " . mysql_error()); $num_results = mysql_num_rows($result); $row = mysql_fetch_array($result); if ($num_results > 0) { sto(175); ?>
if (file_exists($row["filepath"] . $row["filename"]) && $row["filename"] != "") { ?>“> thumbnailer($row["filepath"], $row["filename"], "", 75, "left", $row["tagline"]); ?> } print(stripslashes($row["blurb"])); ?> [“>Read More]
}
?>
EVENTS SPOTLIGHT:
$query = "SELECT eventID, DATE_FORMAT(start, "%M %e") AS startdate, DATE_FORMAT(end, "%M %e") AS enddate, title FROM events WHERE TO_DAYS(end) - TO_DAYS(NOW()) > -1 ORDER BY profiled DESC, start ASC LIMIT 8″;
$result = mysql_query($query) or die(“Query failed: ($query) with error: ” . mysql_error());
$num_results = mysql_num_rows($result);
for ($i = 0; $i < $num_results; $i++) {
$row = mysql_fetch_array($result);
?>“>
print($row["startdate"]); ?>
if ($row["startdate"] != $row["enddate"]) {
print(" - " . $row["enddate"]);
}
?>
“> print(stripslashes($row["title"])); ?>
}
?>[View All Events]
RESOURCES:
$query = "SELECT newsID, title FROM news WHERE brief = "" AND ((TO_DAYS(expirydate) - TO_DAYS(NOW())) > 0 OR expirydate = “0000-00-00”) AND ((exclusive = “N”) OR (exclusive = “Y” AND categoryID = 1)) ORDER BY priority ASC, stamp DESC LIMIT 8″;
$result = mysql_query($query) or die(“Query failed: ($query) with error: ” . mysql_error());
$num_results = mysql_num_rows($result);
for ($i = 0; $i < $num_results; $i++) {
$row = mysql_fetch_array($result);
?>
“>
“> print(StripSlashes($row["title"])); ?>
}
?>
![]()
![]()
$query = "SELECT newsID, title, brief FROM news WHERE brief <> “” AND ((TO_DAYS(expirydate) – TO_DAYS(NOW())) > 0 OR expirydate = “0000-00-00”) AND ((exclusive = “N”) OR (exclusive = “Y” AND categoryID = 1)) ORDER BY priority ASC, stamp DESC LIMIT 10″;
$result = mysql_query($query) or die(“Query failed: ($query) with error: ” . mysql_error());
$num_results = mysql_num_rows($result);
for ($i = 0; $i < $num_results; $i++) {
$row = mysql_fetch_array($result);
?>
“>
print(StripSlashes($row["title"])); ?> – print(StripSlashes($row["brief"])); ?> [“>Read More]
}
?>
horticultural consumer at www.landscapeontario.com
solidtable("open","175",$_SERVER["HTTP_USER_AGENT"]); ?>
Membership
Find out how your business will benefit.
Advancing the horticulture industry.
solidtable("close","",$_SERVER["HTTP_USER_AGENT"]); ?>
![]()
solidtable("open","175",$_SERVER["HTTP_USER_AGENT"]); ?>


GreenTrade Expo –
February 16, 2005
Canada Blooms –
March 9-13, 2005
Garden Expo –
October 18-19, 2005
Congress 2005 –
January 11-13, 2005
solidtable("close","",$_SERVER["HTTP_USER_AGENT"]); ?>
![]()
solidtable("open","175",$_SERVER["HTTP_USER_AGENT"]); ?>
Source Book
Landscape Ontario’s leading industry publications.
solidtable("close","",$_SERVER["HTTP_USER_AGENT"]); ?>
![]()
solidtable("open","175",$_SERVER["HTTP_USER_AGENT"]); ?>

Make the connection!
solidtable("close","",$_SERVER["HTTP_USER_AGENT"]); ?>
![]()
solidtable("open","175",$_SERVER["HTTP_USER_AGENT"]); ?>

Addressing sector-specific issues.
solidtable("close","",$_SERVER["HTTP_USER_AGENT"]); ?>
![]()
solidtable("open","175",$_SERVER["HTTP_USER_AGENT"]); ?>

Recognizing industry excellence.
solidtable("close","",$_SERVER["HTTP_USER_AGENT"]); ?>
![]()
sto(175); ?>

stc(); ?>
![]()