Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Adding Big Images For Products


Sketchy

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

 

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

 

:?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...