RE: define my own sort order

This message was sent from: Installation and Configuration
http://forums.oscommerce.com/viewtopic.php?p=227533#227533
----------------------------------------------------------------

[code]//PRODUCT_SORT_ORDER ADDED TO THIS SELECT
	$product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id, p.products_sort_order  from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . $HTTP_GET_VARS['pID'] . "'");
	$product = tep_db_fetch_array($product_query);[/code]

I thought it was in here. i looked at this line:
[code]p.products_sort_order  from " . TABLE_PRODUCTS . " p, " [/code]
and moved the "p" to be one space afdter the comma. but it didnt work. This occurs twice on admin/categories.php and i chnage dboth.
Let me know if you have any insight.

Thanks