DEAMweaver 提示:
MySQL Error#: 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 ') AND pro_color_size_id IN (SELECT MIN(pro_color_size_id) FROM 但是网页实际打开没有错误,为什么?有没什么影响?
MySQL Error#: 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 ') AND pro_color_size_id IN (SELECT MIN(pro_color_size_id) FROM 但是网页实际打开没有错误,为什么?有没什么影响?
$query_computer = "SELECT pro_pic_id,product_pic.pro_id, product_pic.pro_pic_name, product_info.pro_sub_class_name, product_info.pro_name, product_info.Pro_descripe,product_info.pro_id, pro_color_size.pro_id, pro_color_size.pro_color_name, pro_color_size.pro_size_name, pro_color_size.yj_price, pro_color_size.pro_color_size_id, product_pic.pro_pic_id FROM product_info, product_pic, pro_color_size WHERE product_info.pro_id=pro_color_size.pro_id AND product_pic.pro_id=pro_color_size.pro_id AND pro_sub_class_name ='电脑' AND pro_pic_id IN (SELECT MIN(pro_pic_id) FROM product_pic GROUP BY product_pic.pro_id) AND pro_color_size_id IN (SELECT MIN(pro_color_size_id) FROM pro_color_size GROUP BY pro_color_size.pro_id)ORDER BY product_info.pro_id DESC";
$computer = mysql_query($query_computer, $web_conn) or die(mysql_error());
$row_computer = mysql_fetch_assoc($computer);
$totalRows_computer = mysql_num_rows($computer);
在Dreamweaver的绑定栏里提示:
MySQL Error#: 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 ') AND pro_color_size_id IN (SELECT MIN(pro_color_size_id) FROM 但是网页打开是没错误的,为什么????