snubbr.com

I couldn't send an-mail without having a Verisign SSL?

Get a Verisign SSL certificate for 30 days FREE. Click here to use coupon...

Get a free trial of Verisign SSL certificates. Click here for this special deal...
My 1st question is: I couldn't send an-mail without having a Verisign SSL? Thanks for any answer or 2. Second question.. With the current code from a contribution I receive the dreaded =.

1054 - Unknown column 'p.products_tax_class_id' in 'on clause'.

Select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight, p.products_tax_class_id, tr.tax_rate from products p, products_description pd left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id where p.products_id = pd.products_id and pd.language_id = '1'.

[TEP STOP].

Here is what I think is the offending code =.

If(isset($HTTP_GET_VARS['cPath']) && $HTTP_GET_VARS['cPath'] != 0){.

$current_category_id = $HTTP_GET_VARS['cPath'];.

$product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight, p.products_tax_class_id, tr.tax_rate from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd inner join "TABLE_PRODUCTS_TO_CATEGORIES" p2c on p.products_id = p2c.products_id left join "TABLE_TAX_RATES" tr on p.products_tax_class_id = tr.tax_class_id where p.products_id = pd.products_id and pd.language_id = '"(int)$languages_id"' and p2c.categories_id = "(int)$HTTP_GET_VARS['cPath']$search_qry$stock_qry);.

} else {.

$product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight, p.products_tax_class_id, tr.tax_rate from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd left join "TABLE_TAX_RATES" tr on p.products_tax_class_id = tr.tax_class_id where p.products_id = pd.products_id and pd.language_id = '"(int)$languages_id"'"$search_qry$stock_qry);.

$current_category_id = '';.

}..

Comments (93)

I would like to know the answer too. Anyone here know what is the right answer. I'll do some research in Google and get back to you if I find an answer. You should email the people at Verisign as they probably can answer it..

Comment #1

Try changing this.

$product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight, p.products_tax_class_id, tr.tax_rate from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd left join "TABLE_TAX_RATES" tr on p.products_tax_class_id = tr.tax_class_id where p.products_id = pd.products_id and pd.language_id = '"(int)$languages_id"'"$search_qry$stock_qry);.

To this.

$product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight, p.products_tax_class_id, tr.tax_rate from "TABLE_PRODUCTS" p left join "TABLE_PRODUCTS_DESCRIPTION" pd p.products_id = pd.products_id left join "TABLE_TAX_RATES" tr on p.products_tax_class_id = tr.tax_class_id where pd.language_id = '"(int)$languages_id"'"$search_qry$stock_qry);.

The other line may need changing too but I didn't look at it..

Jack..

Comment #2

Thank you Jack!.

I changed that bit of code and then received this error message -.

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 'p.products_id = pd.products_id left join tax_rates tr on p.products_tax_class_id' at line 1.

Select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight, p.products_tax_class_id, tr.tax_rate from products p left join products_description pd p.products_id = pd.products_id left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id where pd.language_id = '1'.

[TEP STOP].

Thanks Tim for the link..

No matter what or how I change the code from the first section posted previously, I always receive a similar error message..

This PHP dummy sure would appreciate a little more help if you don't mind...

Comment #3

Which file and contribution are you having this problem with?.

I am no php expert either. I might already have an updated file though..

Tim..

Comment #4

I'm sorry. This part of the change I supplied.

Products_description pd p.products_id = pd.products_id.

Should be.

Products_description pd on p.products_id = pd.products_id.

Jack..

Comment #5

Hi Tim,.

I was searching for a contribution in which I could sort and print my inventory from the admin side..

This seemed to fit the bill -.

Products Listing.

, where the other contribs seemed to offer "customers" the print option instead..

But the contrib has been a nightmare from the beginning. I had to download different versions, piece meal it together and figure out some steps on installing on my own (incomplete instructions). The file I am having trouble with right now is -.

Admin\product_list.php.

Found in v1.4. That is supposed to be the file that allows sorting options as to what you want to print...

Comment #6

Thank you Jack..

I thought you meant this.

:.

$product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight, p.products_tax_class_id, tr.tax_rate from "TABLE_PRODUCTS" p left join "TABLE_PRODUCTS_DESCRIPTION".

Pd.

P.products_id = pd.products_id left join "TABLE_TAX_RATES" tr on p.products_tax_class_id = tr.tax_class_id where pd.language_id = '"(int)$languages_id"'"$search_qry$stock_qry);.

Should be this.

:.

$product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight, p.products_tax_class_id, tr.tax_rate from "TABLE_PRODUCTS" p left join "TABLE_PRODUCTS_DESCRIPTION".

On.

P.products_id = pd.products_id left join "TABLE_TAX_RATES" tr on p.products_tax_class_id = tr.tax_class_id where pd.language_id = '"(int)$languages_id"'"$search_qry$stock_qry);.

But then I receive this.

:.

1054 - Unknown column 'pd.products_name' in 'field list'.

Select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight, p.products_tax_class_id, tr.tax_rate from products p left join products_description on p.products_id = pd.products_id left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id where pd.language_id = '1'.

[TEP STOP].

Sorry for my confussion.....

Comment #7

No, you need both the pd and the on, so it should be.

$product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight, p.products_tax_class_id, tr.tax_rate from "TABLE_PRODUCTS" p left join "TABLE_PRODUCTS_DESCRIPTION" pd on p.products_id = pd.products_id left join "TABLE_TAX_RATES" tr on p.products_tax_class_id = tr.tax_class_id where pd.language_id = '"(int)$languages_id"'"$search_qry$stock_qry);.

