|
|
Execute($query);
if ($rs AND !$rs->EOF) {
while (!$rs->EOF) {
$countryOptions[$rs->fields['id']] = $rs->fields['name'];
$rs->MoveNext();
}
}
?>
Retail Supply Service
All distributors are ReelBox experts and are happy to give a demonstration upon request, prior to purchase.
|
| |
|
Please contact the above supplier regarding enquiries in (NAME OF RELEVANT COUNTRY)
|
| |
Execute($query);
echo "";
if ($rs AND !$rs->EOF) {
if ($first) {
?>
Reel-Multimedia - Supply Chain
fields['country']?> - Postleitzahl:
Postleitzahl *
Postleitzahl
EOF) {
$data = $rs->fields;
echo "".$data['company']."
";
if ($data['address1']) echo "".$data['address1']."
";
if ($data['address2']) echo "".$data['address2']."
";
echo "".$data['postcode']." ".$data['city']."
";
if ($data['phone1']) echo "Tel: ".$data['phone1']."
";
if ($data['phone4']) echo "Fax: ".$data['phone4']."
";
if ($data['website']) echo "Web: ".$data['website']."
";
echo "
";
if ($shown) {
$shown .= ','.$rs->fields['id'];
} else {
$shown = $rs->fields['id'];
}
$count++;
$rs->MoveNext();
}
echo "
";
}
$postcode = substr($postcode,0,-1);
}
if ($count==0) {
$query = "SELECT contacts.id,company,address1,postcode,city,country.name AS country,phone1,phone4,website ";
$query .= "FROM contacts, rl_contact_category AS cat1, rl_contact_category AS cat2, opt_country AS country WHERE ";
$query .= "cat1.contactId=contacts.id AND cat1.categoryId=7 AND ";
$query .= "cat2.contactId=contacts.id AND cat2.categoryId=9 AND ";
$query .= "country.id = contacts.country AND country.id = $country ";
$query .= "ORDER BY postcode";
$rs = $conn->Execute($query);
echo "";
if ($rs AND !$rs->EOF) {
if ($first) {
?>
Reel-Multimedia - Supply Chain
fields['country']?>
EOF) {
$data = $rs->fields;
echo "".$data['company']."
";
if ($data['address1']) echo "".$data['address1']."
";
if ($data['address2']) echo "".$data['address2']."
";
echo "".$data['postcode']." ".$data['city']."
";
if ($data['phone1']) echo "Tel: ".$data['phone1']."
";
if ($data['phone4']) echo "Fax: ".$data['phone4']."
";
if ($data['website']) echo "Web: ".$data['website']."
";
echo "
";
if ($shown) {
$shown .= ','.$rs->fields['id'];
} else {
$shown = $rs->fields['id'];
}
$count++;
$rs->MoveNext();
}
} else {
?>
";
}
?>
|
|