current community

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

What is the problem of this mysql syntax? I copied it to phpmyadmin and it worked flawlessly. When I tried to fetch the array from php but it returned a "bool(false)" error.

(
    SELECT 
        id, 
        cim, 
        'news' as kat 
    FROM 
        mbsz_news 
    WHERE 
        cim LIKE '%anystring%' 
        OR lead LIKE '%anystring%' 
        OR content LIKE '%anystring%'
) 
UNION 
(
    SELECT 
        id, 
        p_name, 
        'plaza' as kat 
    FROM 
        mbsz_plazas 
    WHERE 
        p_name LIKE '%anystring%' 
        OR uzemelteto LIKE '%anystring%'
) 
UNION 
(
    SELECT 
        id, 
        cim, 
        'book' as kat 
    FROM 
        mbsz_konyvtar 
    WHERE 
        cim LIKE '%anystring%' 
        OR kszam LIKE '%anystring%' 
        OR kiado LIKE '%anystring%'
)

PHP code:

$res = mysql_query($sql);
while($row = mysql_fetch_array($res))
{
    echo $row['type'];
}

$res gives the error bool(false) Thanks for your help.

share|improve this question
 
Why are there brackets around your query? –  tadman Sep 13 '12 at 14:41
1  
Show us your PHP code –  Mathieu Imbert Sep 13 '12 at 14:41
 
The syntax looks okay (Your union column names aren't the same, but as long as the column types are the same, they should take the first query's names/aliases) - so it probably comes down to your PHP code. –  Fluffeh Sep 13 '12 at 14:45
 
false, indicates no records –  FirmView Sep 13 '12 at 14:46
 
Does mysql_error() return anything? If not, it's not a mysql error. Either no results or a PHP error. –  AndrewR Sep 13 '12 at 14:47
show 9 more comments

1 Answer

up vote 0 down vote

you must declare the sql variable. e.g.

$sql = (
    (SELECT 
        id, 
        cim, 
        'news' as kat 
    FROM 
        mbsz_news 
    WHERE 
        cim LIKE '%anystring%' 
        OR lead LIKE '%anystring%' 
        OR content LIKE '%anystring%'
) 
UNION 
(
    SELECT 
        id, 
        p_name, 
        'plaza' as kat 
    FROM 
        mbsz_plazas 
    WHERE 
        p_name LIKE '%anystring%' 
        OR uzemelteto LIKE '%anystring%'
) 
UNION 
(
    SELECT 
        id, 
        cim, 
        'book' as kat 
    FROM 
        mbsz_konyvtar 
    WHERE 
        cim LIKE '%anystring%' 
        OR kszam LIKE '%anystring%' 
        OR kiado LIKE '%anystring%'
)

)

when the variable is called, the php should work?

$res = mysql_query($sql);
while($row = mysql_fetch_array($res))
{
    echo $row['type'];
}
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.