Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Insert SQL, but how?


NewBudda

Recommended Posts

The instructions read:

 

=======

 

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

| RUN THE SQL |

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

 

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('188', 'Master Password', 'MASTER_PASS', 'yourpassword', 'This password will allow you to login to any customers account.', 1, 23, '2004-06-15 07:10:52', '2004-06-15 07:10:52', NULL, NULL);

 

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

 

What exactly am I meant to do? Do i Insert this into the PHPadmin?

 

Please help!

Open Source Newsletter: PhPList

Open Source Questionnaire: Lime Survey

Link to comment
Share on other sites

The instructions read:

 

=======

 

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

| RUN THE SQL |

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

 

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('188', 'Master Password', 'MASTER_PASS', 'yourpassword', 'This password will allow you to login to any customers account.', 1, 23, '2004-06-15 07:10:52', '2004-06-15 07:10:52', NULL, NULL);

 

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

 

What exactly am I meant to do? Do i Insert this into the PHPadmin?

 

Please help!

 

You need to get into your MySQl control panel. Your host may have to give you the link - it will be something like: http://ipaddress:5555/phpmyadmin/

 

Then you go into the relevant database and use the SQL option which brings up a blank text box - paste the text above into the box and hey presto!

Link to comment
Share on other sites

save the code to a text file on your PC, login to your PHPMYADMIN select the database then select insert from the top menu, browse to the file on your PC and click insert, then at the bottom of your phpmyadmin page click OK

Sometimes you're the dog and sometimes the lamp post

[/url]

My Contributions

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...