duplicated

[defiance]

hi there,,,

i have a query

for ($i = 0; $i <= $noskeyword; $i++) { 

$descriptionQuery="SELECT * 
            FROM news 
            WHERE (
       subject like '%".$keyword[$i]."%'
    or content like '%".$keyword[$i]."%'
       )  ";

    $descriptionResult = mysql_query($descriptionQuery) or die(mysql_error()); 



    while ($rowDescription = mysql_fetch_array($descriptionResult,2)) { 
        $resultOut[] = $rowDescription; 
   } 
} 

so everything works well and the final result is in $resultOut


however my resukt are being duplicated.

do you guys see why is it being duplicated?

thanks

[r937]

either you have duplicated data (which is easy to do, if you load a file twice), or else you have a programming problem

it's real easy to determine which is it, and that is to always test your queries outside of php before embedding them in a php script

this will help you decide whether to post your questions in the mysql forum or the php forum

[defiance]

thanks


i checked my database

there is no duplicated data...

..................................

what should i do?

[defiance]

my quess is that there is something wrong with the for loop.

what i am trying to achieve is that

to search my database which contains keywords ( more than one keyword ) either appear in the subject or content...........

please enlighten me..................

[Teeej]

You should post the whole code.

[defiance]

ah.....

i am sorry

my bad...

i entered the wrong keyword.

now it is working.....
i am sorry once again

and thank you very much for your help,..