loop?

[seby]

Greetings.

I have this query which works fine, but it's only returning one result when it should be returning 6.

how do i loop it so it returns more results?, there are plenty of results and its only getting one.

  $related = $db->sql("SELECT * FROM $table WHERE category = '$content' ORDER BY id ASC LIMIT 6");
      while ($row = mysql_fetch_array($related)) {
          $id = $row[0];
          $time = $row[3];
          $topic = $row[4];
		  $date = date("m/d/Y", $time);
          $related_stories = "<b>&raquo;</b> <a href=\"/view.php?id=$id\">$topic</a> - $date<br/>";

[GSHelpBoy]

Are you using $related_stories to output all the stories?

If you are, the problem is each time it loops, it overwrites the previous $related_stories.

You should do this instead:

<?php
$related = $db->sql("SELECT * FROM $table WHERE category = '$content' ORDER BY id ASC LIMIT 6");
while ($row = mysql_fetch_array($related)) {
    $id = $row[0];
    $time = $row[3];
    $topic = $row[4];
    $date = date("m/d/Y", $time);
    $related_stories[] = "<b>&raquo;</b> <a href=\"/view.php?id=$id\">$topic</a> - $date<br/>";
}
?>

And then you can use a for () loop to output each story.

[seby]

i've never used for()

how do i incorporate it?