View Single Post
  #7 (permalink)  
Old Mar 28th, 2008, 19:31
acrikey's Avatar
acrikey acrikey is offline
SuperMember

SuperMember
Join Date: Mar 2007
Location: UK
Posts: 305
Thanks: 0
Thanked 0 Times in 0 Posts
Re: Database and images

Code: Select all
<head>
<?
session_start();
if(!session_is_registered(myusername)){
header("location:main_login.php");
}
?>
<title>Account Details</title>
</head>


<style type="text/css">
<!--
@import url("default.css");
<!--
body {
    background-repeat: repeat-x;
}

</style>
<body>
<div id="header">
<script>
var Digital=new Date()
var month=Digital.getMonth()
if (month <= 2){    // month is between jan and march    
    document.write("<IMG SRC='http://www.lightex.co.uk/fieldworks/images/img5.jpg'>");
} else if (month <= 5){
    // month is between april and june
    document.write("<IMG SRC='http://www.lightex.co.uk/fieldworks/images/img2.jpg'>");
} else if (month <= 8){    // july and september
    document.write("<IMG SRC='http://www.lightex.co.uk/fieldworks/images/img2.jpg'>");
} else {    // otherwise its between oct and dec
    document.write("<IMG SRC='http://www.lightex.co.uk/fieldworks/images/img3.jpg'>");
}
</script>
</div>
<div id="page">
  <div id="content">
        <div id="welcome" class="post">
            <h1 class="title">Last Bill</h1>
            <IMG SRC="http://www.lightex.co.uk/fieldworks/images/420 copy.png" width="131" height="106">
        <div class="content">
              <h3 align="center"><br />
              </h3>
                <h3 align="center">&nbsp;</h3>
          </div>
    </div>
        <div id="example" class="post">
            <?php
// Connects to my Database
mysql_connect("", "", "") or die(mysql_error());
mysql_select_db("fieldworks") or die(mysql_error());
$data = mysql_query("SELECT * FROM ")
or die(mysql_error());

(Get data from db and then)
echo '<img src="'.$imageURL.'" alt ="Bill" />'; 


?>
            <br>
            
            <div class="content">
                                  
              
          </div>
        </div>
  </div>
    <div id="sidebar">
        <div id="menu">
            <ul>
              <li><a href="homepage.html" onClick="logout_confirm(); return false;">Homepage</a>
             <script> function logout_confirm() {
  if(confirm("You are about to logout?"))
    window.location = "homepage.html";
}</script></li>
                <li><a href="login_success.php" title="">Login Homepage</a></li>
              <li><a href="fieldworks/accountdetails.php" title="">Account Detail</a></li>
                <li><a href="lastbill.php" title="">Last Bill</a></li>
                <li><a href="estatedetails.php" title="">Estate Details</a></li>
                <li><a href="fieldworks/contactuslogin.php" title="">Contact Us</a></li>
            </ul>
        </div>
        
        <div id="updates" class="boxed">
            <h2 class="title">Recent Updates</h2>
            <div class="content">
              <ul>
                <li> </li>
                <li>
                  <h3 class="style7">Coming Soon</h3>
                </li>
              </ul>
              <p>We will be extending our services to parks  and large lawns.</p>
              <ul>
                <li>
                  <h3></h3>
                </li>
              </ul>
          </div>
            <div class="content">
                <!-- Paste this code into the BODY section of your HTML document  -->


            </div>
      </div>
    </div>
    <div style="clear: both;">&nbsp;</div>
</div>
<div id="footer">Copyright &copy; 2008 filedworks.com. Designed by <a href="ttp://www.blanedesigns.com">Blane Designs</a>
  <p id="links"><br />
  <a href="#">Privacy Policy</a>
</div>
</body>
Reply With Quote