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


< href='gardeningnews'>Top Stories


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


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 ""; echo ""; echo ""; } echo "
".$compTitle."

".$compDate."

"; /* free result set */ $morecompsresult->free(); } ?>

More Chances to Win!


Gardening Ideas


query($ideaquery)) { /* fetch associative array */ while ($row = $idearesult->fetch_assoc()) { echo "
"; echo "
"; echo "/"; echo "
"; echo "
"; echo "

".$row[title]."

"; 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


query($moregardeningoffersquery)) { /* fetch associative array */ while ($row = $moregardeningoffersresult->fetch_assoc()) { echo "
"; echo "
"; echo "".$row["title"].""; echo "
"; echo "
"; echo "

".$row["title"]."

"; echo "
"; echo "
"; } /* free result set */ $moregardeningoffersresult->free(); } else { echo "

No records found

"; } ?>

Ask a gardening question: