MySQL fulltext searching

[Gutya]

I'm trying to build a search engine for my site, but I've struck a problem with my query, anyone know what's wrong with it?

SELECT *
MATCH(title, description)
AGAINST ('$search') AS score FROM videos
WHERE MATCH(title,description)
AGAINST ('$search') ORDER BY score DESC

[elbekko]

SELECT *,
MATCH(title, description)
AGAINST ('$search') AS score FROM videos
WHERE MATCH(title,description)
AGAINST ('$search') ORDER BY score DESC

maybe? If you could give me a small sample of your DB I'd be able to test some more, but I think all you're missing is that comma :)

[Gutya]

Thanks, that solved it.