Manufacturers & Distributors: $ucltr
Home /
Suppliers /
$ucltr
EOT;
include("alphabet.php");
$result = mysql_query("select distinct name from listings where name like '$ltr%' order by name", $db);
while($myrow = mysql_fetch_array($result)){
$query = mysql_query("select * from listings where name='$myrow[name]' limit 1", $db);
$row = mysql_fetch_array($query);
echo "$row[name]
$row[desc2]
\n";
}
}
elseif($action == 'details'){
$result = mysql_query("select * from listings where id='$_REQUEST[id]'", $db);
$myrow = mysql_fetch_array($result);
$ucltr = ucwords("$_REQUEST[ltr]");
$myterm = str_replace('inc.', '', $myrow[name]);
$myterm = str_replace('Inc.', ' ', $myterm);
$myterm = str_replace('inc ', ' ', $myterm);
$myterm = str_replace('Inc ', ' ', $myterm);
$myterm = str_replace(',', ' ', $myterm);
$myterm = str_replace('&', ' ', $myterm);
$myterm = str_replace(' ', '', $myterm);
$myterm = str_replace(' ', '', $myterm);
$myterm = trim(rtrim($myterm));
$myterm = str_replace(' ', '+', $myterm);
echo <<Manufacturers & Distributors: $ucltr
Home /
Suppliers /
$ucltr /
$myrow[name]
$myrow[name]
$myrow[street]
$myrow[city], $myrow[state] $myrow[zip]
Phone: $myrow[phone]
Fax: $myrow[fax]
| Employees: | $myrow[employees] |
| Business Types: | $myrow[types] |
| Website: | $myrow[website] |
$myrow[desc2]
More Information Available:
EOT;
// show news releases
CarpConf('shownoitems',1);
CarpConf('noitems','');
CarpConf('encodingin','UTF-8');
CarpConf('encodingout','UTF-8');
CarpConf('fixentities',1);
CarpConf('cborder','');
CarpConf('aidesc','
');
CarpConf('cacheinterval',110);
CarpConf('maxitems',3);
CarpConf('poweredby','');
CarpConf('linktarget', 1);
CarpCacheShow("http://news.google.com/news?q=$myterm&output=rss");
// show web results
CarpConf('iorder','link,desc');
CarpConf('bi','');
CarpConf('aidesc','
');
CarpConf('cacheinterval',160);
CarpConf('maxitems',3);
CarpConf('linktarget',1);
CarpConf('poweredby','');
CarpShow("http://beta.search.msn.com/results.aspx?q=$myterm&format=rss");
}
else {
echo <<Manufacturers & Distributors
Home /
Suppliers
EOT;
include("alphabet.php");
$result = mysql_query("select distinct name from listings order by name limit 8", $db);
while($myrow = mysql_fetch_array($result)){
$query = mysql_query("select * from listings where name='$myrow[name]' limit 1", $db);
$row = mysql_fetch_array($query);
echo "$row[name]
$row[desc2]
\n";
}
}
echo "
\n";
include("includes/footer.php");
?>