Adding Big Images For Products

[Sketchy]

Hey,

 

I am totally new to osCommerce, PHP and MySQL but slowly getting to grips with it all. My post refers to the following FAQ page:

 

http://www.oscommerce.com/community/faq,5-22/q,37

 

What I want to know is, using phpMyAdmin, how do I do the following?

 

-----------------------------------------------------------------

Also add 2 new rows to configuration:

 

insert into configuration values ( '', 'Big Image Width', 'BIG_IMAGE_WIDTH', '250', 'The pixel width of big images', '4', '9', '20010503133311', '20010124173833', '');

insert into configuration values ( '', 'Big Image Height', 'BIG_IMAGE_HEIGHT', '200', 'The pixel height of big images', '4', '10', '20010503133311', '20010124173833', '');

-----------------------------------------------------------------

 

Please can somebody take me through this? I guess its probably the easiest thing in the world when you know how!

 

Thanks a lot

 

Joe

[compugeek2003]

Joseph,

 

Assuming you are in phpmyadmin and have selected your database, there should be an sql section. In that section, there should be a text area box with a heading something like "Run SQL query/queries on database..." . You can simply copy and paste your SQL statements into that box and hit the "go" button. You should receive some kind of notice telling you if the insert was successful or not.

 

Hope this helps,

 

Eric

[Sketchy]

Thanks a lot Eric. That helps but I'm still stuck :oops:

 

Okay, so I go into phpMyAdmin and click on configuration on the left.

 

I click SQL tab and see box that contains:

 

SELECT * FROM `configuration` WHERE 1

 

so on the next line I enter:

 

-----------------------------------------------------------------

 

( '', 'Big Image Width', 'BIG_IMAGE_WIDTH', '250', 'The pixel width of big images', '4', '9', '20010503133311', '20010124173833', '');

( '', 'Big Image Height', 'BIG_IMAGE_HEIGHT', '200', 'The pixel height of big images', '4', '10', '20010503133311', '20010124173833', '');

 

--------------------------------------------------------------------

 

hit go and I get:

 

-------------------------------------------------------------------

 

Database joseph_osc1 - Table configuration running on localhost

Error

 

SQL-query :

 

SELECT *

FROM `configuration`

WHERE 1 (

 

'', 'Big Image Width', 'BIG_IMAGE_WIDTH', '250', 'The pixel width of big images', '4', '9', '20010503133311', '20010124173833', ''

)

 

MySQL said:

 

 

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 '( '', 'Big Image Width', 'BIG_IMAGE_WIDTH', '250', 'The pixel w

 

---------------------------------------------------------------------

 

:?

[compugeek2003]

Joseph,

 

Make sure you overwrite the line that says:

 

SELECT * FROM `configuration` WHERE 1

 

The only thing that should be in the box when you click the "go" button is what you pasted in there.

 

That should hopefully do it.

 

Eric