PEAK XOOPS - mysql_query() error in englishin japanese

Top > XOOPS Modules >Protector >mysql_query() error

mysql_query() error

List posts in the topic

question mysql_query() error

msg# 1
depth:
0
Previous post - Next post | Parent - Children.1 | Posted on 2006/6/18 0:58
gruessle  二等兵   Posts: 8
Hello,

I am getting following error from protector.
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


When I add EXPLAIN after SELECT the error becomes like this:
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

When I run the QUERY in phpmyadmin I get no errors and it works fine.

SELECT *  FROM `ty_config` WHERE `conf_title` LIKE '_MI_PROTECTOR%'

You can check the error at
http://www.vmclinks.com/

Thank you

Gruessle
Votes:14 Average:5.71

Posts tree

  Advanced search

Login
Username or e-mail:

Password:

Remember Me

Lost Password?

Register now!