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_assoc($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.