echo sql 或显示“无项目”

Question

需要显示以下内容：

1. 显示某个fabric的所有项目

2. 如果sql中没有可用的fabric，则显示“无结果”

该代码对于第一点来说功能齐全，但不支持第二点功能。 非常感谢您的帮助。

//echo $sql;

$data = "";
$ii = 0;
$m = 0;
while($myrow = mysql_fetch_array($result)){
    $ii++;
    $m++;
    if ($m == 1) $data = $data."<div class=\"page current\" id=\"gallery\">";
    elseif ($ii == 1) $data = $data."<div class=\"page\" id=\"gallery\">";

    $data = $data."<a href=\"#\" title=\"".$myrow['name']."\" class=\"show_fabric\" rel=\"".$myrow['id']."\"><img src=\"".$image_directory.$myrow['thumbnail']."\" width=\"100 px\" height=\"100 px\"><div class=\"fb_name\">".$myrow['name']."</div></a>\n";
    if ($ii == 10) {
        $data = $data."</div>";
        $ii = 0;
    }
}
    if ($ii != 10) {
        $data = $data."</div>";
    }

if (empty($data)) echo "No result";
else echo $data;

Answer 1

    if($result && mysql_num_rows($result)>0)
    {
     $data = "";
   $ii = 0;
  $m = 0;
while($myrow = mysql_fetch_array($result)){
    $ii++;
    $m++;
    if ($m == 1) $data = $data."<div class=\"page current\" id=\"gallery\">";
    elseif ($ii == 1) $data = $data."<div class=\"page\" id=\"gallery\">";

    $data = $data."<a href=\"#\" title=\"".$myrow['name']."\" class=\"show_fabric\" rel=\"".$myrow['id']."\"><img src=\"".$image_directory.$myrow['thumbnail']."\" width=\"100 px\" height=\"100 px\"><div class=\"fb_name\">".$myrow['name']."</div></a>\n";
    if ($ii == 10) {
        $data = $data."</div>";
        $ii = 0;
    }
}
    if ($ii != 10) {
        $data = $data."</div>";
    }

    }else
    echo('No Result');

Answer 2

if($result)
{
   while()
  {
   -----
   --
   -
   }
}
else
echo "No Result";

Answer 3

您可以使用以下修改后的代码，但它仍然每十次迭代创建一个新的

。请注意，HTML ID 必须是唯一的。

if ( ( !$result ) || ( 0 == mysql_num_rows( $result ) ) ) {
    echo 'No result';
}
else {
    $data = "";
    $ii = 0;
    $m = 0;
    while ( $myrow = mysql_fetch_array( $result ) ) {
        $ii++;
        $m++;
        if ( $m == 1 ) {
            $data .= '<div class="page current" id="gallery">';
        }
        elseif ( $ii == 1 ) {
            $data .= '<div class="page" id="gallery">';
        }
        $data .= '<a href="#" title="' . $myrow['name'] . '" class="show_fabric" rel="' . $myrow['id'] . '"><img src="' . $image_directory . $myrow['thumbnail'] . '" width="100px" height="100px"><div class="fb_name">' . $myrow['name'] . "</div></a>\n";
        if ( $ii == 10 ) {
            $data .= "</div>";
            $ii = 0;
        }
    }
    if ( $ii != 10 ) {
        $data .= "</div>";
    }
    echo $data;
}