Miscellany

<?php
include 'includes/config.inc.php';
?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>The Computer Doctor Database</title>
<link href="computerdoctor2.css" rel="stylesheet" type="text/css" />
</head>

<body>
<div id="container">
	<div id="topbanner">
    	<input type="text" name="search" id="search">
        <input type="button" name="gosearch" id="gosearch" value="Go" />
    </div>
    <div id="loginstatus">
    	    <a id="login" href=""></a>
            <a id="logout" href=""></a>
    </div>
    <div id="bodysection">
    	<div id="nav">
        	<a id="link" href=""></a>
            <a id="link2" href=""></a>
            <a id="link3" href=""></a>
            <a id="link4" href=""></a>
        </div>
        <div id="content">
        	<div id="table">
            <table>
        		<caption>Job Status</caption>
                <tr>
                	<th>Customer</th>
                    <th>Service Tag</th>
                    <th>Problem</th>
                    <th>Time</th>
                    <th>Status</th>
                    <th>Priority</th>
                    <th>Edit</th>
                    <th>Delete</th>
                </tr>
                <?php
				$get_work_info = "SELECT customer_name, service_tag, problem, time, status, 			priority FROM jobs";
				$query = mysql_query($get_work_info);
				
				if (mysql_num_rows($query) > 0) {
					while($row = mysql_fetch_array($query, MYSQL_ASSOC)) {
						echo '<tr><td>' . $row['customer_name'] . '</td>';
						echo '<td>' . $row['service_tag'] . '</td>';
						echo '<td>' . $row['problem'] . '</td>';
						echo '<td>' . $row['time'] . '</td>';
						echo '<td>' . $row['status'] . '</td>';
						echo '<td>' . $row['priority'] . '</td>';
						echo '<td><a href="editjob.php">Edit</a>' . '</td>';
						echo '<td><a href="deletejob.php">Delete</a>' . '</td>';
					}
				}
				?>
        	</table>
            <a class="createjob" href="createjob.php">Create Job</a>
           	</div>
        </div>
    </div>
</div>
</body>
</html>

body {
background-image:url(images/background_gradient.jpg);
background-position:top left;
background-repeat:repeat-x repeat-y;
}

#container {
margin:0 auto;
width:902px;
}

#topbanner {
background:url(images/top_banner.jpg) top left no-repeat;
width:902px;
height:175px;
}

#loginstatus {
background:url(images/login_status.jpg) top left no-repeat;
width:902px;
height:57px;
}

#nav {
background:url(images/nav_background.jpg) top left no-repeat;
width:268px;
height:447px;
float:left;
}

#content {
background-color:#FFFFFF;
width:634px;
height:447px;
float:left;
}

#link {
background:url(images/workstatus_link.gif) top right no-repeat;
width:268px;
height:24px;
margin-top:30px;
display:block;
}

#link:hover {
background:url(images/workstatus_link_hover.gif) top right no-repeat;
width:268px;
height:24px;
margin-top:30px;
display:block;
}

#link2 {
background:url(images/customers_link.gif) top right no-repeat;
width:268px;
height:24px;
margin-top:30px;
display:block;
}

#link2:hover {
background:url(images/customers_link_hover.gif) top right no-repeat;
width:268px;
height:24px;
margin-top:30px;
display:block;
}

#link3 {
background:url(images/units_link.gif) top right no-repeat;
width:268px;
height:24px;
margin-top:30px;
display:block;
}

#link3:hover {
background:url(images/units_link_hover.gif) top right no-repeat;
width:268px;
height:24px;
margin-top:30px;
display:block;
}

#link4 {
background:url(images/admin_link.gif) top right no-repeat;
width:268px;
height:24px;
margin-top:30px;
display:block;
}

#link4:hover {
background:url(images/admin_link_hover.gif) top right no-repeat;
width:268px;
height:24px;
margin-top:30px;
display:block;
}

#login {
background:url(images/login_link.gif) top right no-repeat;
width:54px;
height:57px;
display:block;
float:left;
margin-left:760px;
}

#logout {
background:url(images/logout_link.gif) top right no-repeat;
width:54px;
height:57px;
display:block;
float:left;
margin-left:15px;
}

#login:hover {
background:url(images/login_link_hover.gif) top right no-repeat;
width:54px;
height:57px;
display:block;
float:left;
margin-left:760px;
}

#logout:hover {
background:url(images/logout_link_hover.gif) top right no-repeat;
width:54px;
height:57px;
display:block;
float:left;
margin-left:15px;
}

#search {
margin-left:695px;
margin-top:5px;
width:110px;
}

#gosearch {
width:40px;
}

#table {
width:634px;
}

table {
border:1px solid #000;
border-collapse:collapse;
background-color:#469dee;
margin:0 auto;
*margin-top:20px;
}

caption {
font:bold 18px Arial, Helvetica, sans-serif;
letter-spacing:4px;
margin:20px auto 0;
color:#666666;
}

th {
padding:2px;
margin:0;
font:bold 18px Verdana, Arial, Helvetica, sans-serif;
letter-spacing:-1px;
color:#fff;
border:1px solid #000;
width:50px;
}

td {
padding:5px;
margin:0;
font:12px Verdana, Arial, Helvetica, sans-serif;
letter-spacing:-1px;
color:#fff;
background-color:#8b8c8d;
border:1px solid #000;
}

#table a:link, a:visited {
color:#666666;
text-decoration:none;
}

#table a:hover {
color:#666666;
text-decoration:underline;
}

.createjob {
font:18px Verdana, Arial, Helvetica, sans-serif;
margin-left:515px;
}