Change default Per Page value and modify a sort order

Zigw · July 18th, 2006, 11:44 AM

Hi,

1. How do I change the default "Per Page" value? We'd like 24 instead of 12 as a default.

2. How do I modify the Product Title sort order to first sort by Manufacturer Name, then Title. I noticed these sorts are defined in upgrade.php and install.php:

Code:

Content visible to verified customers only.

Is there a way to modify code that has already been installed/upgraded?

Thanks,
Zig

Chuck S · July 19th, 2006, 07:21 AM

That might work if thats what you want to do

There is already a sort by manufacturer sort and one for title you want one combined so your second query looks fine. I would use just to be safe though this

ORDER BY disporder,manu DESC, title DESC

Zigw · July 19th, 2006, 10:00 AM

Quote:

That might work if thats what you want to do There is already a sort by manufacturer sort and one for title

Yes, we are already using Manufacturer Name, but would like them sorted by Product Title as well. Currently it sorts by Manufacturer fine, but then by date (earliest to latest), which makes finding specific products difficult if there are lots from the same manufacturer. It would really be great if we could sort by Title after Manufacturer.

Quote:

you want one combined so your second query looks fine. I would use just to be safe though this

ORDER BY disporder,manu DESC, title DESC

So is there a way to do it without having to run install.php or upgrade.php?

Also, how about the default number of products per page in showcat? I didn't see an option in admin to change it from 12.

Thanks!
Zig

Zigw · July 19th, 2006, 11:42 AM

Chuck,

By looking at the showcat.php code, I could see perpage uses thumcols, so I changed "Number of columns for thumbnail pages" in Show Categories admin settings from 4 to 8, and now we have 24 as a default Per Page value.

I'd still like to know how to change that sort without having to reinstall or re-upgrade.

Thanks,
Zig

Quote:

Originally Posted by Zigw

Yes, we are already using Manufacturer Name, but would like them sorted by Product Title as well. Currently it sorts by Manufacturer fine, but then by date (earliest to latest), which makes finding specific products difficult if there are lots from the same manufacturer. It would really be great if we could sort by Title after Manufacturer.

So is there a way to do it without having to run install.php or upgrade.php?

Also, how about the default number of products per page in showcat? I didn't see an option in admin to change it from 12.

Thanks!
Zig

Chuck S · July 19th, 2006, 03:14 PM

Just use phpmyadmin and modify the sort in the sort table of reviewpost

The REPLACE command will replace what is in there

Zigw · July 19th, 2006, 11:54 PM

Thanks. I'm a *total* newbie to MySQL. Is phpmyadmin a 3rd party front-end I need to install, or does it come with RP? Would I also be able to edit post dates with it?

Quote:

Originally Posted by Chuck S

Just use phpmyadmin and modify the sort in the sort table of reviewpost

The REPLACE command will replace what is in there

Chuck S · July 20th, 2006, 09:26 AM

phpmyadmin is available below or may already be in your hosting control panel and all you do is issue that query to the database

http://www.phpmyadmin.net

Zigw · July 20th, 2006, 09:48 AM

Thanks!

BTW, is there any reason why Per Page is limited to 90 in showcat.php? When we use 48 as a default, the 96 entry in the Per Page pull-down is reset to 90 when selected. We don't show any thumbnails at that level, so there is no performance issue with listing 100's of products per page.

Quote:

Originally Posted by Chuck S

phpmyadmin is available below or may already be in your hosting control panel and all you do is issue that query to the database

http://www.phpmyadmin.net