[SniperTowers]

I have this:

PHP Code:

function listoffers($cat){
    $uid = $_SESSION['id'];
    if($cat == "none"){
    $result = mysql_query("SELECT * from offers ORDER BY `title` ASC");    
    }else{
    $result = mysql_query("SELECT * from offers WHERE categoryID='$cat'");
    }

    while($list = mysql_fetch_array( $result )){
        echo "<img align=\"left\" src=\"images/";
        echo $list['image'];
        echo "\" width=\"120px\" height=\"60px\">";
        echo "<b><a href=\"";
        echo $list['link'];
        echo "\">";
        echo $list['title'];
        echo "</a> | £";
        echo $list['value'];
        echo " | ";
    echo $list['value2'];
                echo "%</b><br/>"; 
        echo $list['description'];


        echo " <br/><b><a style=\"float: right\" href=\"completed.php?offer=";
        echo $list['id'];
        echo "&user=";
        echo $uid;
        echo "\">Completed</a></b><br/><br/>";  
}} 

How would I fix it so if ['value'] equals 0.00 don't show and show ['value2'] instead, and if ['value2'] equals 0 don't show and show ['value'] instead.

Thanks.

[UnrealEd]

use an if...

edit: or better, use the max function