Union Query

[doddsey_65]

The following union query is supposed to return the total number of alerts and the total number of messages, however a dump of the returned array shows only the alerts(num_alerts).

 

$sql = "SELECT COUNT(a.a_aid) as num_alerts 
                    FROM ".Asf_Db::$prefix."alerts a
                    UNION
                    SELECT COUNT(m.m_mid) as num_messages
                    FROM ".Asf_Db::$prefix."messages m";
                    
            $sth = Asf_Core::$db->prepare($sql);
            $sth->execute() or die(Asf_Core::$db->error($sth, $sql));
            
            $results = $sth->fetch(PDO::FETCH_ASSOC);
            
            dump($results);

 

anyone see where im going wrong?

 

[web_craftsman]

COUNT(*)

[web_craftsman]

ups, have not read correctly.

You need fetch second record also

$result1 = $sth->fetch(PDO::FETCH_ASSOC);
$result2 = $sth->fetch(PDO::FETCH_ASSOC);

[doddsey_65]

erm....no. result1 would be the same as result 2 since its returning the same query

[web_craftsman]

what returns

print $sth->rowCount();

?