按类别循环产品 [英] Loop products by category

问题描述

PHP的新手，请耐心等待.

我有一个SQL查询，该查询从表中提取产品，我需要按类别显示它们:

类别1
产品1
产品2
产品3
类别2
产品1
产品2
产品3

等...

我遵循了一些教程/帖子，但无法显示数据.

感谢您的帮助.

到目前为止，我有这个:

Very new to PHP so please be patient.

I''ve got an SQL query that pulls products from a table and I need to display them in categories:

category 1
product 1
product 2
product 3
category 2
product 1
product 2
product 3

etc...

I''ve followed a few tutorials/posts but cant get the data displaying.

Thanks for any help.

So Far I have this:

<?PHP
$sql = "
    SELECT DISTINCT
        JVPCX.`category_id`,
        JVP.`product_id`,
        JVP.`product_sku`,
        JVP.`product_s_desc`
    FROM
        `jos_vm_product_category_xref` JVPCX
    INNER JOIN `jos_vm_product` JVP
        ON JVPCX.`product_id` = JVP.`product_id`
";
	
$res = mysql_query($sql);
$list = array();
while ( $r = mysql_fetch_object( $res ) )
{
    if ( ! isset( $list[ $r->category_id ] ) )
    {
        $list[ $r->category_id ] = array();
    }

    $list[ $r->category_id ][ $r->product_id ] = array(
        ''SKU''     => $r->product_sku,
        ''Description'' => $r->product_s_desc,
		
	
    );
}
print_r($list);
var_dump($r);
?>

输出为:

数组([5] =>数组([1] =>数组([SKU] => EASY819-AC-RC [描述] =>)[3] =>数组([SKU] => EASY819-DC-RC [描述] =>)[2] =>阵列([SKU] => EASY819-AC-RCX [描述] =>))[6] =>阵列([4] =>数组([SKU] => EASY719-AB-RC [Description] =>)[5] =>数组([SKU] => EASY719-AB-RCX [Description] =>)) )

bool(false)

如上所述，我正在努力实现:

类别1
产品1
产品2
产品3
类别2
产品1
产品2
产品3

感谢您的建议.

The output is:

Array ( [5] => Array ( [1] => Array ( [SKU] => EASY819-AC-RC [Description] => ) [3] => Array ( [SKU] => EASY819-DC-RC [Description] => ) [2] => Array ( [SKU] => EASY819-AC-RCX [Description] => ) ) [6] => Array ( [4] => Array ( [SKU] => EASY719-AB-RC [Description] => ) [5] => Array ( [SKU] => EASY719-AB-RCX [Description] => ) ) )

bool(false)

As I stated above I am trying to achieve:

category 1
product 1
product 2
product 3
category 2
product 1
product 2
product 3

Thanks for the advice.

推荐答案

sql = 选择地区 JVPCX.`category_id`， JVP.`product_id`， JVP.`product_sku`， JVP.`product_s_desc` 从 `jos_vm_product_category_xref` JVPCX INNER JOIN`jos_vm_product` JVP 在JVPCX.`product_id` = JVP.`product_id` ;

sql = " SELECT DISTINCT JVPCX.`category_id`, JVP.`product_id`, JVP.`product_sku`, JVP.`product_s_desc` FROM `jos_vm_product_category_xref` JVPCX INNER JOIN `jos_vm_product` JVP ON JVPCX.`product_id` = JVP.`product_id` ";

res = mysql_query(

res = mysql_query(

sql);

这篇关于按类别循环产品的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！