SELECT count(v.id) AS news, count(f.id) AS arts, count(g.id) AS files FROM news v, articles_arts f, download_files g GROUP BY v.id, f.id, g.id
Proszę o pomoc i pozdrawiam.
SELECT count(v.id) AS news, count(f.id) AS arts, count(g.id) AS files FROM news v, articles_arts f, download_files g GROUP BY v.id, f.id, g.id
SELECT count(id) FROM news UNION SELECT count(id) FROM articles_arts UNION SELECT count(id) FROM download_files
SELECT count(id),(SELECT count(id) FROM articles_arts),(SELECT count(id) FROM download_files) FROM news
SELECT count(id) AS news,(SELECT count(id) AS arts FROM articles_arts),(SELECT count(id) AS files FROM download_files) FROM news
<?php if( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, "I couldn't select", '', __LINE__, __FILE__, $sql); } $row = $db->sql_fetchrow($result); 'FILES' => $row['files'], 'NEWS' => $row['news'], 'ARTS' => $row['arts']) ); ?>