//select only jobs completed jobs with specific order number
            $result = mysql_query("select jobcomplete from save where ordernumber = '$ordernumber' AND jobcomplete = 'yes'" ) or die ('Error: '.mysql_error ());

        while($row = mysql_fetch_array( $result )) {
                echo $row['jobcomplete'];
}

        if ($row['jobcomplete']= 'yes') {
echo "<h3 style='color: red;'>Is this warranty work?</h3><input type='radio'>";
}
else if ($row['jobcomplete'] == "") {
echo "None warranty work";
}
else {
}