Fulltext and INNER JOIN

[garfx]

i'm having problems with the query below:

SELECT feed.id,feed.date,headline,profileID,summary,name, 'feed' as db_name FROM feed INNER JOIN profiles ON profiles.id = feed.profileID WHERE MATCH(headline,summary,name) AGAINST ('$_POST[textsearch]')

where colums headline and summary are in the feed table and name is within the profile table

is this possible?

G

[sneakyimp]

have you tried it?

also, you should be careful of putting userinput directly into a query like that. you should escape any text strings before putting them into a query or you could risk SQL injection.