<?php
include("conn.php");
$rs=mysql_query("
SELECT products_des_options_values.options_values
FROM products_des_options_values
JOIN products_des_attributes ON products_des_options_values.id = products_des_attributes.products_des_options_values_id
JOIN products ON products.id = products_des_attributes.products_id
join products_des_options on products_des_options.id = products_des_attributes.products_des_options_id
WHERE product_type='41' and STATUS !='D' and products_des_options.id =31 and ppcode like '%ACK2804N%'
order by products_des_options_values.options_valuesunionSELECT products_des_options_values.options_values
FROM products_des_options_values
JOIN products_des_attributes ON products_des_options_values.id = products_des_attributes.products_des_options_values_id
JOIN products ON products.id = products_des_attributes.products_id
join products_des_options on products_des_options.id = products_des_attributes.products_des_options_id
WHERE product_type='41' and STATUS !='D' and products_des_options.id =35 and ppcode like '%ACK2804N%'
order by products_des_options_values.options_values "); while($row=mysql_fetch_array($rs) and $row2=mysql_fetch_array($rs2))
{
echo $V="$row[options_values]<br/> ";
echo $A="$row2[options_values]<br/>";
echo $V * $A."<br/><br>";
}
?>我在phpmydamin下运行,老是报错:#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 'SELECT options_values FROM products_des_options_values JOIN products_des_attribu' at line 2
include("conn.php");
$rs=mysql_query("
SELECT products_des_options_values.options_values
FROM products_des_options_values
JOIN products_des_attributes ON products_des_options_values.id = products_des_attributes.products_des_options_values_id
JOIN products ON products.id = products_des_attributes.products_id
join products_des_options on products_des_options.id = products_des_attributes.products_des_options_id
WHERE product_type='41' and STATUS !='D' and products_des_options.id =31 and ppcode like '%ACK2804N%'
order by products_des_options_values.options_valuesunionSELECT products_des_options_values.options_values
FROM products_des_options_values
JOIN products_des_attributes ON products_des_options_values.id = products_des_attributes.products_des_options_values_id
JOIN products ON products.id = products_des_attributes.products_id
join products_des_options on products_des_options.id = products_des_attributes.products_des_options_id
WHERE product_type='41' and STATUS !='D' and products_des_options.id =35 and ppcode like '%ACK2804N%'
order by products_des_options_values.options_values "); while($row=mysql_fetch_array($rs) and $row2=mysql_fetch_array($rs2))
{
echo $V="$row[options_values]<br/> ";
echo $A="$row2[options_values]<br/>";
echo $V * $A."<br/><br>";
}
?>我在phpmydamin下运行,老是报错:#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 'SELECT options_values FROM products_des_options_values JOIN products_des_attribu' at line 2
你的语句,可以合并的,就products_des_options.id有不同吧?