php search with UNION - mysql_num_rows error

Question

I am making a simple search system that brings only the amounts of results from the specified tables The problem is that it is causing an error due to the different tables and their lines. Check out my script.

$q = $_GET['busca'];

$query= '
        SELECT * FROM noticia WHERE noticia_title LIKE "%'.$q.'% or noticia_content LIKE "%'.$q.'%"
    UNION
        SELECT * FROM eventos WHERE evento_nome LIKE "%'.$q.'% or evento_content LIKE "%'.$q.'%"
        UNION 
    SELECT * FROM albuns WHERE album_name LIKE "%'.$q.'%" or album_descricao LIKE "%'.$q.'%"  
    ';

    $result = mysql_query($query);
    $count = mysql_num_rows($result);

    if ($count == 0) {
        echo "Nenhum resultado!";
} else {
    if ($count == 1) {
        echo "1 resultado encontrado!";
}
        if ($count > 1) {
        echo "$count resultados encontrados!";
    }
        while ($dados = mysql_fetch_array($query)) {
        echo "";
    }
    }              

The mistake being made is: Warning: mysql_num_rows(): supplied argument is not a Valid Mysql result Resource in

Can someone help me?

Answer 1

As discussed in the comments:

1) Double quotes were missing in the first two selects

SELECT * FROM noticia WHERE noticia_title LIKE "%'.$q.'%" 
SELECT * FROM eventos WHERE evento_nome LIKE "%'.$q.'%"

2) After adding mysql_query($query) or die(mysql_error()); the following error has been identified:

The used SELECT statements have a Different number of Columns

3) To solve this problem you must make a SELECT with the same number of columns. Example:

$query= '
        SELECT noticia_id FROM noticia WHERE noticia_title LIKE "%'.$q.'%" or noticia_content LIKE "%'.$q.'%"
    UNION
        SELECT evento_id FROM eventos WHERE evento_nome LIKE "%'.$q.'%" or evento_content LIKE "%'.$q.'%"
    UNION 
        SELECT album_id FROM albuns WHERE album_name LIKE "%'.$q.'%" or album_descricao LIKE "%'.$q.'%"  
    ';