php新闻发布系统中所遇到的SQL语法问题

Question

问题相关代码，请勿粘贴截图

运行结果及报错内容

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 'LIMIT 0, 3' at line 1

Answer 1

// 这里有点问题
$query_Rx_news = "SELECT * FROM news where news_title like "%".$keyword."%" ORDER BY news_date DESC";
// 修改（百分号前后用单引号）
$query_Rx_news = "SELECT * FROM news where news_title like '%".$keyword."%' ORDER BY news_date DESC";

// $query_limit_Rx_news这个变量建议打印出来看看sql语句对不对