php mysql html标签_HTML标签格式化PHP和MySQL

我有这个MySQL语句

Select type.type, color.color, ShotName, Item.name, Item.Item_id

From type

Inner Join Item

On type.type_id =Item.type_id

Inner Join color

On color.color_id =Item.color_id

Where Item.state=0 And Item.offline = 0

Group By color.color, Item.name, type.order_nr

Order By type_D.order_nr, color.color, Item.name_d如何做到这一点与PHP获得格式化为下面的HTML格式的结果？我已经设法列出项目，但我无法正确放置

Type AA

color black

• ShortName 1 name 1
• ShortName 2 name 2
• ShortName 3 name 3
• ShortName 4 name 4
• ShortName 5 name 5

color green

• ShortName 7 name 7
• ShortName 8 name 8
• ShortName 9 name 9
• ShortName 10 name 10
• ShortName 11 name 11

Type AB

color black

• ShortName 12 name 12
• ShortName 13 name 13
• ShortName 14 name 14
• ShortName 15name 15
• ShortName 16name 16

color green

• ShortName 17 name 17
• ShortName 18 name 18
• ShortName 19 name 19
• ShortName 20 name 20
• ShortName 22 name 22

这是我的PHP代码

$myfile = mysql_query($query_myfile, $db) or die(mysql_error());

$totalRows_myfile = mysql_num_rows($myfile);

while ( $row_myfile = mysql_fetch_assoc($myfile) )

{

if ( $type != $row_myfile[ 'type' ] )

{

$type = $row_myfile[ 'type' ];

echo "

$type

";

}

if ( $color != $row_myfile[ 'color' ] )

{

$color = $row_myfile[ 'color' ];

echo "

$color

";

}

echo "

";

echo $row_myfile['ShortName'].' ';

echo $row_myfile['name']; ?>