how to Execute this SQL statement:

[bibliopolis]

i am trying to put this contribution --QuickSearch searches in Description-- in my site and at the end says

Execute this SQL statement:

INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('Quicksearch searches in description', 'QUICKSEARCH_IN_DESCRIPTION', 'false', 'If set to TRUE the customer can search in descriptions otherwise the search is limited to the product title', 1, 113, '2004-06-10 16:54:12', '2004-06-10 16:42:11', NULL, 'tep_cfg_select_option(array('true', 'false'),');

i dont know how to execute an sql statment and i couldnt find how to do it, if it can be done, from phpadmin

thanks

[mark27uk3]

In phpmyadmin, select your database then click the 'sql' tab at the top of the page. Then paste your sql into the box and click 'go'.

 

Or click 'browse' and select the sql file from your computer and then click 'go'

 

Easy or what??

 

Mark

[bibliopolis]

do i put it like tha or at the end i have to select the

NULL, 'tep_cfg_select_option(array('true', 'false'),');

one of the two ,true or false?

sorry for the stupidnes but it is the first time i see an sql code

any way do u think it makes sense like that. meaning do i put it as it is ?

thank u

[Guest]

Paste this into your SQL text area box in phpMyAdmin and hit go:

INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('Quicksearch searches in description', 'QUICKSEARCH_IN_DESCRIPTION', 'false', 'If set to TRUE the customer can search in descriptions otherwise the search is limited to the product title', 1, 113, '2004-06-10 16:54:12', '2004-06-10 16:42:11', NULL, 'tep_cfg_select_option(array('true', 'false'),');

[bibliopolis]

MySQL said: Documentation

#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 'true', 'false'),')' at line 1

[bibliopolis]

ok if syntax like (\'true\', \'false\'),');

but it dosent work anyway

thanks anyway people

[wizardsandwars]

C'mon guys, this is SQL not PHP, lol.

 

INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('Quicksearch searches in description', 'QUICKSEARCH_IN_DESCRIPTION', 'false', 'If set to TRUE the customer can search in descriptions otherwise the search is limited to the product title', 1, 113, '2004-06-10 16:54:12', '2004-06-10 16:42:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

[Guest]

Got me...forgot to double up on the singles for the select option.

[wizardsandwars]

Thats

 

WizardsandWars 1

Chemo 299