Please help with 4 minor problems

[gmrm]

Hi all zenners,

I have 4 minor pronlems and was wondering if anyone could help me.

1. i get this code when trying to use manufacturers_img.php

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BOX_MANUFACTURER_MAX_LOGOS' at line 6
in:
[select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, mi.manufacturers_url from manufacturers m left join manufacturers_info mi on (m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '1') ORDER BY RAND() LIMIT 0,BOX_MANUFACTURER_MAX_LOGOS]

2. When i refresh the page it goes to the top on all browsers and computers. I want it to refresh and go to the same part of the page i was looking at

3. When i search for products i want to be able to FILTER results by price lowest or highest first not a list of alphabetical letters as all my products in each category start with the same letter.

4. I have the alexa widget in the footer but it stays to the left and i want it in the centre.


I have searhhed the forums and can find threads on some of these issues but there is no answers.

Please help zenners.

Thanks and kind regards from the GMRM team.

p.s my site is my signature so you will see what i mean.

[Dchrastil]

Hi GMRM,

1. The error is being cause by the variable "BOX_MANUFACTURER_MAX_LOGOS" not being defined. It should be an integer so that your SQL statement looks like this:

select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, mi.manufacturers_url from manufacturers m left join manufacturers_info mi on (m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '1') ORDER BY RAND() LIMIT 0,5

* BOX_MANUFACTURER_MAX_LOGOS = 5

I'm not familiar with this variable name though, do you have a module installed that could be causing this error?

Can you post a link to the site so we can take a look at it?

- Danny

[gmrm]

Hi Danny thanks for the reply , my site is my signature as stated in my origanal post. It is a mod off here called manufactures_img.

i know its installed right , just dont know why i'm getting this code. Also i cannot show you live on site as i run a business and it would look unprofessional if i left that where the block should be. Thats the code it shows where the block should be

[kuroi]

It's better to ask one question at a time. Multiple questions are much more likely to go unanswered and are less useful to other users with the same problems as the thread titles are too general.

But let's have a go ...

1. The mod (actually the "Sidebox for list Manufacturers logos") is defective. It's author appears to have forgotten to include the definition for BOX_MANUFACTURER_MAX_LOGOS. As a quick and dirty I recommend that you simply replace it with a numerical value in the module file.

2. This is how web pages work when refreshed.

3. Sounds like you need to turn of the alpha sorter in the Admin. Users can already sort by price, ascending or descending, by clicking on the word price in the listing title bar. You may want to add some styling or change the text to make that more obvious.

4. Insert the following into your stylesheet

.AlexaSiteStatsWidget {
display:block;
width:120px;
margin: 10px auto;
}

[Dchrastil]

well said kuroi

[gmrm]

Kuroi you are an asset to the zen community. I truly appreciate your help.

Many thanks from the GMRM team