Re: If statement duplicating mysql records?

Jason Pruim wrote:

Okay, so I have a question... Probably pretty easy, but why would my if statement show more records then what are in the database? if($row[5] =='Level4'){ // White Highlight

            echo "<TR><TD bgcolor=".$Level4.">$row[0] </td>";
            echo "<td bgcolor=".$Level4.">$row[1]  </td>";
            echo "<td bgcolor=".$Level4."><A href ='$row[2]'>Instructions</A></td>";
            echo "<TD bgcolor=".$Level4."><A href='update.php?taskid=$row[0]'>Click here!</A>";
        }// End of Level 4
                             else
               {// Green Highlight
            echo "<TR><TD bgcolor=".$unclassified.">$row[0] </td>";
            echo "<td bgcolor=".$unclassified.">$row[1]  </td>";
            echo "<td bgcolor=".$unclassified."><A href ='$row[2]'>Instructions</A></td>";
            echo "<TD bgcolor=".$unclassified."><A href='update.php?taskid=$row[0]'>Click here!</A>";
                   }// End of Unclassified

Why not do it this way instead. while( $row = mysql_fetch_array($results) ) { $rowColor = $unclassified; // White Highlight if($row[5] =='Level4'){ $rowColor = $Level4; } echo "<TR><TD bgcolor=".$rowColor.">$row[0] </td>"; echo "<td bgcolor=".$rowColor.">$row[1] </td>"; echo "<td bgcolor=".$rowColor."><A href='$row[2]'>Instructions</A></td>"; echo "<TD bgcolor=".$rowColor."><A href='update.php?taskid=$row[0]'>Click here!</A>"; }

If I have a record that matches Level4 it will display both with the $Level4 color and the $unclassified color. Ideally it would only show up under the $Level4 category if it's Level4... If that makes sense. Or is there a better way to do it? Thanks! :) And one of these days, I WILL be able to help answer questions on this list too! :) --PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

-- Jim Lucas "Some men are born to greatness, some achieve greatness, and some have greatness thrust upon them." Twelfth Night, Act II, Scene V by William Shakespeare