Duplicated results, please help

[GoWFB_SEO]

http://www.topfurniturestores.com/index.php?c=6

Please take a look and you will see the problems, the results appeared twice.
the following is the php code i used:

PHP Code:

switch (TRUE){
//If the score is between 1 and 2, show one star
 case ($score<1):
   if ($row['featured'] =='Y'){echo
   "<a href='".$row['url']."'>" .$row[title]. "</a><a class=moredetail href='moreinfo.php?siteid=".$row['id']."'>(More Detail)</a>";
   }else{
   echo "<a href='".$row['url']."'>" .$row[title]. "</a>";
        }
   break;
   case ($score>=1 AND $score<2):
   if ($row['featured'] =='Y'){echo
   "<a href='".$row['url']."'>" .$row[title]. "</a><a class=moredetail href='moreinfo.php?siteid=".$row['id']."'>(More Detail)</a><img src=images/raing-image/star.png>";
   }else{
   echo "<a href='".$row['url']."'>" .$row[title]. "</a><img src=images/raing-image/star.png>";
        }
   break;
//If the score is between 2 and 3, show two star
  case ($score>=2 AND $score <3):
   if ($row['featured'] =='Y'){
   echo "<a href='".$row['url']."'>" .$row[title]. "</a><a class=moredetail href='moreinfo.php?siteid=".$row['id']."'>(More Detail)</a><img src=images/raing-image/star.png><img src=images/raing-image/star.png>";
   }else{
   echo "<a href='".$row['url']."'>" .$row[title]. "</a><img src=images/raing-image/star.png><img src=images/raing-image/star.png>";
        }
   break;
   //If the score is between 3 and 4, show three star
case ($score>=3 AND $score<4):
   if ($row['featured'] =='Y'){
   echo "<a href='".$row['url']."'>" .$row[title]. "</a><a class=moredetail href='moreinfo.php?siteid=".$row['id']."'>(More Detail)</a><img src=images/raing-image/star.png><img src=images/raing-image/star.png><img src=images/raing-image/star.png>";
   }else{
   echo "<a href='".$row['url']."'>" .$row[title]. "</a><img src=images/raing-image/star.png><img src=images/raing-image/star.png><img src=images/raing-image/star.png>";
        }
   break;
   //If the score is between 4 and 5, show four star
case ($score>=4 AND $score<5):
   if ($row['featured'] =='Y'){
   echo "<a href='".$row['url']."'>" .$row[title]. "</a><a class=moredetail href='moreinfo.php?siteid=".$row['id']."'>(More Detail)</a><img src=images/raing-image/star-red1.png><img src=images/raing-image/star-red1.png><img src=images/raing-image/star-red1.png><img src=images/raing-image/star-red1.png>";
   }else{
   echo "<a href='".$row['url']."'>" .$row[title]. "</a><img src=images/raing-image/star-red1.png><img src=images/raing-image/star-red1.png><img src=images/raing-image/star-red1.png><img src=images/raing-image/star-red1.png>";
        }
   break;
//If the score is 5, then show 5 stars
   case $score==5:
   if ($row['featured'] =='Y'){
   echo "<a href='".$row['url']."'>" .$row[title]. "</a><a class=moredetail href='moreinfo.php?siteid=".$row['id']."'>(More Detail)</a><img src=images/raing-image/star-red.png><img src=images/raing-image/star-red.png><img src=images/raing-image/star-red.png><img src=images/raing-image/star-red.png><img src=images/raing-image/star-red.png>";
   }else{
   echo "<a href='".$row['url']."'>" .$row[title]. "</a><img src=images/raing-image/star-red.png><img src=images/raing-image/star-red.png><img src=images/raing-image/star-red.png><img src=images/raing-image/star-red.png><img src=images/raing-image/star-red.png>";
        }
   break;
} 


[littleFella]

What's the SQL statement?

[GoWFB_SEO]

PHP Code:

$sql= "SELECT * FROM $table_name WHERE accepted='y' ORDER BY....";
$results=mysql_query($sql);
While($row=mysql_fetch_array($results)) 
...... 


it is just normal statement, i don't think the problem lay in here

[littleFella]

I can't see any reasons for the duplications.
I imagine this code is in some sort of a loop. Did you check the loop's logic?

[GoWFB_SEO]

Originally Posted by littleFella

I can't see any reasons for the duplications.
I imagine this code is in some sort of a loop. Did you check the loop's logic?

ya, that's why i am so confused why it got duplicaed content, i will look more into that

[ali_420]

I thiiink the file is being included twice.

[GoWFB_SEO]

Originally Posted by ali_420

I thiiink the file is being included twice.

i checked, the file is only included once, i will double check to make sure


i hate php and mysql

[Optix]

You know you Luurrrrve it realy!!

.~Optix~.