Creating a loop

[textbox]

Hello, i wish to create a loop to pull all the information out of my table, instead of just one line.

 

<?php
	//query the database for the comments for this user
	$sql = "SELECT * FROM `comments` WHERE `to` = '$username'";

$result = mysql_query($sql) OR die(mysql_error());
$num=mysql_num_rows($result); 
$from=mysql_result($result,0,"from");
$to=mysql_result($result,0,"to");
$comment=mysql_result($result,0,"comment");

$spacer = "    -    ";
$printcomments = "$from$spacer$comment";

 

Any help would be great!!

[chigley]

This is the code to output multiple database entries with a loop.

 

<?php

$query = mysql_query("SELECT * FROM table WHERE id = 1");

while($row = mysql_fetch_assoc($query)) {
  echo "ID: $row['id']<br />Name: $row['name']<br /><br />";
}

?>

 

Can be adapted to suit your needs