Jack..

Comment #8

Thank you SO MUCH Jack!.

That did the trick, the page is now loading just fine..

However... a new problem(s) arose on the page, it's search criteria and update function..

I'm wondering if it has to do with my installation of Ultimate SEO URL's...???.

Search by category.

:.

<?php.

Echo tep_draw_form('goto', FILENAME_PRODUCT_LIST, '', 'get');.

Echo 'Go to: '' 'tep_draw_pull_down_menu('cPath', tep_get_category_tree(), $current_category_id, 'onChange="this.form.submit();"');.

Echo ((isset($HTTP_GET_VARS['stock'])) ? tep_draw_hidden_field('stock', $HTTP_GET_VARS['stock']) : '');.

Echo ((isset($HTTP_GET_VARS['search'])) ? tep_draw_hidden_field('search', $HTTP_GET_VARS['search']) : '');.

Echo '</form>';.

?>.

Search by QTY.

:.

<?php.

Echo tep_draw_form('goto', FILENAME_PRODUCT_LIST, '', 'get');.

Echo 'Stock qty: '' 'tep_draw_pull_down_menu('stock', $stock_array, '', 'onChange="this.form.submit();"');.

Echo ((isset($HTTP_GET_VARS['cPath'])) ? tep_draw_hidden_field('cPath', $HTTP_GET_VARS['cPath']) : '');.

Echo ((isset($HTTP_GET_VARS['search'])) ? tep_draw_hidden_field('search', $HTTP_GET_VARS['search']) : '');.

Echo '</form>';.

?>.

Update Price.

:.

<input type="text" name="price[]" id="price_<?php echo $product['products_id'];?>" value="<?php echo $product['products_price'];?>" size="6" onKeyUp="updateGross(<?php echo ((tep_not_null($product['tax_rate'])) ? $product['tax_rate'] : 0)?>, <?php echo $product['products_id'];?>)">.

Update Weight.

:.

<input type="text" name="weight[]" id="weight" value="<?php echo $product['products_weight'];?>" size="6">.

Update QTY.

:.

<input type="text" name="qty[]" id="qty" value="<?php echo $product['products_quantity'];?>" size="6">.

The results.

:.

HTTP 404 Not Found.

One search URL example =.

Http://handeshobbies.com/catalog/admin/FILENAME_PRODUCT_LIST?cPath=31.

When I tried updating the price of an item, it did infact change the price in the database but returned =.

HTTP 404 Not Found.

Http://handeshobbies.com/catalog/admin/product_list.php.

Is it because the search is using cPath?.

Is it old code or some code missing?.

I think this is the last major bug(s) for making this contribution functional, besides maybe cleaning up the displayed order of the results..

Thank you Tim for trying to help..

I truely appreciate all the help you have given me Jack (now and in the past) and I feel bad asking for help again...

Comment #9

This isn't a valid path.

Http://handeshobbies.com/catalog/admin/FILENAME_PRODUCT_LIST?cPath=31.

Notice the FILENAME_PRODUCT_LIST. You need to add a define for that in includes/filenames.php. it may not fix your problem but it needs to be fixed before you will know..

Jack..

Comment #10

Thank you Jack for pointing that out. I thought I had already defined it..

Nope! It was another define for product_list.php DUH..

Ok, now I feel like a total idiot with mush for brains..

When I update a selection and click submit, all works now. HURRAY!!!.

But when I select a search criteria I'm back to that similar/fimilar first error message..

1054 - Unknown column 'p.products_id' in 'on clause'.

Select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight, p.products_tax_class_id, tr.tax_rate from products p, products_description pd inner join products_to_categories p2c on p.products_id = p2c.products_id left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id where p.products_id = pd.products_id and pd.language_id = '1' and p2c.categories_id = 31.

[TEP STOP].

I'm "guessing" it's from that first half of code which we/I haven't edited yet..

$product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight, p.products_tax_class_id, tr.tax_rate from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd inner join "TABLE_PRODUCTS_TO_CATEGORIES" p2c on p.products_id = p2c.products_id left join "TABLE_TAX_RATES" tr on p.products_tax_class_id = tr.tax_class_id where p.products_id = pd.products_id and pd.language_id = '"(int)$languages_id"' and p2c.categories_id = "(int)$HTTP_GET_VARS['cPath']$search_qry$stock_qry);.

I know it must need changing similar to what was done previously and I tried, but you guessed it....

Mr. Brain Fart himself can't fight his way out of a wet paper bag...

Comment #11

How about this.

$product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight, p.products_tax_class_id, tr.tax_rate from "TABLE_PRODUCTS" p left join "TABLE_PRODUCTS_DESCRIPTION" pd on p.products_id = pd.products_id inner join "TABLE_PRODUCTS_TO_CATEGORIES" p2c on p.products_id = p2c.products_id left join "TABLE_TAX_RATES" tr on p.products_tax_class_id = tr.tax_class_id where pd.language_id = '"(int)$languages_id"' and p2c.categories_id = "(int)$HTTP_GET_VARS['cPath']$search_qry$stock_qry);.

Jack..

Comment #12

Oh my God!!!.

You are a Saint Jack... Thank you so much! It is all working now..

I really really truely appreciate all the help you have given me. I can't thank you enough!..

Comment #13

I thought getting the list of items to display in an orderly fashion was going to be easy, man was I wrong..

I had previously added a contribution to the admincategories.php file which added the products_model to the list and sorted the results by it. A very nice addition so you just have to scroll looking for the model number. I wanted to do something like that with this file. But adding.

"%' order by p.products_model".

Only resulted in an error message. So obviously again I am clueless..

