Hi All,
I'm getting this error:
Parse error: parse error, unexpected T_ELSE in /home/tcclothi/public_html/shop/admin/categories.php on line 902
Here's the code (Line 902 with <------):
<?php
}
$products_count = 0;
if (isset($HTTP_GET_VARS['search'])) {
$products_query = tep_db_query("select p.products_id, pd.products_name,
p.products_quantity, p.products_image, p.products_image_2, p.products_image_3,
p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available,
p.products_status, p2c.categories_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . "
pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id =
'" . (int)$languages_id . "' and p.products_id = p2c.products_id and pd.products_name like
'%" . tep_db_input($search) . "%' order by pd.products_name");
} else {
$products_query = tep_db_query("select p.products_id, pd.products_name,
p.products_quantity, p.products_image, p.products_image_2, p.products_image_3,
p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available,
p.products_status from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " .
TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" .
(int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = '" .
(int)$current_category_id . "' order by pd.products_name");
} else { <-----LINE 902
$products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by pd.products_name");
}
Any help would greatly be appreciated! Thanks!
P.S. I tried removing the semicolon on the line above 902 but then got the following error:
Parse error: parse error, unexpected '}'