mysql error... help please =(

[vicodin]

mysql_fetch_array(): supplied argument is not a valid MySQL result resource in (points to where my functions page.)

 

     function SearchIt($search){
if (!empty($search)){
   $search = CheckData($search);	
        $search = explode(" ",$search); 
                 mysql_select_db("mediapil_mkmdata") or die(mysql_error());
                       foreach($search as $words){
                               $query =("SELECT * FROM products WHERE MATCH(keywords) AGAINST('$words')");
                     while ($row = mysql_fetch_array($result)){
                                    echo'My product results';
}
}
}
}

anyone know why its giving that error?

 

[premiso]

Your not running www.php.net/mysql_query on the $query this not having a valid resource.

 

     function SearchIt($search){
if (!empty($search)){
   $search = CheckData($search);	
        $search = explode(" ",$search); 
                 mysql_select_db("mediapil_mkmdata") or die(mysql_error());
                       foreach($search as $words){
                               $query =mysql_query("SELECT * FROM products WHERE MATCH(keywords) AGAINST('$words')");
                     while ($row = mysql_fetch_array($result)){
                                    echo'My product results';
}
}
}
}

[vicodin]

Im a retard... thanks