Codice PHP:
$queryA = @mysql_query("SELECT COUNT(*) AS A FROM `tab1`;", $conn);
$resultA = mysql_fetch_array($queryA);
@mysql_free_result($queryA);
$queryB = @mysql_query("SELECT COUNT(*) AS B FROM `tab2` WHERE (jm_x!='1') AND (jm_y='1');", $conn);
$resultB = mysql_fetch_array($queryB);
@mysql_free_result($queryB);
$queryC = @mysql_query("SELECT COUNT(*) AS C FROM `tab3` WHERE (xx IS NULL);", $conn);
$resultC = mysql_fetch_array($queryC);
@mysql_free_result($queryC);
Chiedo scusa,
È possibile semplificare in mysql queste tre query, o devo lasciarle separate?