chrometweaks.org

Have u seen the new hot iPage girl?

Click Here To View All Answers...


Quick question: Have you seen the new hot iPage girl? Thanks in advance for any answer. Another quick question... Cany anyone tell me where in the code below I have an error?.

Require('includes/application_top.php');.

 require(DIR_WS_CLASSES'currencies.php');.

 $currencies = new currencies();.

 $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

 $orders_query = tep_db_query(" select orders_id from "TABLE_ORDERS"where orders_id = '"(int)$oID"'");.

When I try to view invoice I get the following error..

Thanks,.

David..

Comments (79)

Hmm... I need to find out myself. I don't know what is the right answer to your question. I'll do some research and get back to you if I got an useful answer. You should email the people at iPage as they probably could help you..

Comment #1

Do you need a space inbetween " and where ?

Comment #2

I put a space in there and Im getting this now.....

Comment #3

<?php.

/*.

 $Id: invoice.php,v 1.6 2003/06/20 00:37:30 hpdl Exp $.

 osCommerce, Open Source E-Commerce Solutions.

 http://www.oscommerce.com.

 Copyright (c) 2003 osCommerce.

 Released under the GNU General Public License.

*/.

 require('includes/application_top.php');.

 require(DIR_WS_CLASSES'currencies.php');.

 $currencies = new currencies();.

 $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

 $orders_query = tep_db_query(" select orders_id from "TABLE_ORDERS" where orders_id = '"(int)$oID"'");.

 include(DIR_WS_CLASSES'order.php');.

 $order = new order($oID);.

?>.

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">.

<html <?php echo HTML_PARAMS; ?>>.

<head>.

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">.

<title><?php echo TITLE; ?></title>.

<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">.

</head>.

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">.

<! body_text //>.

<table border="0" width="100%" cellspacing="0" cellpadding="2">.

 <tr>.

   <td><table border="0" width="100%" cellspacing="0" cellpadding="0">.

     <tr>.

       <td class="pageHeading"><?php echo nl2br(STORE_NAME_ADDRESS); ?></td>.

       <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES'oscommerce.gif', 'osCommerce', '204', '50'); ?></td>.

     </tr>.

   </table></td>.

 </tr>.

 <tr>.

   <td><table width="100%" border="0" cellspacing="0" cellpadding="2">.

     <tr>.

       <td colspan="2"><?php echo tep_draw_separator(); ?></td>.

     </tr>.

     <tr>.

       <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">.

         <tr>.

           <td class="main"><b><?php echo ENTRY_SOLD_TO; ?></b></td>.

         </tr>.

         <tr>.

           <td class="main"><?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>'); ?></td>.

         </tr>.

         <tr>.

           <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>.

         </tr>.

         <tr>.

           <td class="main"><?php echo $order->customer['telephone']; ?></td>.

         </tr>.

         <tr>.

           <td class="main"><?php echo '<a href="mailto:'$order->customer['email_address']'"><u>'$order->customer['email_address']'</u></a>'; ?></td>.

         </tr>.

       </table></td>.

       <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">.

         <tr>.

           <td class="main"><b><?php echo ENTRY_SHIP_TO; ?></b></td>.

         </tr>.

         <tr>.

           <td class="main"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>'); ?></td>.

         </tr>.

       </table></td>.

     </tr>.

   </table></td>.

 </tr>.

 <tr>.

   <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

 </tr>.

 <tr>.

   <td><table border="0" cellspacing="0" cellpadding="2">.

     <tr>.

       <td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>.

       <td class="main"><?php echo $order->info['payment_method']; ?></td>.

     </tr>.

   </table></td>.

 </tr>.

 <tr>.

   <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

 </tr>.

 <tr>.

   <td><table border="0" width="100%" cellspacing="0" cellpadding="2">.

     <tr class="dataTableHeadingRow">.

       <td class="dataTableHeadingContent" colspan="2"><?php echo TABLE_HEADING_PRODUCTS; ?></td>.

       <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>.

       <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TAX; ?></td>.

       <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_EXCLUDING_TAX; ?></td>.

       <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_INCLUDING_TAX; ?></td>.

       <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_EXCLUDING_TAX; ?></td>.

       <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_INCLUDING_TAX; ?></td>.

     </tr>.

