[SOLVED] Need help with Avery 5160 script

tqla · July 19, 2007

Hi. I've been trying to use this AVERY 5160 Print Labels Module. The problem is when I excecute it I get this error:

Fatal error: Call to undefined function: db_query() in /home/virtual/site41/fst/var/www/html/newadmin/usermgr/5160-2.php on line 111

Anybody know why? ???

<?php
include_once("../classes/dbconnect.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'>
<?

$res = db_query("SELECT * FROM customers ORDER BY LoginName"); 

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>
<?

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

phat_hip_prog · July 19, 2007

I presume your not using mysql because I don't recognise the call (I only use mysql at mo). However have you got a connection to the database?

If it is mysql you'll need a connection, then select a database, finally your query should look a little like:

$res = mysql_query($s, $conn))

tqla · July 19, 2007

LOL! Thanks phat_hip_prog! You're right. That's so funny. Noob mistake again. :-\ I WILL become good at this. I will, I will I will!

Sign In

[SOLVED] Need help with Avery 5160 script

Recommended Posts

tqla

Link to comment

Share on other sites

phat_hip_prog

Link to comment

Share on other sites

tqla

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information