Retail Locations
-
children() as $country){
$i=0;
foreach($country->children() as $region){
if ($i==0) {
$var1 = explode(“_”, $region[0]);
$a_country[$var1[0]] = $var1[1];
$i=1;
}
else {
$var2 = explode(“_”, $region[0]);
$code1 = $var1[0].”_”.$var2[0];
$a_region[$code1] = $var2[1];
}
}
}
// Connect and link database. Will need to change host , db and password
$link = @mysql_connect(‘eflive.db.6803543.hostedresource.com’, ‘eflive’, ‘E534147db’);
if (!$link) {
die(‘Could not connect: ‘ . mysql_error());
}
/* Select DB */
$db_selected = @mysql_select_db(‘eflive’,$link);
if (!$db_selected) {
die (‘Can not use eflive: ‘ . mysql_error());
}
$SQL = “SELECT * FROM `x-retail` ORDER BY clocation,ccity,cname”;
$result = mysql_query($SQL,$link);
if (!$result) {
echo “
‘.$row[cname].’
‘; if (trim($row[cdetails]) != NULL) echo trim($row[cdetails]).’
‘; if ($row[ctype] == 2) echo ‘(A Friend of EarthFlour.com)
(Employee & Family Health & Wellness Plan)
‘; if ($row[ctype] == 1) echo ‘STOCKING Authorized Retail Store (ARS)
‘; if (trim($row[caddr1]) != NULL) echo trim($row[caddr1]).’
‘; if (trim($row[caddr2]) != NULL) echo trim($row[caddr2]).’
‘; if (trim($row[caddr3]) != NULL) echo trim($row[caddr3]).’
‘; if (trim($row[caddr4]) != NULL) echo trim($row[caddr44]).’
‘; echo trim($row[ccity]); echo ‘, ‘.$a_region[$row[clocation]]; echo ‘
‘.trim($row[cpcode]); echo ‘ ‘.$a_country[$var1[0]]; echo ‘
‘.trim($row[cphone]); echo ‘
‘; if (trim($row[cweb]) != NULL) echo ‘‘.trim($row[cweb]).’‘; if (trim ($row[cweb2]) != NULL) echo ‘
‘.trim ($row[cweb2]).’‘; if ($row[cstore] != NULL) { echo ‘
‘;
echo ‘ SM‘;
}
if ($row[custserve] != NULL) echo ‘ VSFServiceDesk‘;
echo ‘ ‘;
}
?>
Error: “.$call.” – “.mysql_error().”
“; die(”); } $keepregion = NULL; // set to test for state/province chnage while($row = mysql_fetch_array($result)) { $var1 = explode(“_”, $row[clocation]); if ($keepregion != $row[clocation]) { echo ‘‘.$a_region[$row[clocation]].” “.$a_country[$var1[0]].’
‘; $keepregion = $row[clocation]; } echo ‘Retailers
Are your customers …
- Health conscious?
- Environmentally aware?
- Looking for solutions to health issues?
- Trying to stay healthy in a polluted world?
Become an Earth Flour Authorized Retailer!
Call (407) 495-5835for more information
Take advantage of this ground-floor opportunity to provide your customers with the first food grade, pure, Diatomaceous Earth proven to absorb environ-mental toxins and other poisons in the human body.
