chrometweaks.org

Can I change the name of my web site in iPage?

Click Here To View All Answers...


Got a quick question: Can I change the name of my web site in iPage? Looking forward for any answer or 2. 2nd question I got is.. Sorry for what will probably be a silly question but believe it or not I cannot find any answer to my problem any where in the forum search..

All I want to do is change the way the products are displayed throughout the shop which will include search results and any other product display pages..

Currently, my products display in alphabetical order but I really need them to display with the highest price product at the top of the list and then descending in order of price..

Where will I find the code that controls this..

Please help even if you want to call me daft for asking...

Comments (4)

Yup, but... you might want to make sure and wait for another member here to confirm my answer as I am not completely sure. Better yet, why don't you give a call to the iPage guys because they can answer you better...

Comment #1

I delt with some of that in this thread.

Http://forums.oscommerce.com/index.php?sho...=306310&hl=..

Comment #2

Thanks for that guys, but I changed the index.php under the main root directory as displayed in your reply but it still doesn't work..

It is still displaying in alphabetical order...

Comment #3

So you changed (195):.

For ($i=0, $n=sizeof($column_list); $i<$n; $i++) {.

If ($column_list[$i] == 'PRODUCT_LIST_NAME') {.

$HTTP_GET_VARS['sort'] = $i+1'a';.

$listing_sql .= " order by pd.products_name";.

To:.

For ($i=0, $n=sizeof($column_list); $i<$n; $i++) {.

If ($column_list[$i] == 'PRODUCT_LIST_PRICE') {.

$HTTP_GET_VARS['sort'] = $i+1'd';.

$listing_sql .= " order by final_price desc";.

And it made no differance!!!! Or did you not read everything?..

Comment #4

OK - I'm a schmuck..

I did read the previous post but just got a wee bit confused over all the changes needed as the examples given were general and I didn't look any further forward than that..

Thanks so much for your help and sorry again.

That worked great but the Whats New Display in the middle of the index page is still showing in alphabetical order, so I assume that bit is controlled via another bit of code in another file somewhere else ? .

In the file new_products.php starting at line 20 it says this:.

If ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {.

$new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from "TABLE_PRODUCTS" p left join "TABLE_SPECIALS" s on p.products_id = s.products_id, "TABLE_PRODUCTS_DESCRIPTION" pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '"(int)$languages_id"' order by p.products_date_added desc limit "MAX_DISPLAY_NEW_PRODUCTS);.

} else {.

$new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from "TABLE_PRODUCTS" p left join "TABLE_SPECIALS" s on p.products_id = s.products_id, "TABLE_PRODUCTS_DESCRIPTION" pd, "TABLE_PRODUCTS_TO_CATEGORIES" p2c, "TABLE_CATEGORIES" c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '"(int)$new_products_category_id"' and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '"(int)$languages_id"' order by p.products_date_added desc limit "MAX_DISPLAY_NEW_PRODUCTS);.

}.

Now is it the line above that says ""order by p.products_date_added desc limit"" the bit that needs changing.

Please don't lose patience with me as this is still my first post.

This post has been edited by.

LaraCroft.

: 07 July 2008, 10:21..

Comment #5


This question was taken from a support group/message board and re-posted here so others can learn from it.