Search two fields

[NZ_Kiwis]

I want to search to fields in my MySQL database and list all results... for example it's a news database and I have a search feild and I want to search the header and body cells for a possible match to a string.. like "heineken" and it will show all rows with this word in the header or article cells....

how can i do this?

[leatherback]

hm.. how about:

select HEADER, BODY, TITLE from NEWS WHERE match(HEADER, BODY) against ($SEARCHWORD)

[NZ_Kiwis]

I get this error

$result2 = mysql_query ("SELECT TITLE, BODY FROM RLNZ_NEWS WHERE match(TITLE, BODY) against (`$SEARCHWORD`)");
//select HEADER, BODY, TITLE from NEWS WHERE match(HEADER, BODY) against (`$SEARCHWORD`)
while($row2 = mysql_fetch_array($result2)) {

This gives me this error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /homemysite/public_html/searchnews.php on line 23