Change PHP page to exclude some subcategories from sorting

Completed Posted Jan 14, 2015 Paid on delivery
Completed Paid on delivery

My website has a page displaying over 200 names. Each name is a subcategory from a table. The page displays the names alphabetically except a few which are excluded. The excluded subcategories get displayed at the end (also alpha).

The php file that handles this display is I think building the page with a query matching by text string like SELECT * FROM table GROUP BY col AND NOT (subcat=99 OR subcat=123 OR subcat=199);

but it would be better if it could use something like the following query: SELECT * FROM table WHERE (subcat BETWEEN 1 AND 200) AND NOT (subcat=99 OR subcat=123 OR subcat=199);

I would like the coder to fix the page so that renaming subcategories doesn't break the sort. I don't know PHP or where exactly this file goes in codeigniter so will need help. The attached image shows five examples that should be excluded from the main sort.

Codeigniter MySQL PHP

Project ID: #6979370

About the project

7 proposals Remote project Active Jan 14, 2015

Awarded to:

nittilegupta

Hi, I have worked for nearly 1000 hours on codeIgniter. I can fix this issue in a day. regards, Nittile

$34 USD in 0 days
(90 Reviews)
8.0

7 freelancers are bidding on average $25 for this job

webexesolution

Hello, I have carefully evaluate your requirements and I believe that my skills is set and i am Expert Web Developer having more than 3+ years of experience and also I am working with latest technology such as : PH More

$25 USD in 1 day
(29 Reviews)
4.7
Softeria

A proposal has not yet been provided

$30 USD in 1 day
(9 Reviews)
4.0
diptanil

I run a web design firm. We also host websites. We can get the job done easily. Pay only after completion.

$10 USD in 0 days
(0 Reviews)
0.0
okagartria

Proposal belum diberikan

$25 USD in 0 days
(0 Reviews)
0.0
mohammedrajab

Hi sir, I'm experience on CodeIgniter for more than 3 years You can hire me and i will solve issues thank you

$25 USD in 1 day
(0 Reviews)
0.0