If statement duplicating mysql records?
| From: | Jason Pruim | Date: | Tue, 19 Jun 2007 20:11:49 +0000 |
| Subject: | If statement duplicating mysql records? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-257460@lists.php.net to get a copy of this message | ||
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
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! :)