Here is where I tried adding it:.

If(isset($HTTP_GET_VARS['cPath']) && $HTTP_GET_VARS['cPath'] != 0){.

$current_category_id = $HTTP_GET_VARS['cPath'];.

$product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight, p.products_tax_class_id, tr.tax_rate from "TABLE_PRODUCTS" p left join "TABLE_PRODUCTS_DESCRIPTION" pd on p.products_id = pd.products_id inner join "TABLE_PRODUCTS_TO_CATEGORIES" p2c on p.products_id = p2c.products_id left join "TABLE_TAX_RATES" tr on p.products_tax_class_id = tr.tax_class_id where pd.language_id = '"(int)$languages_id"' and p2c.categories_id = "(int)$HTTP_GET_VARS['cPath']$search_qry$stock_qry ..

"%' order by p.products_model".

);.

} else {.

$product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight, p.products_tax_class_id, tr.tax_rate from "TABLE_PRODUCTS" p left join "TABLE_PRODUCTS_DESCRIPTION" pd on p.products_id = pd.products_id left join "TABLE_TAX_RATES" tr on p.products_tax_class_id = tr.tax_class_id where pd.language_id = '"(int)$languages_id"'"$search_qry$stock_qry ..

"%' order by p.products_model".

);.

$current_category_id = '';.

}.

I tried different combinations and places of the above code but nothing..

Here is the code from the file:.

<?php.

/*.

$Id: categories.php,v 1.146 2003/07/11 14:40:27 hpdl Exp $</P> <P> osCommerce, Open Source E-Commerce Solutions.

<A href="http://www.oscommerce.com">http://www.oscommerce.com</A></P> <P> Copyright (c) 2003 osCommerce</P> <P> Released under the GNU General Public License.

*/</P> <P> require('includes/application_top.php');.

Require('includes/languages/product_list.php');.

Require(DIR_WS_CLASSES'currencies.php');.

$currencies = new currencies();.

If(isset($HTTP_GET_VARS['search'])){.

$search_qry = " and pd.products_name like '"$HTTP_GET_VARS['search']"%'";.

} else {.

$search_qry = '';.

}.

If(isset($HTTP_GET_VARS['stock'])){.

Switch($HTTP_GET_VARS['stock']){.

Case 1:.

$stock_qry = " and p.products_quantity between '0' and '1'";.

Break;.

Case 2:.

$stock_qry = " and p.products_quantity between '2' and '4'";.

Break;.

Case 3:.

$stock_qry = " and p.products_quantity between '5' and '8'";.

Break;.

Case 4:.

$stock_qry = " and p.products_quantity > 8";.

Break;.

Default:.

$stock_qry = "";.

Break;.

}.

} else {.

$stock_qry = "";.

}.

If(isset($HTTP_GET_VARS['cPath']) && $HTTP_GET_VARS['cPath'] != 0){.

$current_category_id = $HTTP_GET_VARS['cPath'];.

$product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight, p.products_tax_class_id, tr.tax_rate from "TABLE_PRODUCTS" p left join "TABLE_PRODUCTS_DESCRIPTION" pd on p.products_id = pd.products_id inner join "TABLE_PRODUCTS_TO_CATEGORIES" p2c on p.products_id = p2c.products_id left join "TABLE_TAX_RATES" tr on p.products_tax_class_id = tr.tax_class_id where pd.language_id = '"(int)$languages_id"' and p2c.categories_id = "(int)$HTTP_GET_VARS['cPath']$search_qry$stock_qry);.

} else {.

$product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight, p.products_tax_class_id, tr.tax_rate from "TABLE_PRODUCTS" p left join "TABLE_PRODUCTS_DESCRIPTION" pd on p.products_id = pd.products_id left join "TABLE_TAX_RATES" tr on p.products_tax_class_id = tr.tax_class_id where pd.language_id = '"(int)$languages_id"'"$search_qry$stock_qry);.

$current_category_id = '';.

}.

$stock_array = array();.

$stock_array[] = array('id' => '0', 'text' => 'All');.

$stock_array[] = array('id' => '1', 'text' => '0 - 1');.

$stock_array[] = array('id' => '2', 'text' => '2 - 4');.

$stock_array[] = array('id' => '3', 'text' => '5 - 8');.

$stock_array[] = array('id' => '4', 'text' => '8 +');</P> <P>if($_REQUEST['prod_search']!="").

{.

// $product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd where p.products_id = pd.products_id and pd.language_id = '"(int)$languages_id"' and pd.products_name like '".$_REQUEST['prod_search']."%'");.

}.

Else.

{.

// $product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd where p.products_id = pd.products_id and pd.language_id = '"(int)$languages_id"'");.

}.

If($_REQUEST['update']=="update"){.

Foreach($HTTP_POST_VARS['products_id'] as $key => $value){.

Tep_db_query("update "TABLE_PRODUCTS" set products_price = '"$HTTP_POST_VARS['price'][$key]"', products_weight = '"$HTTP_POST_VARS['weight'][$key]"', products_quantity = '"$HTTP_POST_VARS['qty'][$key]"' where products_id = "$value);.

}</P> <P>.

// while($product1 = tep_db_fetch_array($product_query)) {.

// $str=tep_db_query("update products set products_price='".$_REQUEST['price_'.$product1['products_id']]."',products_weight='".$_REQUEST['weight_'.$product1['products_id']]."', products_quantity='".$_REQUEST['qty_'.$product1['products_id']]."' where products_id='".$product1[products_id]."'");.

// }.

Tep_redirect(tep_href_link(FILENAME_PRODUCT_LIST, 'Update=Success'(isset($HTTP_POST_VARS['search']) ? '&search='$HTTP_POST_VARS['search'] : '')(isset($HTTP_POST_VARS['cPath']) ? '&cPath='$HTTP_POST_VARS['cPath'] : '')(isset($HTTP_POST_VARS['stock']) ? '&stock='$HTTP_POST_VARS['stock'] : '')));.

// header("location:product_list.php?Update=Success&prod_search=".$_REQUEST['prod_search']);.

}.

