Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
188 views
in Technique[技术] by (71.8m points)

php more than 5 items create new div

I am using PHP and MYSQL. here is my code

 <?php 

    $result = mysql_query("SELECT * FROM `item` order by `ID` limit 0, 5");
    $rows = mysql_num_rows ($result); 
    $item = 0 ; 

     while ($item < $rows){

        $title = mysql_result($result,$list,"name");
        $id = mysql_result($result,$list,"ID");
        echo "<div id="new"> $id . $title  </div> ";

     $item++;
    }
     ?>   

My question is that, is it possible if the items are more than 5 (as you can see I limited items), then create a new div id=new to display the rest items?

many thanks in advance

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

Change the while() loop this way:

 echo '<div>'; // Starting DIV
 while ($item < $rows){
    $title = mysql_result($result,$list,"name");
    $id = mysql_result($result,$list,"ID");
    echo "<div id="new"> $id . $title  </div> ";
    $item++;
    echo ($item % 5 == 0) ? '</div><div>' : ""; // Close and Open a New DIV
}
echo '</div>'; // Ending DIV

Happy to Help! :)


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...