Full text search

[garfx]

I'm building a full text search but would like the search term ($id) to search more than on table... can you please help

$query = "SELECT * FROM titles, artists WHERE artists.id = titles.artist_id AND MATCH(artists.artist, titles.title, titles.content) AGAINST ('$id')";

I get the following error (the query work if I search only one table i.e. titles)

Error in query: SELECT * FROM titles, artists WHERE artists.id = titles.artist_id AND MATCH(artists.artist, titles.title, titles.content) AGAINST ('music'). Wrong arguments to MATCH

[Roger_Ramjet]

FTS requires that you create a full text indexe on the table first, and you can't create multi-table index.

To do your search, create a FTS index on each table, then see if this works

$query = "SELECT * FROM titles INNER JOIN artists ON artists.id = titles.artist_id 
WHERE MATCH(artists.artist) AGAINST ('$id') OR MATCH (titles.title, titles.content) AGAINST ('$id')";

And learn to use joins properly, default comma and a join condition in the where clause don't hack it.