I am sure this should be possible but everything I searched is about some theme question.
How do I change the background color
In Here
or the size of [size=xx-large]size=xx-large[/size]
Thanks
In Here
Warning: mysql_query(): Your query requires a full tablescan (table ty_config, 242 rows affected). Use EXPLAIN to optimize your query. in /home/vmc/public_html/x/modules/protector/class/protector.php on line 44
Dave_L wrote:
EXPLAIN goes before SELECT, not after it.
But you can't just add EXPLAIN to a query in XOOPS, since the query will output diagnostics, not the needed data from the database.
You would run the EXPLAIN query using phpMyAdmin, outside of XOOPS>
SQL query:
EXPLAIN SELECT *
FROM `ty_config`
WHERE `conf_title` LIKE '_MI_PROTECTOR%'
[Edit] [Skip Explain SQL] [Create PHP Code]
table type possible_keys key key_len ref rows Extra
ty_config ALL NULL NULL NULL NULL 242 Using where
This is your first time to enter the administration section. Press the button below to proceed."
Warning: mysql_query(): 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 'EXPLAIN conf_name,conf_value FROM ty_config WHERE conf_title li in /home/vmc/public_html/x/modules/protector/class/protector.php on line 44
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/vmc/public_html/x/modules/protector/class/protector.php on line 45
SELECT * FROM `ty_config` WHERE `conf_title` LIKE '_MI_PROTECTOR%'