help with php and mysql "do/while"

Lazarus

<?php do { ?>
  <tr> 
    <td width="54%" bgcolor="#CCCCCC" class="a"><a href="bulletineboard.php?Showtopic=<?php echo $row_Topic['TopicID']; ?>"><font color="#000000"><?php echo $row_Topic['Topic']; ?></font></a></td>
    <td width="36%" bgcolor="#999999"><font color="#CCCCCC"><?php echo date("r", $row_Topic['Created']);?></font></td>
    <td width="10%"bgcolor="#CCCCCC"><font color="#999999"><?php echo $totalRows_Topic ?></font> </td>
  </tr>
  <?php } while ($row_Topic = mysql_fetch_assoc($Topic)); ?>

how do i get it so It only show the the topicID is change, with this code it's show all the threads also..!! plz help ! 🙂

barand

First, you need a while loop not a do..while as you do not read a row until the end of your first loop with the do..while.

Second, I'm assuming that the variable $totalRows_Topic is a count of the number of records (threads) for each topic.

You do not show the query which gives the result but if you only want changes in topic_id and a count, use a group by clause in the query.

$sql = "select topic_id, topic, created, count(topic_id) as totalRows_Topic from tablename group by topic_id,topic,created"

hth

Lazarus

$query_Topic = "SELECT bulletinboard.TopicID, bulletinboard.Topic, bulletinboard.Created FROM bulletinboard ORDER BY bulletinboard.TopicID";

sorry! 🙂

so how should the first while look like?..

should I make a variable that is the previous topic_ID, and then make a "while $last_ID < $row_Topic['TopicID'] ??

am im right?..

barand

if you use the 'group by' option

<?while ($row_topic = mysql_fetch_array($query_topic)) {?>
<tr> 
    <td width="54%" bgcolor="#CCCCCC" class="a"><a href="bulletineboard.php?Showtopic=<?php echo $row_Topic['TopicID']; ?>"><font color="#000000"><?php echo $row_Topic['Topic']; ?></font></a></td>
    <td width="36%" bgcolor="#999999"><font color="#CCCCCC"><?php echo date("r", $row_Topic['Created']);?></font></td>
    <td width="10%"bgcolor="#CCCCCC"><font color="#999999"><?php echo $totalRows_Topic ?></font> </td>
  </tr>

<?}?>

Lazarus

I thanx u for ur time, but I did make my DB alot better, by make a table with boards,topic, threads!! so now I only have 1 record for 1 topic!!