Version: 1.2

Type: Full Script

Category: Other

License: GNU General Public License

Description: This script allows you to print to the avery 5160 standard PHPBuliders members helped me make and I think it's just right to share it with the rest of PHP Builder Thanks again for making my life that much easier



<?php
  
/**
* /----------------------------------------------------------------------\
* | Digital Express, Inc.
* | Copyright (c) 2002 Richard Clark All rights reserved.
* | http://www.dvexinc.com
* | <richievc@hotmail.com>
* | 
* | AVERY 5160 Print Lables Moduel v 1.1.2 revised
* /----------------------------------------------------------------------\
*/
/**************************************************************** */
/**************************************************************** */
/**************************************************************** */

?>
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:w="urn:schemas-microsoft-com:office:word"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<title>Avery 6150</title>
<!--[if gte mso 9]><xml>
 <o:DocumentProperties>
  <o:Author>Techmaster</o:Author>
  <o:Template>Normal</o:Template>
  <o:LastAuthor>Techmaster</o:LastAuthor>
  <o:Revision>2</o:Revision>
  <o:TotalTime>3</o:TotalTime>
  <o:Created>2004-02-09T19:49:00Z</o:Created>
  <o:LastSaved>2004-02-09T19:49:00Z</o:LastSaved>
  <o:Pages>1</o:Pages>
  <o:Words>36</o:Words>
  <o:Characters>206</o:Characters>
  <o:Company>Digital Express</o:Company>
  <o:Lines>1</o:Lines>
  <o:Paragraphs>1</o:Paragraphs>
  <o:CharactersWithSpaces>241</o:CharactersWithSpaces>
  <o:Version>10.3501</o:Version>
 </o:DocumentProperties>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:SpellingState>Clean</w:SpellingState>
  <w:GrammarState>Clean</w:GrammarState>
  <w:Compatibility>
   <w:BreakWrappedTables/>
   <w:SnapToGridInCell/>
   <w:WrapTextWithPunct/>
   <w:UseAsianBreakRules/>
  </w:Compatibility>
  <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
 </w:WordDocument>
</xml><![endif]-->
<style>
<!--
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{mso-style-parent:"";
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman"; margin-left:0in; margin-right:0in; margin-top:0in}
span.SpellE
	{mso-style-name:"";
	mso-spl-e:yes}
@page Section1
	{size:8.5in 11.0in;
	margin:.5in 13.6pt 0in 13.6pt;
	mso-header-margin:.5in;
	mso-footer-margin:.5in;
	mso-paper-source:4;}
div.Section1
	{page:Section1;}
-->
</style>
<!--[if gte mso 10]>
<style>
 /* Style Definitions */
 table.MsoNormalTable
	{mso-style-name:"Table Normal";
	mso-tstyle-rowband-size:0;
	mso-tstyle-colband-size:0;
	mso-style-noshow:yes;
	mso-style-parent:"";
	mso-padding-alt:0in 5.4pt 0in 5.4pt;
	mso-para-margin:0in;
	mso-para-margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:10.0pt;
	font-family:"Times New Roman"}
</style>
<![endif]-->

</head>
<body lang=EN-US style='tab-interval:.5in'>
<?
 // CONN TO DB  
 $res = db_query("SELECT * FROM user 
                  WHERE user_zip = '$user_zip'"); 

 if (db_numrows($res) < 1){ 
   echo "<CENTER><B>No Results</B></CENTER>";
 } elseif (db_numrows($res) > 0) { 
   $cols = 0;  
   $rows = 0; 
   $max_cols=3; 
   $max_rows=10;
   // Set the num of rows and cols 
 
   while ($data=db_fetch_array($res)){ 

 #     if ($rows == 0){ // echo out table info 
 #
 #     } 
     if ($cols < 1){ // output the tr 
         echo "<div class=Section1>
               <table class=MsoNormalTable border=0 cellspacing=2 cellpadding=2 
               style='border-collapse:collapse;padding-top-alt:0in;padding-bottom-alt: 0in'>";
        echo "<tr style='yfti-irow:0;page-break-inside:avoid;height:1.0in'>"; 
     } 
     echo "<td width=189 style='width:189.0pt;padding:0in .75pt 0in .75pt;height:1.0in'> 
           <p class=MsoNormal align=center style='margin-top:0in; margin-right:5.3pt; 
              margin-bottom:0in; margin-left:5.3pt; margin-bottom:.0001pt;text-align:center'> 
           <span class=SpellE>";  
     echo "<FONT SIZE=1 FACE=\"Arial\">";
          if ($data[user_co_name]) {
            echo "$data[user_co_name]<BR>";
          }
     echo "$data[f_name] $data[l_name]<BR>
          $data[user_address]<BR>
          $data[user_city] $data[user_st]. $data[user_zip]</FONT>"; 
     echo "</span></p></td>"; 
     // before, you were outputting the end of the td before the beginning 
 
     $cols++; 

    if ($cols == $max_cols){ // reset cols, make new row, output trs 
        echo '</tr>'; 
        $rows++; 
        $cols=0; 
    } 
     
    if ($rows == $max_rows){ // reset rows, end table,put in line break--I substituted <hr> 
        echo "</table></div><BR><BR>"; 
        $rows=0; 
    }         
 }//end while loop 
  //now the tricky part, completing the last table 

 if ($cols == 0 && $rows == 0){ //done 
 
 } else { //end cols, then end table 
   while ($cols !=0 && $cols < $max_cols){//don't do if the cols have been reset 
       echo "<td width=252 style='width:189.0pt;padding:0in .75pt 0in .75pt;height:1.0in'> 
             <p class=Normal align=center style='margin-top:0in; margin-right:5.3pt; 
                margin-bottom:0in; margin-left:5.3pt; margin-bottom:.0001pt;text-align:center'> 
             <span class=SpellE> </td>"; 
       $cols++; 
   } 
   if ($cols == $max_cols) echo '</tr>';//to end the row if needed 
     echo '</table></div>'; //to end the table 
   }//end else 
 }//end if there are more than 0 rows 
    

?>
</body></html>
<?

/**************************************************************** */
/**************************************************************** */
/**************************************************************** */
?>