Hello there! Welcome to Youjoomla Support Forums

We are Web Development Company specializing in Joomla Templates , Joomla Extensions and WordPress Themes development . You are not able to see some forum threads due to your memberhip level. To unlock all forums and special customer support please take few moments to signup . If you are just searching for free joomla templates , or free joomla extension support simply head to our Free Joomla Support forums and open a new thread. Our moderators will help you as soon as possible. To spead up the response time please take few seconds and go over forum rules

Have fun!

Ignore stopword "the" when sorting records

08-09-2012, 01:55 PM
# 1 (permalink)
gunpowder
Hello,
I am trying to sort some records so that the stopword "the " and the space is ignored during the sorting, although I still want to have it displayed in the list.
Example:
THE ANVIL
AMORE
THE AZIMUTH
I am trying to modify the file helper.php in modules/mod_yj_newsflash5 by changing line 98 as follows:

Code:

7=>'title ASC',
to

Code:

7=>'TRIM(LEADING \'THE \' FROM cc.title) ASC',
However this does not seem to work and I wonder where else I need to make this change. Any pointer is more than welcome.

Are you sure your are posting in product assigned forum?: Yes

What is your CMS version?: Joomla 2.5

MySQL Version: 5.x

PHP version: 5.x

Link to installation: X-Ray Touring - London

Have you edited any files? If yes tell us which ones.: No

Are you sure your are posting in product assigned forum?: Yes

What is your CMS version?: Joomla 2.5

MySQL Version: 5.x

PHP version: 5.x

Link to installation: X-Ray Touring - London

Have you edited any files? If yes tell us which ones.: Yes
12-11-2012, 03:50 AM
# 2 (permalink)
chuyennhonho
you ask difficult than I would like to learn this
can anyone help?
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

Members Login

Username
Password