 |
 |
To find out how to have your
business featured above,
click here! |
 |
Could not connect to the database.";
exit;
}
//select db to work with
mysql_select_db($dbName);
$query = "select id, address, city, postal_code, service, business_name, telephone, webpage from bruce ORDER BY id desc";
$searchResult = mysql_query($query) or die(mysql_error());
$num_results = mysql_num_rows($searchResult);
$counter = $num_results - 2;
if ($num_results !=0)
{
for ($i = $counter; $i < $num_results; $i++)
{
$row = mysql_fetch_array($searchResult) or die(mysql_error());
$id = htmlspecialchars(stripslashes($row['id']));
$service = htmlspecialchars(stripslashes($row['service']));
$business_name = htmlspecialchars(stripslashes($row['business_name']));
$address = htmlspecialchars(stripslashes($row['address']));
$city = htmlspecialchars(stripslashes($row['city']));
$webpage = htmlspecialchars(stripslashes($row['webpage']));
echo "";
echo "";
echo $business_name;
echo "";
echo "
";
echo $address;
echo "
";
echo $city;
echo "
";
if ($webpage == "http://")
{
$webpage = "N/A";
echo $webpage;
}
else
{
echo "";
echo $webpage;
echo "";
}
echo "
";
echo "More Details..";
echo "
";
}
}
?> |
 |
Could not connect to the database.";
exit;
}
//select db to work with
mysql_select_db($dbName);
$query = "select * from events ORDER BY eventmonth";
$searchResult = mysql_query($query) or die(mysql_error());
$num_results = mysql_num_rows($searchResult);
if ($num_results !=0)
{
for ($i = 0; $i < $num_results; $i++)
{
$row = mysql_fetch_array($searchResult) or die(mysql_error());
$eventid = htmlspecialchars(stripslashes($row['eventid']));
$eventname = htmlspecialchars(stripslashes($row['eventname']));
$eventday = htmlspecialchars(stripslashes($row['eventday']));
$eventmonth = htmlspecialchars(stripslashes($row['eventmonth']));
$eventyear = htmlspecialchars(stripslashes($row['eventyear']));
$eventlocation = htmlspecialchars(stripslashes($row['eventlocation']));
$eventtime = htmlspecialchars(stripslashes($row['eventtime']));
//Catch for expired dates
//Checks if month is this month or prior
if ($eventmonth <= $time2)
{
//Checks if it is prior to today's date.
if ($eventday < $time1)
{
}
else
{
echo "";
echo "";
echo $eventname;
echo "";
echo "
";
echo $eventday;
echo "/";
echo $eventmonth;
echo "/";
echo $eventyear;
echo "
";
echo $eventlocation;
echo "
";
echo "More Details..";
echo "
";
}
}
}
echo "
• To add your event, click here.";
}
else
{
echo "No Events Scheduled
• To add your event, click here.";
}
?> |
 |
| • Kincardine News |
| • Goderich Signal Star |
| • Kincardine Independent |
| • Walkerton Herald Times |
| • Owen Sound Sun Times |
|
|
|