Returning data from functions?

[KevinUK]

Hi, I have this function which currently outputs the data but I would like the class calling this function to handle the output instead. How do I go about doing that?

function comments($number) {
	
		$query = "SELECT id,title,comment FROM comment ORDER BY id DESC";
		$result = @mysql_query($query) or die('No ID found');
				
		$count = 0;
		
		while (($row = mysql_fetch_assoc($result)) && ($count < $number)) {
		
			echo $row['title'] . " ";
			echo $row['comment'] . "<br/>";
		
			$count++;		
		}
		mysql_free_result($result);
	}

Main class:

<?php	lastfive::comments(3);	?>

I want to be doing the echo part of the code in the main class instead so my comments function can be more generic.

Thanks, Kevin

[KevinUK]

Oh that function is a mess, its now:

function comments($number) {
	
		$query = "SELECT id,title,comment FROM comment ORDER BY id DESC LIMIT $number";
		$result = @mysql_query($query) or die('No ID found');
	
		while ($row = mysql_fetch_assoc($result)) {
		
			echo $row['title'] . " ";
			echo $row['comment'] . "<br/>";					
		}
		mysql_free_result($result);
	}

[KevinUK]

Well I've done it, is there any optimisation I can do on the class that calls the method though? Seems like I could narrow down the code needed.

[PHP]
$result = lists::comments (3);

while ($row = mysql_fetch_ass oc($result)) {

echo $row['title'];
echo $row['comment'] . "<br/>";
}[/PHP]

[Banfa]

Not suree quite what you mean by that last post, and the code seems quite compact to me already.