Re: If statement duplicating mysql records?
| From: | Roberto Mansfield | Date: | Tue, 19 Jun 2007 21:10:37 +0000 |
| Subject: | Re: If statement duplicating mysql records? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-257465@lists.php.net to get a copy of this message | ||
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
> }// End of Level 4
> else
> {// Green Highlight
> }// 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.
I don't think IF is the culprit. I'm guessing you have a bad join in
your sql query so you are getting back more records than you expect.
Have you run the query directly in to see what your results are?
Roberto