 |

Mowbray
User
Mar 25, 2008, 12:32 PM
Post #1 of 3
(202 views)
Shortcut
|
|
List specific records first?
|
Can't Post
|
|
Hello again, I've come across another difficulty that my juicy brain can't seem to solve, although I'm hoping there's an easy fix. It's probably just some little PHP thing. The site I'm working on has a bunch of different brands in a sort of product catalogue. The client has a deal worked out with two of the different brands and wants to list their products first. Unfortunately it's not something that changing the alphabetical order could fix. The brands are all listed under "$record['manufacturer']" and I know I can search for them using "productList.php?manufacturer=Example" However I want it so that when productList.php is loaded it shows "Lamp" brand items first then goes on to do "apple", "bench", "charlie" etc. I'm hoping it's something easy with $options['orderBy'] Any ideas?
|
|
|  |
 |

Dave
Staff
/ Moderator

Mar 25, 2008, 3:04 PM
Post #2 of 3
(199 views)
Shortcut
|
|
Re: [Mowbray] List specific records first?
[In reply to]
|
Can't Post
|
|
Hi mowbray, If it's all in one editor you could add a checkbox field for "featured" and then check the brands that should be listed first and set the orderBy to "featured DESC, manufacturer". Would that work? If not I have some other ideas, I think that one would be simplest, though. Let me know. :) Dave Edis - Senior Developer interactivetools.com
|
|
|  |
 |

Mowbray
User
Mar 25, 2008, 7:17 PM
Post #3 of 3
(194 views)
Shortcut
|
|
Re: [Dave] List specific records first?
[In reply to]
|
Can't Post
|
|
I've used the "featured" check box for something, but that's a great answer. I'll just make one up like "sponsored" or something, and do the same thing. Thanks for the quick help,
|
|
|  |
|