3-probs, 1146 error / logs me out of admin / sort by ascending

[SARAHSL25]

Hi, hope someone can help I am getting the below error when i try to add products in admin to the order

 

Add Product 318 Price: £45.501146 - Table 'ecsw.products_options' doesn't exist

 

SELECT * FROM products_attributes pa, products_options po, products_options_text pot, products_options_values pov WHERE pa.options_id = po.products_options_id and pa.options_id = pot.products_options_text_id and pa.options_values_id =pov.products_options_values_id and products_id ='318'

 

I'd really appricate some help.

 

Also on a different note when i try to search in products it logs me out...

 

and since i'm asking for help .. one more problem i am tying to make the problems sort on my site by model, but i want it asending instead of desending, i have changed the below code but it's not working index.php, am i missing something ?

 

$listing_sql .= ' order by ';

switch ($sort_column) {

case 'PRODUCT_LIST_MODEL':

$listing_sql .= "p.products_model " . ($sort_order == 'a' ? 'asc' : '') . ", pd.products_name";

break;

case 'PRODUCT_LIST_NAME':

$listing_sql .= "pd.products_name " . ($sort_order == 'a' ? 'asc' : '');

break;

case 'PRODUCT_LIST_MANUFACTURER':

$listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

case 'PRODUCT_LIST_QUANTITY':

$listing_sql .= "p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

case 'PRODUCT_LIST_IMAGE':

$listing_sql .= "pd.products_name";

break;

case 'PRODUCT_LIST_WEIGHT':

$listing_sql .= "p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

case 'PRODUCT_LIST_PRICE':

$listing_sql .= "final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

}

 

I'd really appricate any help

 

Cheers

Sarah