?>.

<!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"></P> <P><script language="javascript" src="includes/general.js"></script>.

<script language="javascript"><!</P> <P>function doRound(x, places) {.

Return Math.round(x * Math.pow(10, places)) / Math.pow(10, places);.

}</P> <P>function updateGross(taxRate, product_id) {.

// var taxRate = getTaxRate();.

Var grossValue = document.getElementById('price_' + product_id).value;.

If (taxRate > 0) {.

GrossValue = grossValue * ((taxRate / 100) + 1);.

}.

Document.getElementById('price_gross_' + product_id).value = doRound(grossValue, 4);.

// document.forms["new_product"].products_price_gross.value = doRound(grossValue, 4);.

}</P> <P>function updateNet(taxRate, product_id) {.

// var taxRate = getTaxRate();.

Var netValue = document.getElementById('price_gross_' + product_id).value;.

If (taxRate > 0) {.

NetValue = netValue / ((taxRate / 100) + 1);.

}.

Document.getElementById('price_' + product_id).value = doRound(netValue, 4);.

// document.forms["new_product"].products_price_gross.value = doRound(grossValue, 4);.

}.

//></script>.

</head>.

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onLoad="SetFocus();">.

<div id="spiffycalendar" class="text"></div>.

<! header //>.

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

<! header_eof //></P> <P><! body //>.

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

<tr>.

<td width="<?php echo BOX_WIDTH; ?>" valign="top">.

<table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">.

<! left_navigation //>.

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

<! left_navigation_eof //>.

</table>.

</td>.

<! body_text //>.

<td valign="top">.

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

<tr>.

<td><table border="1" width="100%"><tr></P> <P> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>.

<?php //oscworker start; ?>.

<td class="smallText" align="right">.

<?php.

Echo tep_draw_form('search', FILENAME_PRODUCT_LIST, '', 'get');.

Echo 'Search: '' 'tep_draw_input_field('search');.

Echo ((isset($HTTP_GET_VARS['cPath'])) ? tep_draw_hidden_field('cPath', $HTTP_GET_VARS['cPath']) : '');.

Echo '</form>';.

?>.

</td></P> <P> <td class="smallText" align="right">.

<?php.

Echo tep_draw_form('goto', FILENAME_PRODUCT_LIST, '', 'get');.

Echo 'Go to: '' 'tep_draw_pull_down_menu('cPath', tep_get_category_tree(), $current_category_id, 'onChange="this.form.submit();"');.

Echo ((isset($HTTP_GET_VARS['stock'])) ? tep_draw_hidden_field('stock', $HTTP_GET_VARS['stock']) : '');.

Echo ((isset($HTTP_GET_VARS['search'])) ? tep_draw_hidden_field('search', $HTTP_GET_VARS['search']) : '');.

Echo '</form>';.

?>.

</td></P> <P> <td class="smallText" align="right">.

<?php.

Echo tep_draw_form('goto', FILENAME_PRODUCT_LIST, '', 'get');.

Echo 'Stock qty: '' 'tep_draw_pull_down_menu('stock', $stock_array, '', 'onChange="this.form.submit();"');.

Echo ((isset($HTTP_GET_VARS['cPath'])) ? tep_draw_hidden_field('cPath', $HTTP_GET_VARS['cPath']) : '');.

Echo ((isset($HTTP_GET_VARS['search'])) ? tep_draw_hidden_field('search', $HTTP_GET_VARS['search']) : '');.

Echo '</form>';.

?>.

</td>.

</tr></table></td>.

<?php //oscworker end; ?>.

</tr></P> <P> <?php.

If($_REQUEST['Update']=="Success").

{.

?>.

<tr><td><font color="#FF3333">Record has been updated successfully</font></td></tr>.

<?php.

}.

?>.

<tr>.

<td valign="top" colspan="2">.

<form name="form1" method="POST" action="product_list.php">.

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

<tr class="dataTableHeadingRow">.

<td class="dataTableHeadingContent" width="15%"><?php echo TABLE_HEADING_PART_NO; ?>.

</td>.

<td class="dataTableHeadingContent" width="43%"><?php echo TABLE_HEADING_NAME; ?>.

</td>.

<td class="dataTableHeadingContent" width="10%"><?php echo TABLE_HEADING_PRICE; ?>&nbsp;.

</td>.

<td class="dataTableHeadingContent" width="10%"><?php echo TABLE_HEADING_WEIGHT; ?>&nbsp;.

</td>.

<td class="dataTableHeadingContent" width="12%"><?php echo TABLE_HEADING_STOCK_LEVEL; ?>&nbsp;.

</td>.

<td class="dataTableHeadingContent" width="12%">Price with Tax&nbsp;.

</td>.

</tr>.

<?php</P> <P>.

While($product = tep_db_fetch_array($product_query)).

