$leadstoryquery = "SELECT * FROM mainnews ORDER BY timestamp DESC LIMIT 0, 1";
if ($leadstoryresult = $con->query($leadstoryquery)) {
/* fetch associative array */
while ($row = $leadstoryresult->fetch_assoc()) {
$URL = $row["URL"];
$leadcontent = $row["content"];
$leadimage = $row["pic"];
$leadid = $row["id"];
}
/* free result set */
$leadstoryresult->free();
}
else {
echo "
There was an error connecting to the database. Please retun to the previous page and apologies for the inconvenience.
Latest Gardening News
include ('imagecarousel.php')?>
< href='gardeningnews'>Top Stories
$olderstoryquery = "SELECT * FROM mainnews ORDER BY timestamp DESC LIMIT 0, 4";
if ($olderstoryresult = $con->query($olderstoryquery)) {
/* fetch associative array */
while ($row = $olderstoryresult->fetch_assoc()) {
echo "
";
echo "
";
echo "

";
echo "
";
echo "
";
echo "
".$row[title]."";
$addedy = substr($row["timestamp"],0,4);
$addedm = substr($row["timestamp"],5,2);
$addedd = substr($row["timestamp"],8,2);
$newsDate = "
".$addedd."/".$addedm."/".$addedy."
";
echo $newsDate;
echo "
";
echo "
";
}
/* free result set */
$olderstoryresult->free();
}
else {
echo "
There was an error connecting to the database. Please retun to the previous page and apologies for the inconvenience.
";
}
?>
Latest Gardening Competitions
$month = date("F");
$morecompsquery = "SELECT * FROM competitions ORDER by timestamp DESC LIMIT 0, 5";
if ($morecompsresult = $con->query($morecompsquery)) {
echo "
";
/* fetch associative array */
while ($row = $morecompsresult->fetch_assoc())
{
echo "";
$compTitle = $row["title"];
$compLink =$row["id"];
$compSupplier = $row["supplier"];
$addedy = substr($row["added"],0,4);
$addedm = substr($row["added"],5,2);
$addedd = substr($row["added"],8,2);
$compDate = $addedd."/".$addedm."/".$addedy;
echo "".$compTitle." | ";
echo "".$compDate." | ";
echo "
";
}
echo "
";
/* free result set */
$morecompsresult->free();
}
?>
More Chances to Win!
Gardening Ideas
$ideaquery = "SELECT * FROM gardenideas ORDER BY timestamp DESC LIMIT 0, 4";
if ($idearesult = $con->query($ideaquery)) {
/* fetch associative array */
while ($row = $idearesult->fetch_assoc()) {
echo "
";
echo "
";
echo "

";
echo "
";
echo "
";
echo "
";
}
/* free result set */
$idearesult->free();
}
else {
echo "
There was an error connecting to the database. Please retun to the previous page and apologies for the inconvenience.
";
}
?>
Gardening Offers
$moregardeningoffersquery = "SELECT * FROM offers ORDER BY added DESC LIMIT 0,8";
if ($moregardeningoffersresult = $con->query($moregardeningoffersquery)) {
/* fetch associative array */
while ($row = $moregardeningoffersresult->fetch_assoc()) {
echo "
";
echo "
";
echo "
![".$row["title"]."](".$row["image"].")
";
echo "
";
echo "
";
echo "
";
}
/* free result set */
$moregardeningoffersresult->free();
}
else
{
echo "
No records found
";
}
?>
Ask a gardening question: