<?php
// This is the function page for the contact us section.
error_reporting("E_ALL && E_NOTICE && E_WARNING");
// Connect to database server
$mysq_connect = @mysql_connect('192.168.101.42','lmackay','penny123');
mysql_select_db('starnewsgroup',$mysql_connect);

// Build a dropdown starting at <select> and ending at </select> for offices or publications.
function dropdown($list = "office"){
    switch($list){
        case "office" : $SQL_SELECT = "SELECT name AS name, id_office AS id FROM `starnewsgroup`.`sngl_office` ORDER BY name;"; break;
        case "publication" : $SQL_SELECT = "SELECT newspaper AS name, newspaperid AS id FROM `starnewsgroup`.`sngl_newspapers` WHERE contact_us = 1 ORDER BY name;"; break;
    }

    // Execute the above SQL statement
    $sql_dropdown = mysql_query($SQL_SELECT) or die(mysql_error());
    $dropdown_html = "$list";
    $dropdown_html .= "<select name=\"$list\" id=\"$list\" onchange=\"change(this.value,'$list')\">";
    $dropdown_html .= "<option value=\"\">Select</option>";
    while($row = mysql_fetch_array($sql_dropdown)) {
        $dropdown_html .= "<option value=\"$row[id]\">$row[name]</option>";
    }
    $dropdown_html .= "</select>";
    return $dropdown_html;
}

function display_home(){
    $html['data'] .= dropdown('office');
    $html['data'] .= dropdown('publication');
    return $html['data'];
}

function display($table,$id){
    switch($table){
        case "publication" : $SQL_SELECT = "SELECT * FROM `starnewsgroup`.`all_details_publication` WHERE newspaperid = $id;";break;
        case "office"   :   $SQL_SELECT = "SELECT * FROM `starnewsgroup`.`all_details_office` WHERE office_id = $id;";break;
    }

    // Execute the above SQL statement
    $sql_contact = mysql_query($SQL_SELECT) or die(mysql_error());
    $row = mysql_fetch_array($sql_contact);

    $html['data'] = "<table border=1>";
    $html['data'] .= isset($row['0']) ? "<tr><td colspan=\"2\"><b>$row[0]</b></td></tr>": false;
    $html['data'] .= isset($row['phone_reception']) ? "<tr><td>Reception $row[phone_reception]</td></tr>": false;
    $html['data'] .= isset($row['phone_local']) ? "<tr><td>Local $row[phone_local]</td></tr>": false ;
    $html['data'] .= isset($row['fax']) ? "<tr><td>Fax $row[fax]</td></tr>": false ;
    $html['data'] .= "<tr><td>&nbsp</td></tr>";
    $html['data'] .= "<tr><td colspan=\"2\"><b>Address</b></td></tr>";

        $address_1_temp = isset($row['address_1']) ? $row['address_1']: false;
    $html['data'] .= "<tr><td>$address_1_temp $row[address_2]</td></tr>";

    $html['data'] .= "<tr><td>$row[suburb], $row[state]</td></tr>";
    $html['data'] .= "<tr><td>Australia, $row[post_code]</td></tr>";
    $html['data'] .= "<tr><td>&nbsp</td></tr>";

    $html['data'] .= "<tr><td><b>Postal Address</b></td></tr>";
    $postal_address_1_temp = isset($row['postal_address_1']) ? $row['postal_address_1']: false;
    $postal_address_2_temp = isset($row['postal_address_2']) ? $row['postal_address_2']: false;
    $html['data'] .= "<tr><td>$postal_address_1_temp $postal_address_2_temp</td></tr>";
    $html['data'] .= "<tr><td>$row[postal_suburb] $row[postal_state]</td></tr>";

    $html['data'] .= isset($row['postal_post_code']) ? "<tr><td>Australia $row[postal_post_code]</td></tr>": false;
    $html['data'] .= "<tr><td><b>Email Enquiries</b></td></tr>";
    $html['data'] .= isset($row['email_general']) ? "<tr><td>General $row[email_general]</td></tr>": false;
    $html['data'] .= isset($row['email_advertising']) ? "<tr><td>Advertising $row[email_advertising]</td></tr>": false;
    $html['data'] .= isset($row['email_editorial']) ? "<tr><td>Editorial $row[email_editorial]</td></tr>": false;
    $html['data'] .= isset($row['email_cs']) ? "<tr><td>Creative Services $row[email_cs]</td></tr>": false;
    $html['data'] .= isset($row['email_realestate']) ? "<tr><td>Real Estate $row[email_realestate]</td></tr>": false;

    return $html['data'];
}
?>