Choosing Home Page Products

[donhinio]

Hello All,

 

Does anybody know an easy way to select which products I would like to be shown on the home page as opposed to the last ones that I added?

 

Many thanks,

Donhinio.

[moonbeam]

Install the Featured Products contribution. It allows you to select the products you wish to display. Get it here Featured Products. That is the easiest way I can think of.

 

Good luck,

Moon

[donhinio]

Hello,

 

I am trying to install the Featured Items contribution as suggested (and nearly finished), but have two questions:

 

1) Which directory/folder do I place the file: featured_products.sql

2) I am very new at this, and want to know if there is a simple way to run it's contents without having to use a php editor?

 

Many thanks for your help,

Donny.

[♥Monika in Germany]

Hello,

 

I am trying to install the Featured Items contribution as suggested (and nearly finished), but have two questions:

 

1) Which directory/folder do I place the file: featured_products.sql

2) I am very new at this, and want to know if there is a simple way to run it's contents without having to use a php editor?

 

Many thanks for your help,

Donny.

 

an sql file has to run in yoru database, not in php. Open your webhosts cPanel and find the phpmyadmin tool that you should have. lick on your database and then on the SQL tab ... there will be a window where you copy the content of the file in. Then click ok.

[donhinio]

Monika,

 

Thanks for that, but I get the error message:

 

SQL query:

 

INSERT INTO configuration_group( configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible )

VALUES (

 

'39', 'Featured', 'Featured Products Display', '339', '1'

)

MySQL said:

 

#1146 - Table 'webta2_featuredproductssql.configuration_group' doesn't exist

 

Thanks,

Donny.

[♥Monika in Germany]

Monika,

 

Thanks for that, but I get the error message:

 

SQL query:

 

INSERT INTO configuration_group( configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible )

VALUES (

 

'39', 'Featured', 'Featured Products Display', '339', '1'

)

MySQL said:

 

#1146 - Table 'webta2_featuredproductssql.configuration_group' doesn't exist

 

Thanks,

Donny.

 

well check your database ... sure you have a configuration_group table, maybe with a new alias?

[donhinio]

Monika,

 

You will have to be gentle with me as I am a complete beginner to this.

 

Could you tell me in very simple terms what I need to do to solve this problem.

 

Many thanks,

Donny.

[♥Monika in Germany]

Monika,

 

You will have to be gentle with me as I am a complete beginner to this.

 

Could you tell me in very simple terms what I need to do to solve this problem.

 

Many thanks,

Donny.

 

look at your file includes/database_tables.php

 

search for configuration_group and post that line

[donhinio]

Monika,

 

It reads:

 

define('TABLE_CONFIGURATION_GROUP', 'configuration_group');

 

 

Donny.

[♥Monika in Germany]

Monika,

 

It reads:

 

define('TABLE_CONFIGURATION_GROUP', 'configuration_group');

Donny.

 

that is ok

 

I just went back to your error message

#1146 - Table 'webta2_featuredproductssql.configuration_group' doesn't exist

 

 

and what strikes me is the database name ... how come your database is called

webta2_featuredproductssql

[donhinio]

Monika,

 

I have taken the sql part from the table name: webta2_featuredproductssql

 

But now I am getting this message:

 

Error

SQL query:

 

INSERT INTO configuration_group( configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible )

VALUES (

 

'39', 'Featured', 'Featured Products Display', '339', '1'

)

MySQL said:

 

#1146 - Table 'webta2_featuredproducts.configuration_group' doesn't exist

 

Thanks,

Donny.