* @version $Revision: 1.7 $ $Date: 2004/10/21 12:21:46 $
* @package Mobot Backend
*
*/
include_once('config.php');
require_once('int_libs/mobot.php');
$manuf_id = $_REQUEST["manuf_id"];
if(!is_numeric($manuf_id)) {
$name = urldecode($_REQUEST["manuf_id"]);
$manuf_id = mobot_get_manuf_id_from_name($name);
}
$header = array('Branch Office', 'Address', 'Country', 'Phone/Fax', 'Contact Info');
$t = new table();
$t->set_table_class('tablemobot');
//print_r($head_array);
$t->set_thead($header);
$t->set_tfoot('Powered by MOBOT', 5);
$db = new db_mysql();
$db->select_db('mobot');
$sql = "SELECT mm.name, mm.address, mm.country, mm.phone,
mm.fax, mm.url, mm.newsgrp, mm.email, mm.ftp, mm1.name AS 'mname'
FROM manuf_branch AS mm
LEFT JOIN manuf AS mm1 ON mm.manuf_id = mm1.manuf_id
WHERE mm.manuf_id = $manuf_id";
//echo $sql;
$db->set_sql($sql);
$db->query();
if ($row = $db->fetch_array()) {
$mname = $row["mname"];
do {
$body_array[] = $row["name"];
$body_array[] = $row["address"];
$body_array[] = $row["country"];
$phone_fax = 'Ph: ' . $row["phone"] . '
Fx: ' . $row["fax"];
$body_array[] = $phone_fax;
if($row["url"]) {
$downloads = '♠ Web Site
';
}
if($row["newsgrp"]) {
$downloads .= '♣ Newsgroup
';
}
if($row["email"]) {
$downloads .= '♥ Email
';
}
if($row["ftp"]) {
$downloads .= '♦ FTP
';
}
$body_array[] = $downloads;
$t->set_tbody($body_array);
unset($body_array);
} while ($row = $db->fetch_array());
}
$db->close();
$template = new template();
$template->title = "MOBOT: Manufacturer Spec Sheet: $name";
$template->section = 'mobot';
$template->description = 'Largest Motherboard database on the web.';
$template->open_page();
?>