{.

?>.

<tr valign="top" >.

<td valign="top" class="dataTableContent"><?php echo $product['products_model']tep_draw_hidden_field('products_id[]', $product['products_id']);?></td></P> <P> <td width="20%" valign="top" class="dataTableContent">.

<?php.

Echo $products_name=$product['products_name'];.

//$description1 =substr($products_name, 0, 45);.

//echo $description1.".....";.

?>.

</td>.

<td valign="top" class="dataTableContent"><input type="text" name="price[]" id="price_<?php echo $product['products_id'];?>" value="<?php echo $product['products_price'];?>" size="6" onKeyUp="updateGross(<?php echo ((tep_not_null($product['tax_rate'])) ? $product['tax_rate'] : 0)?>, <?php echo $product['products_id'];?>)"></td></P> <P> <td valign="top" class="dataTableContent"><input type="text" name="weight[]" id="weight" value="<?php echo $product['products_weight'];?>" size="6"></td></P> <P> <td valign="top" class="dataTableContent"><input type="text" name="qty[]" id="qty" value="<?php echo $product['products_quantity'];?>" size="6"></td>.

<td valign="top" class="dataTableContent"><?php $price_gross = $product['products_price'] * (($product['tax_rate'] / 100) + 1);?><input type="text" name="price_gross" id="price_gross_<?php echo $product['products_id'];?>" value="<?php echo $price_gross;?>" size="6" onKeyUp="updateNet(<?php echo ((tep_not_null($product['tax_rate'])) ? $product['tax_rate'] : 0)?>, <?php echo $product['products_id'];?>)"></td>.

</tr>.

<?php.

}.

?>.

<tr>.

<td></td>.

<td></td>.

<td></td>.

<td class="dataTableContent">.

<input type="hidden" name="prod_search" value="<?php echo $_REQUEST['prod_search']; ?>"><input type="submit" name="update" value="update">.

<?php.

If(tep_not_null($HTTP_GET_VARS['search'])) echo tep_draw_hidden_field('search', $HTTP_GET_VARS['search']);.

If(tep_not_null($HTTP_GET_VARS['cPath'])) echo tep_draw_hidden_field('cPath', $HTTP_GET_VARS['cPath']);.

If(tep_not_null($HTTP_GET_VARS['stock'])) echo tep_draw_hidden_field('stock', $HTTP_GET_VARS['stock']);.

?>.

</td>.

</tr>.

</table>.

</form>.

</td>.

</tr>.

</table>.

</td>.

</tr>.

</table></P> <P><! body_text_eof //>.

<! body_eof //>.

<! footer //>.

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

<! footer_eof //>.

</body>.

</html>.

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

Comment #14

I think.

"%' order by p.products_model.

Should be.

" order by p.products_model.

Jack..

Comment #15

Thank you Jack..

I never thought to drop the.

%'.

Last.

Big.

Bugger-roo for this file....

I almost have it... I think!?!.

Instead of the output listing a price with tax column, I'm trying to swap it for a functioning product status column (able to change from active to inactive - green & red dots)..

Ive got the column to show, but the status looks like it's set to inactive as the red dot seems highlighted for every product..

Here's the changes I made:.

If(isset($HTTP_GET_VARS['cPath']) && $HTTP_GET_VARS['cPath'] != 0){.

$current_category_id = $HTTP_GET_VARS['cPath'];.

$product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight, p.products_status, p.products_tax_class_id, tr.tax_rate from "TABLE_PRODUCTS" p left join "TABLE_PRODUCTS_DESCRIPTION" pd on p.products_id = pd.products_id inner join "TABLE_PRODUCTS_TO_CATEGORIES" p2c on p.products_id = p2c.products_id left join "TABLE_TAX_RATES" tr on p.products_tax_class_id = tr.tax_class_id where pd.language_id = '"(int)$languages_id"' and p2c.categories_id = "(int)$HTTP_GET_VARS['cPath']$search_qry$stock_qry" order by p.products_model ");.

} else {.

$product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight, p.products_status, p.products_tax_class_id, tr.tax_rate from "TABLE_PRODUCTS" p left join "TABLE_PRODUCTS_DESCRIPTION" pd on p.products_id = pd.products_id left join "TABLE_TAX_RATES" tr on p.products_tax_class_id = tr.tax_class_id where pd.language_id = '"(int)$languages_id"'"$search_qry$stock_qry" order by p.products_model ");.

$current_category_id = '';.

}.

Added = p.products_status,.

