Untitled

<?php require_once('../Connections/cole.php'); ?>
 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><!-- InstanceBegin template="/Templates/FR_Stock_Control.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Furniture Restore Stock</title>
<!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<!-- InstanceBeginEditable name="head" -->
<!-- InstanceEndEditable -->
<link rel="stylesheet" href="frstyle.css" type="text/css">
</head>

<body leftmargin="0" rightmargin="0" topmargin="0" bottommargin="0">
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td bgcolor="#D4F7F7"> 
      <table width="780" height="120" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr bgcolor="#000000"> 
          <td width="100%" height="120"><a href="index.php"><img src="images/FR_logo.jpg" width="241" height="120" border="0"></a></td>
        </tr>
      </table>
      <table width="780" height="100%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr valign="top" bgcolor="#FFFFFF"> 
          <td height="397"><table width="100%" height="45%" border="0" align="left" cellpadding="0" cellspacing="0">
              <tr valign="top" bgcolor="#CC6633"> 
                <td height="25" colspan="2"><!-- InstanceBeginEditable name="EditRegion2" -->
                  <table width="100%" border="0" cellspacing="0" cellpadding="0">
                    <tr>
                      <td class="title1">Stock</td>
                    </tr>
                  </table>
                  <!-- InstanceEndEditable --></td>
              </tr>
              <tr valign="top" bgcolor="#FFFFFF"> 
                <td width="9%" height="25">&nbsp;</td>
                <td width="91%">&nbsp;</td>
              </tr>
              <tr valign="top"> 
                <td>&nbsp;</td>
                <td><!-- InstanceBeginEditable name="EditRegion" --> 
				
<? 	
	include('../func_lib.php');
	$db = Connect_DB();
    $qry = "SELECT * FROM `furniture_restore` WHERE date_in is not NULL and date_out is NULL order by stock_number";
   
	$resource = mysql_query ( $qry, $db ); 
	while ($row = mysql_fetch_array($resource)) {	 
 
?>
                 <table width="100%" border="0" cellpadding="5" cellspacing="0">
                    <tr> 
                      <td width="18%"> <p>Stock Number:</p></td>
                      <td width="82%"><? echo $row->stock_number ?></td>
                    </tr>
                    <tr> 
                      <td> <p>Date In:</p></td>
                      <td><? echo $row->date_in ?></td>
                    </tr>
                    <tr> 
                      <td> <p>Tel:</p></td>
                      <td><? echo $row->from_tel_no ?></td>
                    </tr>
                    <tr> 
                      <td> <p>&nbsp;</p></td>
                      <td><p>&nbsp;</p></td>
                    </tr>
                    <tr> 
                      <td> <p>&nbsp;</p></td>
                      <td><p>&nbsp;</p></td>
                    </tr>
                  </table>
<?
				  } //close while loop
?>
                  <!-- InstanceEndEditable --></td>
              </tr>
            </table></td>
        </tr>
      </table>
      <p>&nbsp;</p></td>
  </tr>
</table>
</body>
<!-- InstanceEnd --></html>