开发者

Echo each Category from a table into its own DIV

My problem seems complex to me, but im sure theres a simple way to do this.

Essentially, I have a treatments list. On the MYSQL table the list's items are broken up by category, title, description and price.

I need to echo out each category into a div each, sectioning them off. So, if the user has 4 catagories of items then I should have 4 divs with all the items from each category in each.

I cant call on a cataogory directly, because the category names are what ever the user sets them to.

Is there a way to do this? Possibly even a while inside a while with PHP?


@Kaaviar Table column names are in order - Category, Title, Description, Price

@sAc - This is the basic of what im using at the moment, but this just lists everything in order of Category.

  <?php

    include 'config.php';

    $treatments = MySQL_query("SELECT * FROM treatments ORDER BY category") or die (MySQL_error('woops') ); 

    while($list = MySQL_fetch_array($treatments)) {

   echo $list['title'];
   echo $list['description'];
   echo $list['pr开发者_开发技巧ice'];


    } 

    ?>

@Luke - Your code returns nothing here on my end, with the necessary edits etc.

Thanks, Warren


You can try the below, obviously you dont have to use the markup I have demo'ed.

$string = '<div><ul>';
$cat = '';
while ($row = mysql_fetch_assoc($result)) {
  if ($row['category'] != $cat && !empty($cat)) {
    $string .= '</ul></div><div><ul>';
  }
  $string .= '<li>' . $row['title'] . '</li>';
  $cat = $row['category'];
}
$string .= '</ul></div>';

Hope it helps

Luke

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