[SOLVED] MySQL UNION Error

[Guest]

What's wrong with my query here?

 

$searchQuery = "(SELECT title, content FROM pages WHERE title LIKE '%$searchString%' OR content LIKE '%$searchString%') UNION ALL (SELECT title FROM albums WHERE title LIKE '%$searchString%') UNION ALL (SELECT title FROM blogs WHERE title LIKE '%$searchString%') UNION ALL (SELECT title, content FROM posts WHERE title LIKE '%$searchString%' OR content LIKE '%$searchString%') UNION ALL (SELECT title, content FROM comments WHERE title LIKE '%$searchString%' OR content LIKE '%$searchString%') UNION ALL (SELECT title, content FROM events WHERE title LIKE '%$searchString%' OR content LIKE '%$searchString%')";

 

I keep getting an invalid query error :\

[maxhugen]

Each select in the union must return the same number of fields. The first select returns 2 fields, the next only 1.