If($_REQUEST['update']=="update"){.

Foreach($HTTP_POST_VARS['products_id'] as $key => $value){.

Tep_db_query("update "TABLE_PRODUCTS" set products_price = '"$HTTP_POST_VARS['price'][$key]"', products_weight = '"$HTTP_POST_VARS['weight'][$key]"', products_quantity = '"$HTTP_POST_VARS['qty'][$key]"', products_status = '"$HTTP_POST_VARS['status'][$key]"' where products_id = "$value);.

}.

Added = , products_status = '"$HTTP_POST_VARS['status'][$key] ..

<td valign="top" class="dataTableContent"><?php.

If ($products['products_status'] == '1') {.

Echo tep_image(DIR_WS_IMAGES'icon_status_green.gif', IMAGE_ICON_STATUS_GREEN, 10, 10)'&nbsp;&nbsp;<a href="'tep_href_link(FILENAME_CATEGORIES, 'action=setflag&flag=0&pID='$products['products_id']'&cPath='$cPath)'">'tep_image(DIR_WS_IMAGES'icon_status_red_light.gif', IMAGE_ICON_STATUS_RED_LIGHT, 10, 10)'</a>';.

} else {.

Echo '<a href="'tep_href_link(FILENAME_CATEGORIES, 'action=setflag&flag=1&pID='$products['products_id']'&cPath='$cPath)'">'tep_image(DIR_WS_IMAGES'icon_status_green_light.gif', IMAGE_ICON_STATUS_GREEN_LIGHT, 10, 10)'</a>&nbsp;&nbsp;'tep_image(DIR_WS_IMAGES'icon_status_red.gif', IMAGE_ICON_STATUS_RED, 10, 10);.

}.

?></td>.

Swapped the original price with tax code with the code from categories.php file..

Maybe something wrong with the/a query or an echo?..

Comment #16

It's difficult to see what is going on since that code is out of context but you can insert a command to print the status variable to see if it is set or not. Somewhere before the check is done, add.

Echo 'status ' .$products['products_status'];.

If it doesn't print a 1 then the problem is with the data being retrieved..

Jack..

Comment #17

No matter where or how I insert that bit of code, well... I must be doing it wrong. Either nothing changes, I receive an error message (unexpected T string or something) or it just inserts status on the web page next to the red & green icons..

Here's my revised version in full content, sorry I didn't post it that way previously..

<?php.

/*.

$Id: categories.php,v 1.146 2003/07/11 14:40:27 hpdl Exp $</P> <P> osCommerce, Open Source E-Commerce Solutions.

<A href="http://www.oscommerce.com">http://www.oscommerce.com</A></P> <P> Copyright (c) 2003 osCommerce</P> <P> Released under the GNU General Public License.

*/</P> <P> require('includes/application_top.php');.

Require('includes/languages/product_list.php');.

Require(DIR_WS_CLASSES'currencies.php');.

$currencies = new currencies();.

If(isset($HTTP_GET_VARS['search'])){.

$search_qry = " and pd.products_name like '"$HTTP_GET_VARS['search']"%'";.

} else {.

$search_qry = '';.

}.

If(isset($HTTP_GET_VARS['stock'])){.

Switch($HTTP_GET_VARS['stock']){.

Case 1:.

$stock_qry = " and p.products_quantity between '0' and '1'";.

Break;.

Case 2:.

$stock_qry = " and p.products_quantity between '2' and '4'";.

Break;.

Case 3:.

$stock_qry = " and p.products_quantity between '5' and '8'";.

Break;.

Case 4:.

$stock_qry = " and p.products_quantity > 8";.

Break;.

Default:.

$stock_qry = "";.

Break;.

}.

} else {.

$stock_qry = "";.

}.

If(isset($HTTP_GET_VARS['cPath']) && $HTTP_GET_VARS['cPath'] != 0){.

$current_category_id = $HTTP_GET_VARS['cPath'];.

$product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight, p.products_status, p.products_tax_class_id, tr.tax_rate from "TABLE_PRODUCTS" p left join "TABLE_PRODUCTS_DESCRIPTION" pd on p.products_id = pd.products_id inner join "TABLE_PRODUCTS_TO_CATEGORIES" p2c on p.products_id = p2c.products_id left join "TABLE_TAX_RATES" tr on p.products_tax_class_id = tr.tax_class_id where pd.language_id = '"(int)$languages_id"' and p2c.categories_id = "(int)$HTTP_GET_VARS['cPath']$search_qry$stock_qry" order by p.products_model ");.

} else {.

$product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight, p.products_status, p.products_tax_class_id, tr.tax_rate from "TABLE_PRODUCTS" p left join "TABLE_PRODUCTS_DESCRIPTION" pd on p.products_id = pd.products_id left join "TABLE_TAX_RATES" tr on p.products_tax_class_id = tr.tax_class_id where pd.language_id = '"(int)$languages_id"'"$search_qry$stock_qry" order by p.products_model ");.

$current_category_id = '';.

}.

$stock_array = array();.

$stock_array[] = array('id' => '0', 'text' => 'All');.

$stock_array[] = array('id' => '1', 'text' => '0 - 1');.

$stock_array[] = array('id' => '2', 'text' => '2 - 4');.

$stock_array[] = array('id' => '3', 'text' => '5 - 8');.

$stock_array[] = array('id' => '4', 'text' => '8 +');</P> <P>if($_REQUEST['prod_search']!="").

{.

// $product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd where p.products_id = pd.products_id and pd.language_id = '"(int)$languages_id"' and pd.products_name like '".$_REQUEST['prod_search']."%'");.

}.

Else.

{.

// $product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd where p.products_id = pd.products_id and pd.language_id = '"(int)$languages_id"'");.

}.

If($_REQUEST['update']=="update"){.

Foreach($HTTP_POST_VARS['products_id'] as $key => $value){.

Tep_db_query("update "TABLE_PRODUCTS" set products_price = '"$HTTP_POST_VARS['price'][$key]"', products_weight = '"$HTTP_POST_VARS['weight'][$key]"', products_quantity = '"$HTTP_POST_VARS['qty'][$key]"', products_status = '"$HTTP_POST_VARS['status'][$key]"' where products_id = "$value);.

}</P> <P>.

// while($product1 = tep_db_fetch_array($product_query)) {.

// $str=tep_db_query("update products set products_price='".$_REQUEST['price_'.$product1['products_id']]."',products_weight='".$_REQUEST['weight_'.$product1['products_id']]."', products_quantity='".$_REQUEST['qty_'.$product1['products_id']]."' where products_id='".$product1[products_id]."'");.

// }.

Tep_redirect(tep_href_link(FILENAME_PRODUCT_LIST, 'Update=Success'(isset($HTTP_POST_VARS['search']) ? '&search='$HTTP_POST_VARS['search'] : '')(isset($HTTP_POST_VARS['cPath']) ? '&cPath='$HTTP_POST_VARS['cPath'] : '')(isset($HTTP_POST_VARS['stock']) ? '&stock='$HTTP_POST_VARS['stock'] : '')));.

// header("location:product_list.php?Update=Success&prod_search=".$_REQUEST['prod_search']);.

}.

?>.

<!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"></P> <P><script language="javascript" src="includes/general.js"></script>.

<script language="javascript"><!</P> <P>function doRound(x, places) {.

Return Math.round(x * Math.pow(10, places)) / Math.pow(10, places);.

}</P> <P>function updateGross(taxRate, product_id) {.

// var taxRate = getTaxRate();.

Var grossValue = document.getElementById('price_' + product_id).value;.

If (taxRate > 0) {.

GrossValue = grossValue * ((taxRate / 100) + 1);.

}.

Document.getElementById('price_gross_' + product_id).value = doRound(grossValue, 4);.

// document.forms["new_product"].products_price_gross.value = doRound(grossValue, 4);.

}</P> <P>function updateNet(taxRate, product_id) {.

// var taxRate = getTaxRate();.

Var netValue = document.getElementById('price_gross_' + product_id).value;.

If (taxRate > 0) {.

NetValue = netValue / ((taxRate / 100) + 1);.

}.

Document.getElementById('price_' + product_id).value = doRound(netValue, 4);.

// document.forms["new_product"].products_price_gross.value = doRound(grossValue, 4);.

}.

//></script>.

</head>.

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onLoad="SetFocus();">.

<div id="spiffycalendar" class="text"></div>.

<! header //>.

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

<! header_eof //></P> <P><! body //>.

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

<tr>.

<td width="<?php echo BOX_WIDTH; ?>" valign="top">.

<table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">.

<! left_navigation //>.

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

<! left_navigation_eof //>.

</table>.

</td>.

<! body_text //>.

<td valign="top">.

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

<tr>.

<td><table border="1" width="100%"><tr></P> <P> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>.

<?php //oscworker start; ?>.

<td class="smallText" align="right">.

<?php.

Echo tep_draw_form('search', FILENAME_PRODUCT_LIST, '', 'get');.

Echo 'Search: '' 'tep_draw_input_field('search');.

Echo ((isset($HTTP_GET_VARS['cPath'])) ? tep_draw_hidden_field('cPath', $HTTP_GET_VARS['cPath']) : '');.

Echo '</form>';.

?>.

</td></P> <P> <td class="smallText" align="right">.

<?php.

Echo tep_draw_form('goto', FILENAME_PRODUCT_LIST, '', 'get');.

Echo 'Go to: '' 'tep_draw_pull_down_menu('cPath', tep_get_category_tree(), $current_category_id, 'onChange="this.form.submit();"');.

Echo ((isset($HTTP_GET_VARS['stock'])) ? tep_draw_hidden_field('stock', $HTTP_GET_VARS['stock']) : '');.

Echo ((isset($HTTP_GET_VARS['search'])) ? tep_draw_hidden_field('search', $HTTP_GET_VARS['search']) : '');.

Echo '</form>';.

?>.

</td></P> <P> <td class="smallText" align="right">.

<?php.

Echo tep_draw_form('goto', FILENAME_PRODUCT_LIST, '', 'get');.

Echo 'Stock qty: '' 'tep_draw_pull_down_menu('stock', $stock_array, '', 'onChange="this.form.submit();"');.

Echo ((isset($HTTP_GET_VARS['cPath'])) ? tep_draw_hidden_field('cPath', $HTTP_GET_VARS['cPath']) : '');.

Echo ((isset($HTTP_GET_VARS['search'])) ? tep_draw_hidden_field('search', $HTTP_GET_VARS['search']) : '');.

Echo '</form>';.

?>.

</td>.

</tr></table></td>.

<?php //oscworker end; ?>.

</tr></P> <P> <?php.

If($_REQUEST['Update']=="Success").

{.

?>.

<tr><td><font color="#FF3333">Record has been updated successfully</font></td></tr>.

<?php.

}.

?>.

<tr>.

<td valign="top" colspan="2">.

<form name="form1" method="POST" action="product_list.php">.

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

<tr class="dataTableHeadingRow">.

<td class="dataTableHeadingContent" width="15%"><?php echo TABLE_HEADING_PART_NO; ?>.

</td>.

<td class="dataTableHeadingContent" width="43%"><?php echo TABLE_HEADING_NAME; ?>.

</td>.

<td class="dataTableHeadingContent" width="10%"><?php echo TABLE_HEADING_PRICE; ?>&nbsp;.

</td>.

<td class="dataTableHeadingContent" width="10%"><?php echo TABLE_HEADING_WEIGHT; ?>&nbsp;.

</td>.

<td class="dataTableHeadingContent" width="12%"><?php echo TABLE_HEADING_STOCK_LEVEL; ?>&nbsp;.

</td>.

<td class="dataTableHeadingContent" width="12%"><?php echo TABLE_HEADING_STATUS; ?></td>.

</tr>.

<?php</P> <P> while($product = tep_db_fetch_array($product_query)).

{.

?>.

<tr valign="top" >.

<td valign="top" class="dataTableContent"><?php echo $product['products_model']tep_draw_hidden_field('products_id[]', $product['products_id']);?></td></P> <P> <td width="20%" valign="top" class="dataTableContent">.

<?php.

Echo $products_name=$product['products_name'];.

//$description1 =substr($products_name, 0, 45);.

//echo $description1.".....";.

?>.

</td>.

<td valign="top" class="dataTableContent"><input type="text" name="price[]" id="price_<?php echo $product['products_id'];?>" value="<?php echo $product['products_price'];?>" size="6" onKeyUp="updateGross(<?php echo ((tep_not_null($product['tax_rate'])) ? $product['tax_rate'] : 0)?>, <?php echo $product['products_id'];?>)"></td></P> <P> <td valign="top" class="dataTableContent"><input type="text" name="weight[]" id="weight" value="<?php echo $product['products_weight'];?>" size="6"></td></P> <P> <td valign="top" class="dataTableContent"><input type="text" name="qty[]" id="qty" value="<?php echo $product['products_quantity'];?>" size="6"></td>.

<td valign="top" class="dataTableContent"><?php if ($products['products_status'] == '1') {.

Echo tep_image(DIR_WS_IMAGES'icon_status_green.gif', IMAGE_ICON_STATUS_GREEN, 10, 10)'&nbsp;&nbsp;<a href="'tep_href_link(FILENAME_CATEGORIES, 'action=setflag&flag=0&pID='$products['products_id']'&cPath='$cPath)'">'tep_image(DIR_WS_IMAGES'icon_status_red_light.gif', IMAGE_ICON_STATUS_RED_LIGHT, 10, 10)'</a>';.

} else {.

Echo '<a href="'tep_href_link(FILENAME_CATEGORIES, 'action=setflag&flag=1&pID='$products['products_id']'&cPath='$cPath)'">'tep_image(DIR_WS_IMAGES'icon_status_green_light.gif', IMAGE_ICON_STATUS_GREEN_LIGHT, 10, 10)'</a>&nbsp;&nbsp;'tep_image(DIR_WS_IMAGES'icon_status_red.gif', IMAGE_ICON_STATUS_RED, 10, 10);.

}.

?></td>.

</tr>.

<?php.

}.

?>.

<tr>.

<td></td>.

<td></td>.

<td></td>.

<td class="dataTableContent">.

<input type="hidden" name="prod_search" value="<?php echo $_REQUEST['prod_search']; ?>"><input type="submit" name="update" value="update">.

<?php.

If(tep_not_null($HTTP_GET_VARS['search'])) echo tep_draw_hidden_field('search', $HTTP_GET_VARS['search']);.

If(tep_not_null($HTTP_GET_VARS['cPath'])) echo tep_draw_hidden_field('cPath', $HTTP_GET_VARS['cPath']);.

If(tep_not_null($HTTP_GET_VARS['stock'])) echo tep_draw_hidden_field('stock', $HTTP_GET_VARS['stock']);.

?>.

</td>.

</tr>.

</table>.

</form>.

</td>.

</tr>.

</table>.

</td>.

</tr>.

</table></P> <P><! body_text_eof //>.

<! body_eof //>.

<! footer //>.

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

<! footer_eof //>.

</body>.

</html>.

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

Comment #18

With the current code from a contribution I receive the dreaded =.

1054 - Unknown column 'p.products_tax_class_id' in 'on clause'.

Select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight, p.products_tax_class_id, tr.tax_rate from products p, products_description pd left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id where p.products_id = pd.products_id and pd.language_id = '1'.

[TEP STOP].

Here is what I think is the offending code =.

If(isset($HTTP_GET_VARS['cPath']) && $HTTP_GET_VARS['cPath'] != 0){.

$current_category_id = $HTTP_GET_VARS['cPath'];.

$product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight, p.products_tax_class_id, tr.tax_rate from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd inner join "TABLE_PRODUCTS_TO_CATEGORIES" p2c on p.products_id = p2c.products_id left join "TABLE_TAX_RATES" tr on p.products_tax_class_id = tr.tax_class_id where p.products_id = pd.products_id and pd.language_id = '"(int)$languages_id"' and p2c.categories_id = "(int)$HTTP_GET_VARS['cPath']$search_qry$stock_qry);.

} else {.

$product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight, p.products_tax_class_id, tr.tax_rate from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd left join "TABLE_TAX_RATES" tr on p.products_tax_class_id = tr.tax_class_id where p.products_id = pd.products_id and pd.language_id = '"(int)$languages_id"'"$search_qry$stock_qry);.

$current_category_id = '';.

}..

Comment #19

Jim,.

I cannot remember exactly what was changed, but my post here:.

Http://forums.oscommerce.com/index.php?sho...p;#entry1147359.

Shows a before and after code that fixes this problem. If you compare the two boxes and apply the same concept to your page it should work..

Tim..

Comment #20


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

 

Categories: Home | Diet & Weight Management | Vitamins & Supplements | Herbs & Cleansing |

Sexual Health | Medifast Support | Nutrisystem Support | Medifast Questions |

Web Hosting | Web Hosts | Website Hosting | Hosting |

Web Hosting | GoDaddy | Digital Cameras | Best WebHosts |

Web Hosting FAQ | Web Hosts FAQ | Hosting FAQ | Hosting Group |

Hosting Questions | Camera Tips | Best Cameras To Buy | Best Cameras This Year |

Camera Q-A | Digital Cameras Q-A | Camera Forum | Nov 2010 - Cameras |

Oct 2010 - Cameras | Oct 2010 - DSLRs | Oct 2010 - Camera Tips | Sep 2010 - Cameras |

Sep 2010 - DSLRS | Sep 2010 - Camera Tips | Aug 2010 - Cameras | Aug 2010 - DSLR Tips |

Aug 2010 - Camera Tips | July 2010 - Cameras | July 2010 - Nikon Cameras | July 2010 - Canon Cameras |

July 2010 - Pentax Cameras | Medifast Recipes | Medifast Recipes Tips | Medifast Recipes Strategies |

Medifast Recipes Experiences | Medifast Recipes Group | Medifast Recipes Forum | Medifast Support Strategies |

Medifast Support Experiences |

 

(C) Copyright 2010 All rights reserved.