<?php.

   for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) {.

If ($order->products[$i]['name'] == "Custom Computer"){.

   echo ' <tr class="dataTableRow">'"\n" ..

        ' <td class="dataTableContent" valign="top" align="right">'$order->products[$i]['qty']'&nbsp;x</td>'"\n" ..

        ' <td class="dataTableContent" valign="top">'$order->products[$i]['name']'<small><i>'$order->products[$i]['description']'</small></i>';.

   }else{.

     echo '      <tr class="dataTableRow">'"\n" ..

          '        <td class="dataTableContent" valign="top" align="right">'$order->products[$i]['qty']'&nbsp;x</td>'"\n" ..

          '        <td class="dataTableContent" valign="top">'$order->products[$i]['name'];.

    }.

     if (isset($order->products[$i]['attributes']) && (($k = sizeof($order->products[$i]['attributes'])) > 0)) {.

       for ($j = 0; $j < $k; $j++) {.

         echo '<br><nobr><small>&nbsp;<i> - '$order->products[$i]['attributes'][$j]['option']': '$order->products[$i]['attributes'][$j]['value'];.

         if ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' ('$order->products[$i]['attributes'][$j]['prefix']$currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])')';.

         echo '</i></small></nobr>';.

       }.

     }.

     echo '        </td>'"\n" ..

          '        <td class="dataTableContent" valign="top">'$order->products[$i]['model']'</td>'"\n";.

     echo '        <td class="dataTableContent" align="right" valign="top">'tep_display_tax_value($order->products[$i]['tax'])'%</td>'"\n" ..

          '        <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n" ..

          '        <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n" ..

          '        <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n" ..

          '        <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n";.

     echo '      </tr>'"\n";.

   }.

?>.

     <tr>.

       <td align="right" colspan="8"><table border="0" cellspacing="0" cellpadding="2">.

<?php.

 for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {.

   echo '          <tr>'"\n" ..

        '            <td align="right" class="smallText">'$order->totals[$i]['title']'</td>'"\n" ..

        '            <td align="right" class="smallText">'$order->totals[$i]['text']'</td>'"\n" ..

        '          </tr>'"\n";.

 }.

?>.

       </table></td>.

     </tr>.

   </table></td>.

 </tr>.

</table>.

<! body_text_eof //>.

<br>.

</body>.

</html>.

<?php require(DIR_WS_INCLUDES'application_bottom.php'); ?>.

Here is the invoice.php file in the admin directory. I get the same problem with the packaging slip file too..

However, If I look at the invoice for the returns mod it pulls the data..

I really appreciate your help..

David..

Comment #4

Try repairing your orders & products_description tables:.

Http://forums.oscommerce.com/index.php?sho...=0&#entry331728.

Let us know how it goes...

Comment #5

Should I also remove the space I added earlier in this thread?..

Comment #6

Okay, I did that. See the results below....

SQL-query.

SQL-query : [Edit] [Create PHP Code].

REPAIR TABLE `products_description`.

Table Op Msg_type Msg_text.

Worldofc_products.products_description repair status OK.

SQL-query.

SQL-query : [Edit] [Create PHP Code].

REPAIR TABLE `orders`.

Table Op Msg_type Msg_text.

Worldofc_products.orders repair status OK.

Still getting this error when trying to view them..

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1.

Select products_description as desc_info from products_description where products_id =.

[TEP STOP].

Thanks..

Comment #7

Well I decided to re-install the system. Recreated an account. Ran a test purchase. When I went into the admin, checked the order everything looked fine..

Clicked on invoice, and Im getting the same error. In the URL it says.

Http://www.worldofcomputersinc.com/product...gslip.php?oID=1.

If I change the number 1 to number 2 I can se the invoice..

Hope that helps! I really need to get all of these bugs worked out as I go live at the end of may..

Thanks again for your help..

Comment #8

Cany anyone tell me where in the code below I have an error?.

Require('includes/application_top.php');.

 require(DIR_WS_CLASSES'currencies.php');.

 $currencies = new currencies();.

 $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

 $orders_query = tep_db_query(" select orders_id from "TABLE_ORDERS"where orders_id = '"(int)$oID"'");.

When I try to view invoice I get the following error..

Thanks,.

David..

Comment #9


This question was taken from a support group/message board and re-posted here so others can learn from it.